My Oracle Support Banner

Unique Constraint W_ETL_DEFN_STEP_P1 Violated While Building an Execution Plan in DAC (Doc ID 1432964.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

Business Intelligence Applications Observer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Symptoms

While building an execution plan, we get an error that shows a unique constraint violation. I have tried this using both with and without the 'Generate all dependencies' option.

Following is the error thrown:

MESSAGE:::Error while persisting dependency.
EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.persist(ExecutionPlanDesigner.java:1211)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.persist(DefnBuildHelper.java:218)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.persist(DefnBuildHelper.java:148)
com.siebel.analytics.etl.client.view.table.EtlDefnTable.doOperation(EtlDefnTable.java:182)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

::: CAUSE :::
MESSAGE:::Error while inserting steps for execution plan
EXCEPTION CLASS::: com.siebel.analytics.etl.execution.ExecutionPlanInitializationException

com.siebel.analytics.etl.execution.ExecutionPlanDesigner.persistTasksInBatchMode(ExecutionPlanDesigner.java:1480)
com.siebel.analytics.etl.execution.ExecutionPlanDesigner.persistExecutionPlanTasks(ExecutionPlanDesigner.java:1420)
com.siebel.analytics.etl.execution.ExecutionPlanDesigner.persist(ExecutionPlanDesigner.java:1204)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.persist(DefnBuildHelper.java:218)
com.siebel.analytics.etl.client.util.tables.DefnBuildHelper.persist(DefnBuildHelper.java:148)
com.siebel.analytics.etl.client.view.table.EtlDefnTable.doOperation(EtlDefnTable.java:182)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

::: CAUSE :::
MESSAGE:::ORA-00001: unique constraint (DACQA.W_ETL_DEFN_STEP_P1) violated

EXCEPTION CLASS::: java.sql.BatchUpdateException


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
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.