Hi Genius,
anyone can help me on below error? When i try to run the load plan this error keep showing. Can anybody help me how to troubleshoot this issue?
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1576: LoadPlan Operation LOADPLAN_PREPARE on Agent OracleDIAgent failed with the exception com.sunopsis.dwg.SQLWorkReposException:
. Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (ODIDEV_ODI_REPO.PK_EXP_TXT_HEADER) violated
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:330)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1236)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1164)
at com.sunopsis.graphical.frame.edit.EditFrameSnpLoadPlan.jButtonExecute_ActionPerformed(EditFrameSnpLoadPlan.java:1579)
at com.sunopsis.graphical.frame.edit.EditFrameSnpLoadPlan$14.actionPerformed(EditFrameSnpLoadPlan.java:866)
But when the error not showing, the framework does not work and below error showed in the load plan executions
ODI-1519: Serial step "root_step (InternalID:6)" failed because child step "Serial (InternalID:7)" is in error.
ODI-1519: Serial step "Serial (InternalID:7)" failed because child step "NOVA_INVOICE (InternalID:9)" is in error.
ODI-1217: Session WHOLENEWINTERFACE_TMSOA_FILETODB (383710) fails with return code 7000.
ODI-1226: Step LOADFROMSOURCE_TMSOA fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: oracle.odi.runtime.agent.invocation.InvocationException: OracleDIAgent:ODI-1219: Session preparation failure: database error while connecting to work repository WORKREP.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ODIDEV_ODI_REPO.PK_SESSION) 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)
Thanks, El