Support Article
Update script fails when upgrading to Pega 7.2.2
SA-32999
Summary
When trying to generate the DDL files for an update, the script fails with an ORA-31603 error.
Error Messages
[java] Caused by: java.sql.SQLException: ORA-31603: object "PCV4_ASSIGNMENTWB_SUMMARY" of type VIEW not found in schema "PEGA_DATA"
[java] ORA-06512: at "SYS.DBMS_METADATA", line 5746
[java] ORA-06512: at "SYS.DBMS_METADATA", line 8333
[java] ORA-06512: at line 1
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
[java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
[java] at com.pega.pegarules.data.ddl.SchemaManager.readObjectBodies(SchemaManager.java:5071)
[java] at com.pega.pegarules.data.ddl.SchemaManager.readViews(SchemaManager.java:2706)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDatabaseJaxbObjectByIntrospection(SchemaManager.java:569)
[java] at com.pega.pegarules.data.ddl.SchemaManager.createDomDocumentFromDbIntrospection(SchemaManager.java:531)
[java] at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:511)
[java] ... 3 more
BUILD FAILED
/opt/pega/pega722_upgrade/scripts/setupDatabase.xml:2005: The following error occurred while executing this line:
/opt/pega/pega722_upgrade/scripts/setupDDL.xml:164: Java returned: 1
Total time: 1 minute 42 seconds
Ant Process returned a non 0 value
Steps to Reproduce
- Modify setupDatabase.properties to reflect the appropriate DB.
- Execute the .generateddl.sh --action upgrade.
- Build Fails.
Root Cause
A Catalog Role permission was missing from the deployment user, causing it to not have the proper visibility of certain views.Resolution
Properly provision the deployment user with the permission set as recommended by the Pega deployment guides.
Published January 31, 2017 - 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.