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

  • XwiochXwioch Member Posts: 24
    No one with this kind of problem?
    I'm still having this issue.
    I can add that I'm using NAV 2018 with sql 2016 standard.
Sign In or Register to comment.