3 Replies Latest reply on Nov 25, 2009 12:10 PM by 735234

    ODI complaints Table or View does not exist to Load!

    735234
      I get the below error when ODI run the task of loading data. I checked the DB the table already exists, it has been created by ODI in the previous step. Not sure why it is not findiing it self.

      I use Oralce Incremental update as my KM:

      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.DatabaseError.throwSqlException(DatabaseError.java:125)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
           at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
           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.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.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.DwgCommandSession.treatCommand(DwgCommandSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
           at com.sunopsis.dwg.cmd.e.i(e.java)
           at com.sunopsis.dwg.cmd.g.y(g.java)
           at com.sunopsis.dwg.cmd.e.run(e.java)
           at java.lang.Thread.run(Unknown Source)