7 Replies Latest reply on Jan 29, 2010 1:42 PM by Bouch

    invalid user.table.column, table.column, or column specification

    717657
      I am trying to do a simple one to one mapping.
      I am trying to map a key field from my source table to a key field in my target table.
      Both are Oracle tables.
      Mapping executed in source.
      For target column Key and Check Not Null (Flow Control) have been checked.

      Error message I am getting:

      1747 : 42000 : java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

      java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification


           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)


      The query ODI is executing:

      /* DETECTION_STRATEGY = NOT_EXISTS */
      update     MIG_PROF.ATTRIB_MATRIX T
      set      (
           
           
           ) =
                (
                select     
                     
                from     ODIWORK.I$_ATTRIB_MATRIX S
                where     T.BAC     =S.BAC
                )

      where     (BAC)
           in     (
                select     BAC
                from     ODIWORK.I$_ATTRIB_MATRIX
                where     IND_UPDATE = 'U'
                )
      Please help.