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 error while running data schema upgrade

SA-4650

Summary



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:

BUILD FAILED
<114712_Pega717_Path>\scripts\setupDatabase.xml:1886: Java returned: 1

Total time: 6 minutes 17 seconds
Exiting with Error

Error Messages



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


 

  1. Begin upgrade process, following the Upgrade Guide.

  2. Update setupDatabase.properties for data schema upgrade.

  3. Run Upgrade.bat --dataOnly true


  4.  

Root Cause



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.


Resolution



This issue is resolved through the following local change: The database user needs to be granted the “SELECT_CATALOG_ROLE” permission.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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