Posted: 17 Jul 2018 21:43 EDT Last activity: 3 Aug 2018 3:29 EDT
File Listener is not committing records to the PEGA Database Table
I have a file listener which reads data from a CSV file and then write them to a database table. Later within the same context(within the listener final (epilog) activity), I am retrieving the data using a data page. Both operations are failing through the listener.
I am retrieving data using another data page from a different table within the listener context which is working fine. (So I believe the DB access and connections are fine)
What is puzzling me more is, I when Irun the service in developer portal, CSV data is processed, commits to the table and Data page populates correctly. Any suggestions for identifying the issue behind this difference would be great. Thank you in advance.
Do you mean the service access group? Right now I gave administrator access group for testing and there are no restrictions with any of the created rules.
I am able to commit data to the table using through the listener(I am using OTB functions to parse now.
I have a Data Page, which uses a Report Definition to populate data. This report definition is having multiple joins(I also tried with sub reports). This Data Page is not loading. However, if I remove joins and run the data page data page gets populated. Any Ideas?
In the Final activity you have to do an explicit commit, Did you get any info from the log file. try putting more log messages to find where it is failing. so you can easily track down. The other idea may be having the file listener to save the changes and commit in the final activity. Have a new batch process to do any further processing on that table? ( not sure your requirement exactly, try if that can be done)