Multiple Job using Same Instance

question
,
1

I have multiple jobs running concurrently and some of them use the same instance (same database) and I often get the error from some of the jobs.

"An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and Handling transaction commit failures - EF6 | Microsoft Learn for more information. —> System.Data.SqlClient.SqlException (0x80131904): The transaction operation cannot be performed because there are pending requests working on this transaction. "

This problem can be solved using DisableConcurrentExecution or Limit Worker to 1, are there any possible solution to run jobs concurrently while using the same database resource?

Thanks in advance

2

You could try specifying enlist=false in your connection string to prevent distributed transactions. I’ve never seen this error myself. It could help rule out if the issue is with multiple instances or within the same instance of your application.

3

Thanks for the answer but it didn’t work. Other errors appeared.

“New transaction is not allowed because there are other threads running in the session.”
and also sometimes there are

Additional information : I used MultipleActiveResultSets = true as well in my connections string since I received this error before “There is already an open DataReader associated with this Command”. This error happens only when I run more than 1 job together.