Forum Stats

  • 3,815,688 Users
  • 2,259,067 Discussions
  • 7,893,207 Comments

Discussions

ODI complaints Table or View does not exist to Load!

735234
735234 Member Posts: 29
edited Nov 25, 2009 7:10AM in Data Integrator
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)

Answers

  • Cezar Santos
    Cezar Santos Member Posts: 1,901
    Hi,

    Has the user who connects (topology/dataserver) to databaser, rights to read the source table?


    Cezar Santos
    [www.odiexperts.com]
    Cezar Santos
  • 606607
    606607 Member Posts: 288
    Hi,

    what is your option for create target table in interface flow option ?

    Do you have different contexts ? ( are you checking the tables manually in the right DB ? {which the context is pointing } )

    From your post I believe create table steps went succesfully (green symbol);[for ODI temp tables and target table]

    In Which step you are getting error ? can you please copy the error stpe generated here along with the create tables step.

    Can you please cross check the temp tables are created with the proper table name appended with C$ , I$ etc..

    Regards,
    Rathish
    606607
  • 735234
    735234 Member Posts: 29
    The issue is the Target Data store Tables are missing; not sure how they got deleted.

    Thanks for the help
    Best Regards.
This discussion has been closed.