Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data Load started from BIACM is failing in ODI because of Duplicate Rows and Unique Constraint.

Received Response
61
Views
4
Comments
Akshay Bhan
Akshay Bhan Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

Hi All,

Greetings for the day.

I am working on the Data Load for Finance Module through BIACM and it is linked with ODI already. When I am trying to do Full Load, all the tasks are executing since I am monitoring through ODI but one table has issue and it raises the below mentioned error:

ODI-1228: Task SIL_GLCOGSFact_DiffManLoad.W_GL_COGS_F (Integration) fails on the target ORACLE connection BIAPPS_DW.

Caused By: java.sql.SQLException: ORA-20942: Error while finding/removing duplicates for these key columns :INTEGRATION_ID,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DATASOURCE_NUM_ID => ORA-00955: name is already used by an existing object

ORA-06512: at line 402

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.java:1115)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.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:102)

at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)

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:2123)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1928)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:745)

Any help would be appreciated.

Many Thanks
Akshay Bhan

Answers

  • John_K
    John_K Rank 5 - Community Champion

    In ODI you should be able to see exactly which step of the mapping failed - given the error, I'd say it is either in the index creation stage (for some reason the index wasn't dropped) or one of the temp tables used in data loading already exists. Either way, drilling into the load plan execution will give you a better idea.

  • mmrsherf
    mmrsherf Rank 3 - Community Apprentice

    Hello,

    there is an SR regarding this issue and they provideda solution as it is may be regarding the KM SR 3-16666861888

    Kindly check and execute the steps hopefully will solve your issue.

  • John_K
    John_K Rank 5 - Community Champion

    The OP won't be able to access your SR. Also, I think Oracle don't allow you to post SR numbers on here for some reason.

  • mmrsherf
    mmrsherf Rank 3 - Community Apprentice

    Thank you for the clarification.

    Also I think the solution is for a different issue