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

Optimize Schema not cleaning up all unused tables

SA-2376

Summary



After completing a split schema upgrade to 7.1.5 there are unused tables in the PegaRULES and PegaData schemas that can be cleaned up. Admin used the Optimize Schema tool to determine the tables that need to be cleaned up. After dropping all of the tables the schema identified, there are still 20 tables in the PegaRULES schema which should have been dropped as they are now part of the PegaData schema.

Error Messages



N/A


Steps to Reproduce



Complete a split schema upgrade using one database per the upgrade guide. You will end up with unused data tables in the PegaRULES schema and unused rules tables in the PegaData schema. Use the Optimize Schema tool to generate list of unused tables that can be cleaned up from both schemas. After applying this DDL the Optimize Schema tool no longer shows any tables that can be cleaned up but there are still unused tables in the PegaRULES schema.


Root Cause



The root cause of this problem is a defect in Pegasystems’ code/rules. 



Resolution



This issue is resolved through the following local change: 

These additional 20 tables can be dropped from your rules schema as they are now located in the data schema.


PR_DAILY_USAGE
PR_DATA_IH_DIM_ACTION
PR_DATA_IH_DIM_APPLICATION
PR_DATA_IH_DIM_CHANNEL
PR_DATA_IH_DIM_CONTEXT
PR_DATA_IH_DIM_CUSTOMER
PR_DATA_IH_DIM_LOCATION
PR_DATA_IH_DIM_OPERATOR
PR_DATA_IH_DIM_OUTCOME
PR_DATA_IH_FACT
PR_DATA_VBD_COLLECTION_CONFIG
PR_DATA_VBD_CONFIG
PR_EXTRACT_TIME
PR_FILE_STORE
PR_HOURLY_USAGE
PR_INDEX_INFO
PR_LICENSE_PARAMETERS
PR_OTHER
PR_SYS_UPDATESCACHE
PR_USAGE_SUMMARY

 

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