You receive the following error when you import table metadata that has primary key index in SAP Data Services Designer:
Error: Cannot import metadata.
Cannot save <Index List> for repository ojbect <Schema_Name.Table_Name>. Additional database information: <Cannot save <Index Definition> into the repository. Additional database information: <SQL submitted to database <DS> resulted in error <[SAP][ODBC Driver][SQL Anywhere]Primary key for table 'AL_INDEX' is not uniquie: Primary key value ('1133, 'ASIQ_IDX_T1722_I26_HG',1')>. The SQL submitted is <INSERT INTO AL_INDEX (TABLEKEY,NAME,INDEXTYPE,COLNAME,COLPOSITION) VALUES (1133,UNISTR('ASIQ_IDX_T1722_I26_HG'), 1, UNISTR('Size'), 1) >.>.>.(BODI-1112338)
Note: Issue does not occur importing table metadata that does not have an index.
SAP Data Services 14.2 SP10
SAP IQ 16.1.020
KBA , EIM-DS-DES , User Interface/Designer , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.