Share
ReportSL 2011
SQL 2008
Not running FRx and never have
Running MR2012
We have recently run into an Issue where we receive SQL Server Message 93 when trying to release an AP batch. Now all the AP batches are suspended and we cannot release them.
Microsoft Sql Sever Native client 10.0] Connection busy with results for another command.
Debugging info:Batch_mod_rlsed '030224', 'AP'
Cursor(c_batch) Batch_Mod_Rlsed'030224', 'AP'
optional info: SqlState = HY000 Native Error = 0 ErrorMsg = Microsoft Sql Sever Native client 10.0] Connection busy with results for another command. pcbErrorMsg = 93
ODBCRowNumber =-1 Column =-1 SSrvrLine = 0 SSrvrMsgState=0 SsrvrSeverity = 0 SsrverProcname = SsrvrSrvname =
===========================================================
SQL Server Message 67: [Microsoft][SQL Server Native Client 10.0]Invalid transaction state
Debugging info: DeleteDbConnections - SQLFreeHandle Failed Optional info: SqlState = 25000 NativeError = 0 ErrorMsg = [Microsoft][SQL Server Native Client 10.0]Invalid transaction state pcbErrorMsg = 67
=============================================================
Running the script from B2551470_FRx_SL2011 will not help as we are not running FRx nor did the Below scrip help and I have checked that all custom triggers are "SET NO COUNT ON" and they are.
alter Proc Batch_Mod_Rlsed @parm1 varchar ( 10), @parm2 varchar ( 2) as
Select * from Batch with (nolock)
where BatNbr = @parm1
and Module = @parm2
and Rlsed = 1
*This post is locked for comments
All responses (
Answers (
291,280
