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

This is a common issue for RPA, especially if working with large excel files. As far as I know, there are no 100% solutions, but only methods reduce the symptoms. I have run into this problem several times and these are the ways I would try to handle them:

1. Disable or Errors only for stage logging.
2. Don`t log parameters on action stages (especially ones that work with the excel files)
3. Run Garbage collection process
4. See if it is possible to avoid reading excel files into BP collections and use OLEDB to query the file
5. See if it is possible to increase the Ram memory on the machines
6. If they’re using the 32-bit version of the app, then it doesn’t really matter how much memory you feed it, Blue Prism will cap out at 2 GB.