3 Replies Latest reply on May 26, 2015 10:04 AM by yuvraj_patil002

    ODI 12c - Error " ORA-00904: : invalid identifier"


      Hi I am loading data from Excel to Oracle Db.

      Connection everything is fine...


      Please help me on below error.


      ODI-1228: Task Create work table-LKM SQL to Oracle- fails on the target connection ST_TG table for Capacity Planning.

      Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier


        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)




        • 1. Re: ODI 12c - Error " ORA-00904: : invalid identifier"

          Hi Yuvi,

          Head over to operator and pull the step that is failing from operator log - Paste up here if you wish.

          You are probably referencing a column that doesnt exist (either in Source table or you have a literal that is not enclosed in quotes).

          There is also the possibility you are trying to reference a source column in a mapping that is executed on Staging or target . Double check this.

          Also double check filters are syntax correct.


          • 2. Re: ODI 12c - Error " ORA-00904: : invalid identifier"

            This is a database message indicating that column name you are using is invalid


            In the ODI operator drill down to the error step and then click on "CODE"  - this should show the SQL you tried to execute. Look for errors in that - perhaps even paste it in to SQL developer as this may highlight the line at fault.


            Typically this error is caused by

            • Having an invalid column name in the model (Oracle column names are limited to 30 characters, must start with a letter, and only contain [A-Z][0-9] and a few special characters such as '$' and '_'
            • A bug in a KM that causes a syntax error such as a missed space << less likely on the standard KMs - more likely on custom KMs


            Look at the generated code and then work out what needs fixing

            • 3. Re: ODI 12c - Error " ORA-00904: : invalid identifier"

              Thank you,. Issue got resolved.