Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

ORA-00904 invalid identifier reported during Migrate step



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. – Completed successfully and created tables in Rule schema
2. – Completed successfully on Rules schema
3. – F
ailed with ORA-00904 invalid identifier error

Error Messages

[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] at oracle.jdbc.driver.T4CTTIoer.processError(
[java] ORA-00904: : invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(
[java] at oracle.jdbc.driver.T4C8Oall.processError(
[java] at oracle.jdbc.driver.T4CTTIfun.receive(

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.


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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us