SAP Knowledge Base Article - Preview

2698755 - Error: Cannot import metadata .. importing SAP IQ 16.1 SP2 in SAP Data Services 14.2 SP10

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

SAP Data Services 4.2

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.