My Oracle Support Banner

MDS First FULL ETL Is Failing With Error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found (Doc ID 2693389.1)

Last updated on JULY 22, 2020

Applies to:

Oracle Product Lifecycle Analytics - Version 3.6.1 and later
Information in this document applies to any platform.

Symptoms

On : 3.6.1.0 version, MDS Load for Agile PLM 9.3.6.12

MDS FULL ETL is failing with cannot CREATE UNIQUE INDEX; duplicate keys found

ERROR
-----------------------
Error,ODI-1217: Session ODI_PKG_MDS_COM_ITEM_SUMMARY (447) fails with return code 12801.
ODI-1226: Step exec of BI_COM_ITEM_F_PRO fails after 1 attempt(s).
ODI-1232: Procedure odi_pro_BI_COM_ITEM_F_PRO execution fails.
ODI-1228: Task Procedure-odi_pro_BI_COM_ITEM_F_PRO-Creating Index ITEM_NEXT_REL_DATE fails on the target connection TRG_BI_PHYSICAL.
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P007
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at line 4

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install OPLA 3.6.1 installation
4. Setup ODI Agent
5. Execute First ETL Stage Full and MDS Full ETL load,

Stage ETL completed and MDS ETL First Full Load failed.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.