Views:

Symptoms

When you try to log on to Microsoft Dynamics SL, you receive the following error messages:

 

System Message 10232

Assertion failure!

File: sqlapi.cpp

Line: 10364

Expression: tmpDidErrOccur == noError

Hit OK to stop program, and report the error to Microsoft Support, noting the failed expression, file name and line number.


Programming Bulletproof Error 10262

Invalid cursor value passed to sfetch1(). Please make sure cursor value is greater than 0. Also verify that this cursor has been passed to sql().Assertion Failed: abort=Quit, Retry=Debug, Ignore=Continue

 

Cause

There are two System Databases that are both linked to the same Application Database.

 

Resolution

  1. Open SQL Server Management Studio

  2. Execute the following select statement against each Microsoft Dynamics SL System Database:
    select databasename from domain

  3. If you find the same Microsoft Dynamics SL Application database name listed in more then one system database, it will cause the errors. Update or remove the duplicate record

  4. Open Microsoft Dynamics SL Database Maintenance

  5. Connect to the server

  6. On the Update Databases tab, run the "Synchronize All Ownership and Security" Update Scenario