Exception of type 'System.OutOfMemoryException' was thrown
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.
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.
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.