Alternate rows getting skipped while parsing a csv file
Hi,
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.
Infosys Limited
US
Here's the link to PDN article - https://pdn.pega.com/integration/how-to-parse-a-comma-separated-values-csv-file-using-a-file-service
Infosys Limited
US
Can you please give more details on DL-18625?
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.
Infosys Limited
US
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.
