Question
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.
Thanks
Rajesh