topic RE: Blue Prism Error Message regarding collections in Product Forum

Blue Prism Error Message regarding collections

BarryBell — Tue, 07 Apr 2020 18:42:00 GMT

Good afternoon, I was looking to import a .csv file into a collection using "Utility File Management" > "Get CSV Text as a Collection". The action pulls in the data but when try to open the collection I get the following error below. There are 88,730 rows in this file and in the collection. Could there be a memory limit I have hit that is causing this?

Thanks

------------------------------
Barry Bell
RPA Manager
DHGLLP
America/New_York
------------------------------

RE: Blue Prism Error Message regarding collections

zdenek.kabatek — Wed, 08 Apr 2020 06:56:00 GMT

Hi, Barry,

yeah, I would say that up to 50.000 rows it is usually fine also depending on number of columns but when getting above this number you should not open the collection. Blue Prism is still 32 bit application so the addressable space is just 1.8 GB. The best approach is to extract only information which you need through i.e. OLEDB approach.

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------