topic RE: Out of Memory exception in BP schedules in Product Forum

Out of Memory exception in BP schedules

kaja.judyta — Wed, 15 Nov 2023 10:12:00 GMT

Hi,
I am getting Out of Memory exception while expanding schedules section in BluePrism control room tab, error attached below:

I've got same error yesterday while performing the same task. Do you know what might be the reason?

Thanks,

------------------------------
Kaja Nowakowska
------------------------------

RE: Out of Memory exception in BP schedules

chrispotvin — Wed, 15 Nov 2023 13:56:00 GMT

Hi Kaja,

I would open up a ticket with Global Customer Support. If this is in your production environment, classify it as P1. If you are an on-prem customer, you may need to clean out some of your database tables.

Thanks!

------------------------------
Christopher Potvin
Senior RPA Developer
SS&C Blue Prism
Canada
------------------------------

RE: Out of Memory exception in BP schedules

steven.boggs — Wed, 15 Nov 2023 19:05:00 GMT

Hi Kaja,

Typically when OOM scenarios are encountered when accessing areas of the Control Room, this indicates an issue with data volumes in the underlying database -- in this instance, the ScheduleLog or ScheduleLogEntry tables may contain too much data to process at once, using up the available memory on the machine and throwing this exception. We would primarily suggest to work with your DBA to analyze the data volumes in your Blue Prism database and clear down the amount of data using the recommendations in our Maintaining a Blue Prism Database documentation.

In addition, common causes of out-of-memory exceptions and ways to diagnose/troubleshoot them can be found in these Knowledge Base resources:

If the above resources don't help, I would second what Christopher stated and open a ticket with us in Support so we could investigate this scenario, albeit only as a P1 ticket if this is currently preventing your Production environment from functioning entirely (P1 tickets are intended only for complete Production system outages). The information outlined in the 3rd bullet-point's KB article is what we would need to troubleshoot this issue further.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

RE: Out of Memory exception in BP schedules

kaja.judyta — Thu, 16 Nov 2023 14:13:00 GMT

Hello Steve,

Thanks for your reply. Definitely we need to check the database, have you got any queries that we could launch against those two Tables - ScheduleLog or ScheduleLogEntry ?

We could also try to launch Database housekeeping scripts and maybe to expand available memory on the machine.

Thanks,

------------------------------
Kaja Nowakowska
------------------------------

RE: Out of Memory exception in BP schedules

steven.boggs — Thu, 16 Nov 2023 14:53:00 GMT

Hi Kaja,

The easiest way to get a snapshot of the data volumes on the database is to run a Top Tables by Disk Usage report from SSMS (see screenshot below).

To create a Disk Usage by Top Tables report against the relevant Blue Prism SQL database:

This report will show the size on disk of various Blue Prism tables. You can open a ticket with us in Support to request the example Database Housekeeping Scripts which contains guidance and several useful SQL scripts your DBA can review/amend/alter and execute to clear down the data in tables that tend to accumulate and lead to issues like you're seeing.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

RE: Out of Memory exception in BP schedules

kaja.judyta — Thu, 16 Nov 2023 15:11:00 GMT

Thank you,

We have done it already. Here are the results of Top Tables report, alongside with the past Memory Usage of our DB server and Application server:

------------------------------
Kaja Nowakowska
------------------------------