Posted: 10 Jul 2015 22:48 EDT Last activity: 4 Oct 2018 11:08 EDT
Alternate rows getting skipped while parsing a csv file
I followed the steps mentioned in one of the PDN article to parse a csv file and created the necessary components (File Listener, Service Package, Service File, Parse Delimited rule, etc). For some reasons, when I run the Service File rule in PRPC, it always skips alternate records in the input csv file. Any inputs on the possible root causes and resolution would be appreciated.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Would it be possible that something in the activity that gets executed while processing each record is causing the rows to be skipped. This entire process is basically for "BulkOperatorLoad" (available in Pega Exchange). I made some changes to this activity to record errors if there's any data that is missing or invalid. I'm calling a Validate rule inside the activity that gets executed when a record gets processed by Service-File rule. Any errors are written to a .txt file using Connect-File rule. If there are no errors, then the operator data is inserted/updated accordingly.
Ok. After some investigation I could find that the culprit was a "FinalActivity" I added to the Service-File rule. This Final Activity involves creating a done.txt file once all the records are processed. This is somehow causing the skipping of alternate rows. I need a FinalActivity to get executed. So any suggestions to overcome this issue retaining FinalActivity of Service-File.
P.S: I would like to keep the HotFix as last resort.