Memory Exception

[SpoorthyRajendr]

​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

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

[John__Carter]

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
------------------------------

[Tejaskumar_Darji]

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
------------------------------

[AndreyKudinov]

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
------------------------------