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

Unable to view unused tables for DATA Schema in Optimize Schema



System upgraded to Pega 7.1.7 split schema using the single database process from the Upgrade Guide.

Admin is trying to run the "Optimize Schema" tool to cleanup the unused tables from the PegaData and PegaRules schemas. When running for PegaData there are 75+ tables displayed and when running for PegaRULES there are none displayed.

Error Messages

Not Applicable

Steps to Reproduce

1. To open the optimize schema wizard, click the Designer Studio menu option > System > Database > Optimize Schema.
2. Select the PegaDATA database.

Root Cause

The root cause of this problem is an error/omission in product documentation. For the second pass of running the migrate script to generate the rules schema objects the Upgrade Guide does not indicate that the needs to be set to the Data Schema.  As a result the rules schema database triggers are not updating the pr_sys_updatescache table in the data schema as is needed in a split schema configuration.


This issue is resolved by making the following change to the PRPC operating environment: 

1. From the 7.1 Upgrade guide, run the Upgrading from a Single to Split-Schema Configuration -> Upgrading with one database -> Generate rules schema objects step again as specified in the upgrade guide except also set the propert in the file.

2.  Clear the extract marker from PegaTemp and restart the system.


Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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