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.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.