Rajesh Sekaran (RajeshS66)
CommonWealth Bank of Australia
Senior BPM Analyst
CommonWealth Bank of Australia
RajeshS66 Member since 2020 2 posts
CommonWealth Bank of Australia
Posted: March 11, 2021
Last activity: March 12, 2021
Posted: 11 Mar 2021 21:00 EST
Last activity: 12 Mar 2021 0:08 EST

Xlsx file type processing in Pega

We have a Data Load application where the xlsx files will be attached to Work object. It will be parsed and validated in an activity and finally loaded into the Target tables. I am facing an issue intermittently where the xlsx files loaded to the Work object and submitted is not getting processed but kind of stuck. But this is very strange when the same file is loaded after sometime it gets processed successfully and loaded into the table. It is not happening for all the cases which makes it complex to debug. I am calling MSOParseExcel in an Activity. Will there be an issue in this Parse activity? or something else in the system. Since this is not happening every time I guess there is no issue with MSOParseExcel.  All by Excel Binary template are good. Appreciate if someone can give some insights on this.



Pega Platform 7.2.2 Case Management Financial Services Senior System Architect