Support Article
Update to 7.1.7 on Oracle reports missing view
SA-3401
Summary
Administrator is attempting a maintenance level update from 7.1.6 (upgraded from 6.3.1) to 7.1.7, but update script reports that view from DATA schema is missing even though it does exist in database.
Error Messages
_callDDLUtilityUpgrade:
[echo] Call DDL Generation Upgrade Utility...
[echo] /home/114702_Pega717-UPD/scripts/lib/xercesImpl.jar;/home/114702_Pega717-UPD/scripts/lib/xml-apis.jar;/home/114702_Pega717-UPD/scripts/lib/resolver.jar;
[echo] archive_dir: /home/114702_Pega717-UPD/scripts/lib
[java] Error generating ddl for oracledate, PEGA7RULES
[java] ORA-31603: object "PCV4_ASSIGNMENTWB_SUMMARY" of type VIEW not found in schema "PEGA7DATA"
[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]
[java] java.sql.SQLException: ORA-31603: object "PCV4_ASSIGNMENTWB_SUMMARY" of type VIEW not found in schema "PEGA7DATA"
[java] ORA-06512: at "SYS.DBMS_METADATA", line 5805
...
Steps to Reproduce
Run update.sh script to upgrade from 7.1.6 to 7.1.7
Root Cause
This is caused when the database user does not have the correct privileges, specifically does not have the SELECT_CATALOG_ROLE privilege to access the list of views.
Resolution
GRANT the SELECT_CATALOG_ROLE as this is a privilege used by the upgrade script. This is mentioned in the deployment guides for Oracle Databases.
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.