SAP Knowledge Base Article - Preview

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

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.