This SqlTransaction has completed it is no longer usable

Xwioch

Hi folks,
I am facing this error for days and I still can't find a solution.
Here is the error:


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.

Xwioch

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.

marica_piazza

Hi Xwioch
Did you solve this issue? We have unfortunately the same problem in NAV2018. We have more services connected to the same SQL and database too, for balancing reasons.
Thank you
Marica

irasoelbaks

Please check for the 'xact abort' setting in SQL. More information can be found on https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/04/15/watch-out-for-zombies-when-using-microsoft-dynamics-nav-with-xact-abort-enabled/

acitro17

HI,

have you solved the problem by any chance. I have the same problem for Microsoft Dynamics Business Central 14

I have 'xact abort' = false