I am parsing a file and pushing the data to db using Service File rule."Record at a time" is selected as the File processing mechanism. I also have given a service activity in the service file rule which is getting executed for each record. As of now, I am doing a commit in the service activity. In case of commit failure, I don't see a way to abort the file processing further.
I have come across Checkpoint processing section in the Service File rule. Need help in getting the below questions answered:
"Frequency" is the number of records for which PRPC does a commit after processing those many records. "Success Criteria" is "When Rule". Now, I want to define the Success Criteria based on the DB commit status done by PRPC after reaching the frequency. How can I achieve this? Is there any OOTB when rule to know the status of the commit done by PRPC. My intention is to rollback on DB Commit failure and stop file processing.
I also see "Processing Epilog" in Service File rule. There is a provision to specify a "Final Activity" which gets executed once the file processing completes. Will this "Final Activity" get executed if the "When rule" memtioned in the Success Criteria returns false i.e. DB commit error in this case.