SBX - Search With Button

SBX - Forum Post Title

Database Physical Integrity check crashes

Microsoft Dynamics SL Forum

SLK asked a question on 21 Feb 2018 9:45 AM
My Badges

Question Status

Unanswered

Hello, 

We are working on SL2011 SP1

We noticed a mismatch after having run a GL Integrity Check (01.990.00) I wanted to Validate Application Records by checking Database Physical Integrity (95.500.00) and eventually repair records.

However, the process Validate Application Records always crashes with the following error message;

System Message 10232: Assertion failure!

File: sqlodbc.cpp
Line: 8964

Expression: odbcStmtHandle != SQL_NULL_HSTMT

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

System Message 6130: Fatal error. Process must be stopped at this time

I checked on a few other DB's (Companies) that we have and the problem seems to appear on all of them. 

Anyone here who has a clue what can be done in order to fix this? 

Many thanks

Reply
Carolyn Froton responded on 5 Jun 2018 3:14 PM
My Badges

SLK,

Thank you for posting your question to the forum.

If you look in your Event Log, do you see a log for the integrity? Often there will be an error that comes before the Assertion Failure that is what we would want to look into.

Hope this helps.

Carolyn

MSDSL Technical Support

Reply
SLK responded on 12 Jun 2018 10:16 AM
My Badges

Hello Carolyn and many thanks for picking up this thread.

The integrity check runs normally for some minutes and the section I pasted below is from line 3000 something.  I ran the check on different application databases and it looks as they all crash during RQReqHist and thereafter yield an endless loop of System (error) messages.  

In the log I can however not see that there is any specific message that comes before the Assertion Failure.

Kind regards,

Steve

...

Logical Record

RQReqDet Count: 0

=== RQReqHdr ===

Logical Record

RQReqHdr Count: 0

=== RQReqHist ===

Logical Record


==================================================
System Message 10232: Assertion failure!

File: sqlodbc.cpp
Line:
8964

Expression: odbcStmtHandle != SQL_NULL_HSTMT

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

System Message 6130: Fatal error. Process must be stopped at this time.

System Message 6129: Last item(s) processed: , , , , 
==================================================

System Message 6125: Process ended: Tue Jun 12 04:34 P.M.

Reply
SLK responded on 12 Jun 2018 11:26 AM
My Badges

Hello again,

We should perhaps have done this test before my earlier answer; but, trough a series of trial-and-error-tests we found out that if unchecking RQReqHist and RQVendEval the integrity test passes. It seems however most unlikely that we should have any records in that specific RQ-module(?).

Kind regards.

Steve

Reply

SBX - Two Col Forum

SBX - Migrated JS