ORA-31603 error while running data schema upgrade
When running the data schema upgrade on an Oracle database as per the PRPC 7.1.7 Upgrade Guide, the upgrade is failing with an error:
<114712_Pega717_Path>\scripts\setupDatabase.xml:1886: Java returned: 1
Total time: 6 minutes 17 seconds
Exiting with Error
In the upgrade log, the first error encountered is:
[java] Error generating ddl for oracledate, DATA_SCHEMAjava.sql.SQLException: ORA-31603: object "PCV4_ASSIGNMENTWB_SUMMARY" of type VIEW not found in schema "DATA_SCHEMA"
Steps to Reproduce
- Begin upgrade process, following the Upgrade Guide.
- Update setupDatabase.properties for data schema upgrade.
- Run Upgrade.bat --dataOnly true
The root cause of this problem is defect/misconfiguration in the PRPC operating environment. The database user lacks a required permission to perform the upgrade.
This issue is resolved through the following local change: The database user needs to be granted the “SELECT_CATALOG_ROLE” permission.