What is the capacity of a BluePrism Internal Work Queue?

Question

I am working in BluePrism Robotics Process Automation and trying to load an excel sheet with more than 100k records (It might go upwards of 300k in some cases). I am trying to load the internal work queue of BluePrism, but I get an error as quoted below:

'Load Data Into Queue' ERROR: Internal: Exception of type 'System.OutOfMemoryException' was thrown.

Is there a way to avoid this problem, in the way where I can free up more memory? I plan to process records one by one from a queue, and put them into new excel sheets categorically. Loading all that data in a collection and looping over it may be memory consuming, so I am trying to find out a more efficient way.

I welcome any and all help/tips. Thanks!

Answer 1

I see you are using excel, there's a workaround that you can use, use OLEDB object to connect and query against it as if it was a database now you can use SQL syntax to limit the number of rows you want to be returned at a time and repeat this process until you reach end of the doc.