Mark Item Completed Time - Execution Expired: Timeout elapsed before the operation completed or the

[Jrwork]

Hey guys!
At times I am facing 'mark item as completed' error - internal error: Execution Expired: Timeout elapsed before the operation completed or the server is not responding. Operation canceled by user.

This error occurs when I have some robots that mark the item in the queue many times almost instantly

The table "BPAWorkQUEueItem" has 35GB in the bank.

What practice to recommend? create a backup of the queues and delete the queues with a lot of processing?

I viewed the machine's capabilities and they are ok.

[SayeedBinAbdullah]

Hi @Jrwork ,

It is recommended to regularly archive old logs and clean up the BPAWorkQUEueItem table to reduce the database load. Additionally, reducing logging levels to capture only errors can minimize data logging. Implementing a policy to periodically delete or archive old queue items can help manage table size, and limiting the number of robots marking items simultaneously can reduce timeout chances.

Best Regards,

Sayeed Bin Abdullah

[david.l.morris]

What we do is copy the work queue items to an archive database on a different database server to maintain our full history of queue items. And then you have multiple options for how to delete the work queue items from the live production database, such as a PowerShell script using CLI commands or even a Blue Prism process that uses the Work Queues internal business object to delete queue items older than a given timeframe.

Take a look at this article https://support.blueprism.com/en/support/solutions/articles/7000076700-troubleshooting-work-queues where there is a section called "Maintaining Work Queues" in which there are links to various options and information.

I also recommend that you create a ticket with Blue Prism Support and let them help you through this. They have a lot of experience with this, and they have database maintenance/housekeeping scripts that they can provide to you. I have run these scripts personally in Blue Prism environments and can confirm they are really good. They are also much more complex than the average person could create on their own, so definitely get those scripts and consider using them. You can run them manually, but you can also have a database administrator set up recurring SQL jobs to do it periodically as well.

As Sayeed said, you need to deal with the logs tables (he's referring to the session logs) and the work queue items tables separately. The built-in archiving only handles session logs. Note that there is also often a need to handle cleaning up other tables such as the tags and audit events tables. Because of the complexity to this, again, I suggest to not try going at this alone and instead reach out to Blue Prism support to create a ticket and get their advice along the way.

[SayeedBinAbdullah]

Thank you for the detailed explanation, @david.l.morris . 

Additionally, I recall that there is an asset on Digital Exchange for purging databases:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/db-servicer

@Jrwork, you might find this useful as well

Best regards,

Sayeed Bin Abdullah

[Jrwork]

Hey masters @SayeedBinAbdullah @david.l.morris , thank you very much for the recommendations and guidance.

I am starting adjustments to resolve the problem and reduce the impacts.