System Message 6900, 6906 or SQL Server message 62, 63, 67 or 93 when you save or release a batch in Microsoft Dynamics SL 2011

  • Article

This article provides a solution to errors that occur when you save or release a batch in various modules in Microsoft Dynamics SL 2011.

Applies to:   Microsoft Dynamics SL 2011
Original KB number:   2551478

Symptoms

When you save or release a batch in various modules in Microsoft Dynamics SL 2011, you may receive one or more of the following error messages:

System Message 6900 - Another process has updated the %s table. The system will automatically cancel your changes.

System Message 6906 - Another process has deleted the %s item. The system will automatically cancel your changes.

SQL Server Message 93 - [Microsoft][SQL Server Native Client 10.0] Connection is busy with results for another command.
SQL Server Message 62 - [Microsoft][SQL Server Native Client 10.0] Invalid Cursor State.
SQL Server Message 63 - [Microsoft][SQL Server Native Client 10.0]Query timeout expired.
SQL Server message 67 - Invalid transaction state.

Cause

This problem occurs if the Microsoft Dynamics SL Application database contains SQL triggers.

Resolution

To correct this issue, add the following line of code to the beginning of any SQL triggers or of any stored procedures that you apply to the database.

set nocount on