Microsoft Dynamics Error message

Question Status

Suggested Answer
Denise Strouse asked a question on 28 Jan 2016 9:22 AM

We have received this error message.  Does anyone know what it means or how to fix it?

[Microsoft][SQL Server Native Client 11.0] Invalid transaction state

 

Debugging info: DeleteDbConnection – SQLFreeHandle Failed

Option info:SqlState = 25000 NativeError = 0 ErrorMsg = [Microsoft][SQL

Server Native Client 11.0]Invalid transaction state pcbErrorMsg = 67

Reply
Suggested Answer
Santhosh Dharmar responded on 1 Feb 2016 2:04 PM

We have faced this issue as well and including the  “SET NOCOUNT ON” to custom triggers to resolve this issue.

Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.

Hope it helps

Reply
Suggested Answer
Santhosh Dharmar responded on 1 Feb 2016 2:18 PM

We have faced this issue as well and including the  “SET NOCOUNT ON” to custom triggers to resolve this issue.

Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.

Hope it helps

Reply
Suggested Answer
Santhosh Dharmar responded on 1 Feb 2016 2:04 PM

We have faced this issue as well and including the  “SET NOCOUNT ON” to custom triggers to resolve this issue.

Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.

Hope it helps

Reply
Suggested Answer
Santhosh Dharmar responded on 1 Feb 2016 2:18 PM

We have faced this issue as well and including the  “SET NOCOUNT ON” to custom triggers to resolve this issue.

Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.

Hope it helps

Reply