SQL Server Message 93 and SQL Server Message 67

(0) Share

Report

Posted on by megland

172

When releasing an AP batch, I get the following error: SQL Server Message 93

[Microsoft][SQL Server Native Client 11.0] Connection is busy with results for another command

Debugging info: Batch_Mod_Rlsed '305806','AP'

Cursor(C_Batch) Batch_Mod_Rlsed '305806, 'AP'

Optional info: SqlState=HY000 NativeError = 0 ErrorMsg = [Microsoft][SQL Server Native Client 11.0]Connection is busy with results for another command pcbErrorMsg = 93

ODBCRowNumber = -1 Column = -1 SSrvrLine = 0 SSrvrMsgState = 0

SSrvrSeverity = 0 SSrvrProcname = SSvrSrvname =

Once checks print out and after processing, I get the following error 'SQL Server Message 67'

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

Debugging info: DeleteDbConnections - SQLFreeHandle Failed

Optional info: SqlState = 25000 Native Error = 0 ErrorMsg = [Microsoft][SQL Server Native Client 11.0] Invalid transaction state pcbErrorMsg = 67

Anyone know what's causing these errors?

megland

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: SQL Server Message 93 and SQL Server Message 67

Thanks all for your input. Good suggestions. Mine is to run this script.

ALTER Proc [dbo].[Batch_Mod_Rlsed] @parm1 varchar ( 10), @parm2 varchar ( 2) as

Select * from Batch with (nolock)

where BatNbr = @parm1

and Module = @parm2

and Rlsed = 1 and status<>'V'

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL Server Message 93 and SQL Server Message 67

Here is a thread from this forum on it:

community.dynamics.com/.../87230.aspx

Was this reply helpful? Yes No