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-31603 "PCV4_ASSIGNMENTWB_SUMMARY" not found during upgrade



During upgrade to Pega 7.1.8 split schema, an error causes the upgrade to fail while generating the DDL.

Error Messages

    [java] 2015-12-02 16:44:39,423 (                    SchemaGenerator)  SEVERE - Error generating ddl for oracledate, PEGA_DATA
     [java] ORA-31603: object "PCV4_ASSIGNMENTWB_SUMMARY" of type VIEW not found in schema "PEGA_DATA"
     [java] ORA-06512: at "SYS.DBMS_METADATA", line 5805
     [java] ORA-06512: at "SYS.DBMS_METADATA", line 8344
     [java] ORA-06512: at line 1

Steps to Reproduce

Run upgrade script.

Root Cause

A defect or configuration issue in the operating environment.  

In order to generate the DDL required for an upgrade on an Oracle database, user requires the SELECT_CATALOG_ROLE role to be able to access the data dictionary of the rules and data schemas.


Make the following change to the operating environment: 

Grant the  SELECT_CATALOG_ROLE to deployment user and run the script again.


Published January 31, 2016 - 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