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.
NIIT Technologies Limited
AU
Can you please provide more details about how you parsing CSV or pdn article link?
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
Pegasystems Inc.
IN
check if DL-18625 solves the problem. (this is on PRPC 6.3 SP1)
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.
Pegasystems Inc.
IN
DL-18625: fixes the issue of alternate rows getting skipped while parsing a csv file in PRPC 6.3SP1
Pegasystems Inc.
IN
please go through DL-18625 (from Pega Global support team) if it works for your use case...
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.
PEG
IN
HFix-6765 has been issued for PRPC6.3SP1.
PEG
IN
Hi Indrajit,
To execute final activity in Service-File rule Hfix-4847 needed to apply for PRPC6.2SP2
Virtusa
GB
Please mention how are you saving the record.