Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

NonexistentTable Error Updating Pega 7.1.8 to 7.2.2



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 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: Database-NonexistentTable DATA_SCHEMA.pr_data_dms_customer_data PegaDATA

Steps to Reproduce

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

Root Cause

The 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:



Suggest Edit

Published December 26, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us