Support Article
ORA-31603 "PCV4_ASSIGNMENTWB_SUMMARY" not found during upgrade
SA-17612
Summary
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
[java]
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.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.