Out of Memory exception in BP schedules

[kaja.judyta]

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

[chrispotvin]

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

[steven.boggs]

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:

• How can I avoid Out Of Memory issues?
• Why is my large environment getting out of memory errors in the Control Room?
• How to diagnose and report Out Of Memory exceptions

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

[kaja.judyta]

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

[steven.boggs]

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

[kaja.judyta]

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