This SqlTransaction has completed it is no longer usable

XwiochXwioch Member Posts: 24
Hi folks,
I am facing this error for days and I still can't find a solution.
Here is the error:
amcph9eenri8.png

I have multiple services that connect on the same sql server instance and obviously on the same database.
Our IT Managers did this for balance computing, or at least this is what they said.
This is part of the stack trace, hoping could help:
Type: System.InvalidOperationException
Message: <ii>This SqlTransaction has completed; it is no longer usable.</ii>
StackTrace:
     at System.Data.SqlClient.SqlTransaction.ZombieCheck()
     at System.Data.SqlClient.SqlTransaction.Commit()
     at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass111_0.<ExecuteAction>b__0()
Source: System.Data
HResult: -2146233079
</ii>

When the error occours, the "victim" nav service stop working and all the connected users can't do anything. They must exit and try to login again after few minutes.
The other services still working fine. This happen randomly, I didn't find any event that raise the error.

Answers

Sign In or Register to comment.