1888470 - IQ How to correct an invalid or corrupt unique IDENTITY / AUTOINCREMENT column which causes ASA error -1002003

• UNIQUE IDENTITY or AUTOINCREMENT column in an IQ database table becomes invalid or corrupt and a load or insert of data fails with

Result Code:Msg 21, Level 14, State 0: ASA Error -1002003: Tried to insert a duplicate value into a unique index

• Failure occurs in module s_ohcins.cxx

• Dropping and recreating the affected index does not resolve the issue

SAP Sybase IQ 12.x, 15.x (not yet validated for IQ 16)

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

IQ 12.6 12.7 15.0 15.1 15.2 15.3 15.4 stack trace , KBA , BC , Basis Components , BC-SYB-IQ , Sybase IQ , Problem

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

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