Serial Step "Start Load Plan (InternalID:60163520)" Failed Because Child Step "Global Variable Refr (Doc ID 2152968.1)

Last updated on MARCH 29, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.1 to 11.1.1.9.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------
Parallel step "Parallel (Fact Groups) (InternalID:60811520)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: BOM Serial (InternalID:60931520)

.
Problem Description
=====================
.
Originally the error was on Task SDE_ORA_BOMItemFact.W_BOM_HEADER_DS_OLAP
(Integration) fails on the target ORACLE connection BIAPPS_DW .
Parallel step "Parallel (Fact Groups) (InternalID:60811520)" failed; 1 child
step(s) in error, which is more than the maximum number of allowed errors (0)
defined for the parallel step.  Failed child steps: BOM Serial
(InternalID:60931520)
.
Upon review of the session log it was found that a unique constraint error
showed:
.
 '/* DETECTION_STRATEGY = OUTER */
insert  into PTOSH3_DW.W_BOM_HEADER_DS T
(
GROUP_ID,
EXPLOSION_CODE,
EXPLOSION_MSG,
SRC_EFF_FROM_DT,
DATASOURCE_NUM_ID,
INTEGRATION_ID
.
.
.
)
select GROUP_ID,
EXPLOSION_CODE,
SUBSTR(EXPLOSION_MSG,0,254),
SRC_EFF_FROM_DT,
DATASOURCE_NUM_ID,
SUBSTR(INTEGRATION_ID,0,80)
.
.
.
.
from PTOSH3_DW.I$_364778520_6 S
.
.
where IND_UPDATE = 'I'
(2:49:06 PM) yanisa.mongkalopakorn@oracle.com/YMONGKAL-LAP1 (beehive):
ODI-1228: Task SDE_ORA_BOMItemFact.W_BOM_HEADER_DS_OLAP (Integration) fails
on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (PTOSH3_DW.W_BOM_HEADER_DS_U1) violated
.
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
.
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.ja
va:1115)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
488)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedState
ment.java:3769)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.jav
a:3954)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatem
entWrapper.java:1539)
at
oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
.
at
oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:10
2)
at
oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
.
at
oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecuti
onHandler.java:50)
at
com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at
com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
at

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms