NonexistentTable Error Updating Pega 7.1.8 to 7.2.2
SummaryUser is running an out of place update from Pega 7.1.8 to Pega 7.2.2 and has two Rules Schema (Rules_Old and Rules_New) and data schema.
bypass.pega.schema is set to true in the setupDatabase.properties file.
After running the generated dl script and user is getting the ddls that have to be applied in both rules and data schemas, the update script was run.
The intention being to run the sql after update process is complete.
When the update script ran, it faced a nonexistentTableException.
Error Messages[java] Throwable occurred: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable DATA_SCHEMA.pr_data_dms_customer_data PegaDATA
Steps to Reproduce
- Include bypass.pega.schema=true in setupDatabase.properties file.
- Run generateddl script.
- Run update script.
The setupDatabase.properties file (used by both the generateddl and update scripts) was not configured correctly for this part of the process, leading to it creating changes to the data schema.
The DDL generated before running the update script should only have changes to the rules schema and should be applied before running the update script.
Perform the following local-change:
Follow the directions in the Pega 7.2.2 Update guide, specifically the "Performing an out-of-place update" and "Appendix C: Optional Generating and applying DDL" sections:
Published December 19, 2016 - Updated December 26, 2016