topic RE: Memory Exception in Product Forum

Memory Exception

SpoorthyRajendr — Fri, 06 Sep 2019 11:22:00 GMT

Hello Everyone,

I am facing an issue when I try to execute the process itself as "Internal : Could not execute code stage: Exception of type 'System.OutOfMemoryException' was thrown."

Please anyone tell me how to fix this issue.

------------------------------
Spoorthy Rajendra

------------------------------

RE: Memory Exception

John__Carter — Fri, 06 Sep 2019 13:07:00 GMT

Look at the way you are using collections. Consuming a massive Excel file, and passing multiple instances of a very large collection can drain memory.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Memory Exception

Tejaskumar_Darji — Tue, 27 Oct 2020 12:50:00 GMT

I am facing the same issue. Is there any solution for this? My excel has only 50 rows and 13 columns. I did not got why it throw this error. Looking for solution.

Thanks

------------------------------
Regards,
Tejaskumar Darji
------------------------------

RE: Memory Exception

AndreyKudinov — Wed, 28 Oct 2020 00:11:00 GMT

I've seen some excel files that have sheet.UsedRange something like "A:H" (which means over million rows returned in collection).
Is it only one specific file you are having issue with?

Press Ctrl+End on that sheet in excel and check which row is selected - if it is at the end of file, then you have such file.
Or run this in excel VBA immediate window:
debug.Print ActiveSheet.UsedRange.Address

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------