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

  1. Modify setupDatabase.properties to reflect the appropriate DB.
  2. Execute the .generateddl.sh --action upgrade.
  3. 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 27, 2017 - Updated January 31, 2017

Have a question? Get answers now.

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