SAP Knowledge Base Article - Preview

2378085 - IQ 16 Errors with 'Assertion failed: 200509'


When IQ server suddenly faces 'Assertion failed: 200509', there are a few causing factors.
    1)  By IQ internal problem
           : A certain operation in IQ or SA side, it can cause assertion failed. Recently in IQ16, there are two reference cases CR-786120, 800969.
             This can cause recovery failure in transaction log at start-up. Those known issues are going to be resolved or already fixed.
    2)  By non-IQ problem : For example unexpected overwritten, file-system malfunction....etc
    3)  ...etc ( unknown if there is )

This note is a case study of above '2)' case.

In this case, while server was running, suddenly a customer DB sent 'Assertion failed' error and crash.

     I.  TDS 6: result row: 2016/09/12  3:52:37.127 PM
     I.  TDS 6: request complete
     I.  Starting checkpoint of "TEST" (TEST.db) at Mon Sep 12 2016 15:53
     E. *** ERROR *** Assertion failed: 200509 (
                                 Checksum of critical sectors for page 0 failed

 After the 'Assertion failed', recovery failed at start-up due to invalid transaction log.
     I. Database recovery in progress
     I. Last checkpoint at Mon Sep 12 2016 15:46
     I. Checkpoint log...
     I. Transaction log: /.../TEST/sapdata/log/TEST_log.log...
     E. Error: Cannot open transaction log file -- /../TEST/sapdata/log/TESTlog.log is an invalid transaction log
     E. Cannot open transaction log file -- /../TEST/sapdata/log/TEST_log.log is an invalid transaction log





SAP IQ 16.0


"Assertion failed: 200509" ; "invalid transaction log" ; "Checksum of critical sectors for page" ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.