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

SA-5768

Summary



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
pega.target.data.schema 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.


Resolution



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 pega.target.data.scema propert in the migrateSystem.properties file.

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

 
Suggest Edit

Published January 31, 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