Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Sql Server Msg 93 - co...
Microsoft Dynamics SL (Archived)

Sql Server Msg 93 - connection is busy with results for another command

(0) ShareShare
ReportReport
Posted on by Kim Huggins 635

We've just gone into production on our upgrade to SL 2011 and have begun to get a variation of the following error.  We didn't see anything like this in the test environment, only began once we went live and it seems to be intermittent. 

Sqyl Server Message 93,

 

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 =

Thanks in advance,

Kim

 

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Sql Server Msg 93 - connection is busy with results for another command

    Hi Cindy and Leonard,

    I have had this issue when I recently upgraded 20 plus app dbs.  However running the FRx fix,, the change on alter Proc Batch_Mod_Rlsed and ensuring that all custom triggers have Set NOCOUNT on got rid of the problem.  BUT I recently added another 3 databases and even though I have done the above, the sql errors 67 and 93 still occur.  

    Any ideas.  There are quite a number of Stored procs as we have some 3rd party addons.

    Peter

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    There is a revised stored procedure that may help.

       â€¢    Symptom - Deleting voucher hangs.

       â€¢    Cause - Bug 23996

       â€¢    Resolution - Running the following on your app DB will prevent this

    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

    Also, check for custom triggers-SQL 2008 is very picky about the "Set Nocount On"

  • Philippe Boulos Profile Picture
    Philippe Boulos 330 on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    It is not FRx related.  I have run the SQL script suggested by Adam Leonard on a client running Dynamics SL FP1 with FRx 6.17SP12 installed.  Does not do anything to help.  Still occurs.  And I noticed that MS did not come back with possible solutions.  I think they are waiting for us to open a pay case to resolve it.

  • Javed Mohammed Profile Picture
    Javed Mohammed 75 on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    Hi,

    We have the same issue after upgrading to SL 2011 and we do not use FRX.

    Any ideas to resolve this would be greatly appreciated.

    Regards,

    Javed.

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    On your server:  Start > run > programs and features (formerly add/remove programs).  

  • Kim Huggins Profile Picture
    Kim Huggins 635 on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    I don't think we've got that installed, where can I go to confirm that?

    Thanks,

    Kim

     

    Also, below is  a 'typical' error we've been encountering :


    SQL Server Message 93: [Microsoft][SQL Server Native Client 10.0]Connection is
                           busy with results for another command

      Debugging
                           info: Batch_Mod_Rlsed '004360', 'AP'
      Cursor(C_Batch)
                           Batch_Mod_Rlsed '004360', 'AP'
      Optional info: SqlState
                           = HY000 NativeError = 0 ErrorMsg = [Microsoft][SQL Server
                           Native Client 10.0]Connection is busy with results for
                           another command pcbErrorMsg = 93
    ODBCRowNumber = -1
                           Column = -1 SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity
                           = 0 SSrvrProcname =  SSrvrSrvname =

    ================================================================================
    System Message 93: [Microsoft][SQL Server Native Client 10.0]Connection is busy
                       with results for another command

     Debugging info: Update
                       pstatus set status = 'E', proctime = 1346853064 WHERE PID =
                       '0340000' AND UserId = 'MCGOVERNC' AND InternetAddress =
                       'RUHLACHMNEWConsole' AND SessionCntr = 9 AND Status = 'S'
     
                       Cursor(Pstatus Update Curso) Update pstatus set status = 'E',
                       proctime = 134685
      Optional info: SqlState = HY000
                       NativeError = 0 ErrorMsg = [Microsoft][SQL Server Native
                       Client 10.0]Connection is busy with results for another
                       command pcbErrorMsg = 93
    ODBCRowNumber = -1 Column = -1
                       SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0
                       SSrvrProcname =  SSrvrSrvname =

    System Message 6127: Error occurred during an abortable transaction.  Processing
                         will continue.
    ================================================================================

    ================================================================================
    System Message 93: [Microsoft][SQL Server Native Client 10.0]Connection is busy
                       with results for another command

     Debugging info: {call
                       UserAccess( 'MCGOVERNC','SOLGBP','RUHLACHMNEWConsole',9 )}
     
                       Cursor(DefaultCreated) UserAccess
                       'MCGOVERNC','SOLGBP','RUHLACHMNEWConsol
      Optional info:
                       SqlState = HY000 NativeError = 0 ErrorMsg = [Microsoft][SQL
                       Server Native Client 10.0]Connection is busy with results for
                       another command pcbErrorMsg = 93
    ODBCRowNumber = -1 Column =
                       -1 SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0
                       SSrvrProcname =  SSrvrSrvname =

    System Message 6127: Error occurred during an abortable transaction.  Processing
                         will continue.
    ================================================================================

    ================================================================================
    System Message 56: [Microsoft][ODBC Driver Manager] Function sequence error

                       Debugging info: SqlCompile - SQLNumResultCols Failed
     
                       Cursor(DefaultCreated) UserAccess
                       'MCGOVERNC','SOLGBP','RUHLACHMNEWConsol
      Optional info:
                       SqlState = HY010 NativeError = 0 ErrorMsg = [Microsoft][ODBC
                       Driver Manager] Function sequence error pcbErrorMsg =
                       56
    ODBCRowNumber = -1 Column = -1 SSrvrLine = 0 SSrvrMsgState
                       = 0 SSrvrSeverity = 0 SSrvrProcname =  SSrvrSrvname =

    System Message 6127: Error occurred during an abortable transaction.  Processing
                         will continue.
    ================================================================================


    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

     

     

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at
    Re: Sql Server Msg 93 - connection is busy with results for another command

    Hi Kim,

    Do you use FRx?  If so you likely need to run the script found here:

    2551470

    "Server Message 93" error message when you release a batch in Microsoft Dynamics SL 2011

    mbs.microsoft.com/.../KBDisplay.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans