Support Article

NonexistentTable Error Updating Pega 7.1.8 to 7.2.2

SA-31631

Summary



User 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

  1. Include bypass.pega.schema=true in setupDatabase.properties file.
  2. Run generateddl script.
  3. Run update script.


Root Cause



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.

Resolution



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:

​ https://pdn.pega.com/documents/pega-722-platform-update-guide 

 

Published December 19, 2016 - Updated December 26, 2016

Have a question? Get answers now.

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