5 Replies Latest reply on Mar 16, 2010 4:06 PM by Deepak Patil

    904 : 42000 : java.sql.SQLException: ORA-00904: "EMPLOYE_STATUS_NK": invali

    759013
      Hi.

      I am new to ODI. I have been getting this error *904 : 42000 : java.sql.SQLException: ORA-00904: "EMPLOYEE_STATUS_NK": invalid identifier *. I am using an interface to move data from staging to target datastore. Both staging and target are oracle tables. In my target table I have three columns. First once references an oracle sequence and being exec in targer as sequence is created in target. Seond column is a natural key column and is also defind as a key. Third column is simple just showing desc of emplyee. I am using LKM Oracle to Oracle (for staging table) and IKM Oracle Incremental Update for target datastore.

      I will apprecciate If someone can help me with this.



      Following are complete error details



      ava.sql.SQLException: ORA-00904: "EMPLOYEE_STATUS_NK": invalid identifier


           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.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.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)

      Edited by: Greenwich on Mar 15, 2010 11:00 AM

      Edited by: Greenwich on Mar 15, 2010 5:52 PM