Linux Operating System (MOSC)

MOSC Banner

Upgrading ODI 12.2.1 fails with ORA-00904: "CUSTOM2": invalid identifier

edited Jun 22, 2022 1:43AM in Linux Operating System (MOSC) 1 commentAnswered

Hi All,

Did anyone come across the below error while upgrading the ODI.

Caused by: Error : 904, Position : 89, Sql = UPDATE SYSTEM.SCHEMA_VERSION_REGISTRY$ SET status='UPGRADING', owner=:1 , upgraded='N', custom2='MWUPGRADE_12.2.1.4.0_190905.0', start_time=CURRENT_TIMESTAMP WHERE comp_id=:2 AND mrc_name=:3 , OriginalSql = UPDATE SYSTEM.SCHEMA_VERSION_REGISTRY$ SET status='UPGRADING', owner=?, upgraded='N', custom2='MWUPGRADE_12.2.1.4.0_190905.0', start_time=CURRENT_TIMESTAMP WHERE comp_id=? AND mrc_name=?, Error Msg = ORA-00904: "CUSTOM2": invalid identifier


    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)

    ... 24 more

Regards,

Dilip

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center