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.
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.
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.
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.
0% found this useful