Support Article
ORA-00904 invalid identifier reported during Migrate step
SA-11255
Summary
You have performed the following steps during the PRPC 6.1 SP2 to Pega 7.1.7 upgrade process and are getting the "ORA-00904 invalid identifier" error:
1. Migrate.sh – Completed successfully and created tables in Rule schema
2. Upgrade.sh – Completed successfully on Rules schema
3. Migrate.sh – Failed with ORA-00904 invalid identifier error
Error Messages
_callDDLUtilityUpgradeRules:
[echo] Call DDL Generation Rule Upgrade Utility...
[echo] archive_dir: /u03/prpc/scripts/lib
[java] java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier Error generating rule objects for oracledate, DB717_RULES
[java]
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
[java] ORA-00904: : invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
[java]
[java]
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
Steps to Reproduce
Upgrade from PRPC 6.1 SP1 Single Schema to Pega 7.1.7 Split Schema.
Root Cause
Execute privileges for DBMS_METADATA package arebmissing, causing the Migrate script to fail.
Resolution
After the Execute privilege for the DBMS_METADATA package is granted, the Migrate script runs successfully and the upgrade process is completed.
Published July 8, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.