2415829 - SAP IQ restore database returns 'Failed to undo index delete' error

Symptom

Concurrently adding and dropping partitions could lead to multiple entries in the systable for the same primary key value resulting in issues with database recovery. If a backup was taken in this state then the restore of the backup will result in the following error:
I. 01/09 10:01:57. Rollback log...
E. 01/09 10:01:57. *** ERROR *** Assertion failed: 200112 (16.0.0.2195)[a_restore]
Failed to undo index delete
E. 01/09 10:02:02. *** ERROR *** Assertion failed: 106201 (16.0.0.2195)
Unable to undo index changes during rollback

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

Sybase , corruption, stacktrace , stktrc, CR804894, CR804821, 804821 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.