Question
Ford India PVT Ltd
IN
Last activity: 26 Dec 2019 2:03 EST
Exception of type 'System.OutOfMemoryException' was thrown
Hello Team,
It is hard to handle big data with PEGA Robotics. When I tried to read and convert an excel which has more than 2 Lakh rows it faults with the Error Message "Exception of type 'System.OutOfMemoryException' was thrown". Same happens when I try to paste a data table with 2Lakh and more rows.
If you have any correct solution on clearing up the cache or memory, please do assist swiftly. Thank you.
- Jay
P.S. Error Log for your referece:
Autx_IO_Main failed due to the Reason: Autx_IO_ReportsError opening 'C:\Users\Rjayendr\Desktop\Reports\11 Nov 2019\Bible\12-20-2019\Working File.xlsx' workbook. Exception of type 'System.OutOfMemoryException' was thrown.
Pegasystems Inc.
US
Are you using the Microsoft Excel connector or the Excel File connector?
Please open a Service Request so that a support rep can take a look at your problem and assist.
Ford India PVT Ltd
IN
Dear Jeff,
I have tried with PEGA new Excel connector (as old does not supports .xlsx formats and new does not supports .xlsb formats). Also, using the Interop and OLEDB connectors with the script. The script works well and good in the Visual Studio. But when comes inside pega, it again crash with the "Out of Memory" Exception. Hope this additional info helps. Thank you.