We occasionally have locking issues with our SQL Server 2019 database from a USoft 10.0.1 rules service.
When the load on the system is high, this error occurs sometimes:
HResult of 0x80004005 (-2147467259) returned
Error Source: Microsoft OLE DB Driver 19 for SQL Server
Error Description: Connection is busy with results for another commandMost suggestions seem to centre on using multiple database connection or using MARS.
Does anyone know if either of these are supported by U10.0 (or U10.1)?
Hi Marc,
USoft does not support MARS. As you probably read, MARS is not enabled by default and you cannot specify: "MultipleActiveResultSets=true;" in the USoft database connection string.
The USoft Rules service spawns threads that you know as Rules Engines.
Every Rules Engine has (needs) a dedicated connection to the database server.So we do use multiple connections. A Rules engine processes one statement at a time. It will not accept new statements until the previous call completed.
Therefor the error message you get is an enigma. How can a Rules Service put so much stress on a SQL Server instance that SQL Server will throw this error?
May I suggest you create a Support ticket, so we can investigate this with you?
Regards,
Robert
Thanks for the info, Robert, I’ll create a support ticket for this issue.
Login into the USoft CommunityNo account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
