ERROR: Internal : Execution Timeout Expired

[AtifAbbas1]

Recently we started getting exceptions whenever we have a large volume of concurrent robots running and that ends the process with the following exception: ERROR: Internal : Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding We get the same error (as a popup) from our client side too whenever it is happening for the processes. According to BluePrism support it is because of the 'BPASessionLog_NonUnicode' table that grew too much in size (around 50+ GB) and there also was a DB maintenance PDF that I got from the Documents section. According to the DBA all of the best practices were being followed and we trimmed the table down to 8 GB now. I am still seeing those erorrs. We are trying to reduce the logging throughout all of our processes in Prod (to errors only and only on the stages necessary) but that will take some time. We also toyed around with the logging  options in the process settings but that did not help. I know that there is a setting on the resource level that can turned down to 'log only on errors' type of setting but before that I wanted to see if anyone out there experienced the same and somehow got it resolved? I would really appreciate any feedback pointing me in the right direction. Thanks, Atif Abbas.

[nagagadhiraju]

It happened once for us as well. To resolve this issue we did two things. Increasing the size of memory and by disabling the logging.  

[ApurvaVerma]

By increasing the size of memory do you mean to increase the memory on runtime resource or the database side.

[Oscar_CelioAvi1]

Did you solve this problem? I have the same error, we trimmed the table "BPASessionLog_NonUnicode" down to 10 GB and we did  an archive but still is throwing an error when I use the stage "GET NEXT ITEM". Thanks.

------------------------------
Oscar Celio Avila Castellanos
Ingeniero de sistemas
VASS LATAM
------------------------------

[VIJAYAKUMARRAJA]

Hi, Did you solved this problem? we are facing the same error, and we don't know how to solve.
ERROR: Internal : Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding
------------------------------
VIJAYAKUMAR RAJAN
------------------------------

[EVIPUTI]

Seems like BP database is out of memory , can you do archiving here. I prefer archiving every week to make sure the Session tables are not overloaded . 
Try the options given in the links after saving or taking the necessary backups-
https://stackoverflow.com/questions/1137190/changing-the-commandtimeout-in-sql-management-studio
https://manage.accuwebhosting.com/k...Increase-the-MS-SQL-Remote-Query-Timeout.html

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------