SAP Knowledge Base Article - Preview

2059563 - Errors when doing a column profile on a DB2 database on tables that have an index associated as a logical file - Data Insight

Symptom

  • Error when attempting Column profile
  • [E] 2014-08-11 11:36:38.116 [TaskUtility][pool-1-thread-1] Failed ATL:
    [W] 2014-08-11 11:36:38.116 [TaskUtility][pool-1-thread-1] Import of ATL failed :: Error com.sap.icc.dataservices.api.DSAPIException: Data Services execution failed for [-IICCDS_63."\"PFFILES\""."\"UBLHR\""]. Error :
    (14.2) 08-11-14 11:36:38 (R) (7356:7668) REP-100112: Initialization Cannot save <Index List> for repository object <ICCDS_63.PFFILES.UBLHR>. Additional database information: <Cannot save <Index Definition> into the repository. Additional database information: <SQL submitted to Oracle Server <(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = linux24)(PORT = 1521)))(CONNECT_DATA =(SID=UGIP)))> resulted in error <ORA-00001: unique constraint (INFO_REPO.SYS_C0042842) violated>. The SQL submitted is <INSERT INTO "AL_INDEX" ("TABLEKEY", "NAME", "INDEXTYPE", "COLNAME","COLPOSITION") VALUES (2938, UNISTR(PFFILES.UBLHRX2), 1, UNISTR(BHVBLD), 1) >.>.>.(14.2) 08-11-14 11:36:38
  • (E) (7356:7668) REP-100112: Initialization Cannot save <Index List> for repository object <ICCDS_63.PFFILES.UBLHR>. Additional database information: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (COR-10690)
  • Error: at com.sap.icc.dataservices.api.ISDSEngine.runImportObject(ISDSEngine.java:360)
     at com.sap.icc.dataservices.api.ISDSEngine.processCaches(ISDSEngine.java:259)
     at com.sap.icc.dataservices.api.ISDSEngine.flush(ISDSEngine.java:125)
     at com.sap.icc.dataservices.api.ISDSEngine.runLocalDsJob(ISDSEngine.java:168)
     at com.sap.icc.dataservices.api.task.ColumnProfilingATLTask.runProfilerStatsTask(ColumnProfilingATLTask.java:279)
     at com.sap.icc.dataservices.api.task.ColumnProfilingATLTask.determineSingleProfilingJobType(ColumnProfilingATLTask.java:210)
     at com.sap.icc.dataservices.api.task.ColumnProfilingATLTask.importSingleProfilingTask(ColumnProfilingATLTask.java:133)
     at com.sap.icc.dataservices.api.task.ColumnProfilingATLTask.generateJobs(ColumnProfilingATLTask.java:113)
     at com.sap.icc.dataservices.api.ExecuteTask.importTask(ExecuteTask.java:78)
     at com.sap.icc.task.DataServiceEngineFacade$1.call(DataServiceEngineFacade.java:70)
     at com.sap.icc.task.DataServiceEngineFacade$1.call(DataServiceEngineFacade.java:68)
     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
     at java.util.concurrent.FutureTask.run(FutureTask.java:138)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
     at java.lang.Thread.run(Thread.java:761)
    Caused by: com.sap.icc.dataservices.api.DSAPIException: Data Services execution failed for [-IICCDS_63."\"PFFILES\""."\"UBLHR\""]. Error :
    (14.2) 08-11-14 11:36:44 (R) (6608:7064) REP-100112: Initialization                                                     Cannot save <Index List> for repository object <ICCDS_63.PFFILES.UBLHR>. Additional database information: <Cannot save <Index                                                     Definition> into the repository. Additional database information: <SQL submitted to Oracle Server <(DESCRIPTION =(ADDRESS_LIST                                                     =(ADDRESS = (PROTOCOL = TCP)(HOST = linux24)(PORT = 1521)))(CONNECT_DATA =(SID=UGIP)))> resulted in error <ORA-00001: unique                                                     constraint (INFO_REPO.SYS_C0042842) violated                                                     >. The SQL submitted is <INSERT INTO "AL_INDEX" ("TABLEKEY", "NAME", "INDEXTYPE", "COLNAME", "COLPOSITION")                                                     VALUES (2939, UNISTR('PFFILES.UBLHRX2'), 1, UNISTR('BHVBLD'), 1)                                                     >.>.>.(14.2) 08-11-14 11:36:44 (E) (6608:7064) REP-100112: Initialization                                                     Cannot save <Index List> for repository object <ICCDS_63.PFFILES.UBLHR>.


Read more...

Environment

  • SAP Information Steward 4.2 and later releases
  • DB2

Product

SAP Information Steward 4.2

Keywords

KBA , EIM-IS-DI , Information Steward - Data Insight , EIM-IS , Information Steward , 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.