Symptom
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.
Read more...
Environment
-
SAP Data Services 14.2 SP10
-
SAP IQ 16.1.020
Product
Keywords
KBA , EIM-DS-DES , User Interface/Designer , 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.