This discussion is archived
1 Reply Latest reply: Jul 25, 2012 12:14 PM by 951772 RSS

ODI Interface

GRK Journeyer
Currently Being Moderated
Hi I created interfaces, moved them into package and created scenario.
My Scenario is scheduled for nightly jobs.

1. If one of my interface is failed within scenario (which work repository table stores this information) ?

2. Frequently, few interfaces are failing every alternative days or weekly twice throwing the following below error but when i execute them seperately they are working properly, even if we reschedule them once again those are working properly.

And, the error - i see at " Insert check sum error into check table step"

942 : 42000 : java.sql.SQLException: ORA-00942: table or view does not exist

java.sql.SQLException: ORA-00942: table or view does not exist

     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
     at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
     at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
     at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
     at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
     at com.sunopsis.dwg.cmd.DwgCmd.k(DwgCmd.java)
     at com.sunopsis.dwg.cmd.f.z(f.java)
     at com.sunopsis.dwg.cmd.DwgCmd.run(DwgCmd.java)
     at java.lang.Thread.run(Thread.java:595)


Any Updates ??

Edited by: GRK on Jul 25, 2012 10:45 AM
  • 1. Re: ODI Interface
    951772 Newbie
    Currently Being Moderated
    1. I am not sure why you want to check the repository tables but the interface failure info along with the all steps in a scenario including status of individual step's status is maintained in ODI operator.

    2. It could be issues with source database. sometimes the view(s) are not available to ODI extract during the execution. what is the sql query of the failed step?

    Thanks,
    MM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points