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.