System Message 10232 Assertion Failure or a blank screen in Microsoft Dynamics SL

This article provides a solution to a System Message 10232 Assertion Failure or a blank screen when you try to connect to SL.

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

Symptoms

When you try to connect to SL, you receive a System Message 10232 Assertion Failure followed by a Programming Bulletproof Error 10262, or you receive a blank Microsoft Dynamics SL home page.

Microsoft Dynamics SL 2011:

System Message 10232
Assertion Failure!
File sqlodbc.cpp
Line: 5508
Expression: IsValidCursor(cursor)

Followed by:

Programming Bulletproof Error 10262
Invalid cursor value passed to supdate1(). Please make sure cursor value is greater than 0. Also verify that this cursor has been passed to sql()

Microsoft Dynamics SL 7.x:

System Message 10232
Assertion failure!
File: sqlms.cpp
Line: 4490
Expression: IsValidCursor(cursor)

Cause

The No Count property is selected for Database Connection in SQL Server.

Resolution

To correct the issue, clear the No Count property in SQL Server. To do it, follow these steps:

  1. Open SQL Server Management Studio.
  2. Right-click on the server and select Properties.
  3. Select Connections.
  4. Under Default Connection Options, clear the check box for No Count.