Shiva Choppari (ShivaC54)

ShivaC54 Member since 2014 5 posts
Posted: June 16, 2015
Last activity: June 24, 2015
Posted: 16 Jun 2015 7:24 EDT
Last activity: 24 Jun 2015 15:12 EDT

Checkpoint processing on Service File rule


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:

  1. "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.
  2. 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.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.