replied on November 7, 2019
I have come across this error as well, and I will be following everyone's responses! :)
I have tried a few things over the last couple of weeks, and I've been monitoring what has helped:
1) Our Database Administrator deleted any orphaned sessions/connections in the Workflow database, but this did not appear to help.
2) In the Workflow Administration Console, under Server Configuration / Server Timers, I noticed that there was a Database Maintenance Timer that was set to run hourly - I have changed this to run off of regular business hours, thinking this maintenance might interfere with calls to Workflow (just a guess at this point).
3) In order to eliminate too many calls to one Workflow database, I have started to split off some workflows onto a separate server in hopes of reducing the workload (thinking multiple Workflow evaluations via the Subscriber service might be causing lag on the server).
I'm interested to hear what everyone's experiences have been with this, and what might have worked to reduce or eliminate this error!
Marty Gaffney - Network Analyst
Town of Okotoks