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

Duplicate tables display in the new rule and data schema



Pega 7.2.2 is updated to Pega 7.3.1 following the split schema out-of-place upgrade with a database. Post upgrade, duplicate tables display in the new rule and data schema.

Error Messages

Not Applicable

Steps to Reproduce

Update to  Pega 7.3.1.

Root Cause

A defect or configuration issue in the operating environment 
Cleanup was not performed as part of the upgrade.



Perform the following local-change:

During the out-of-place upgrade of a split schema environment, tables are present in the rules and data schema which must be cleaned.

Refer to the 'Cleaning up unused tables' section of the upgrade guide (

Drop the unused rules tables in the data schema after deploying a split-schema. For only one database, ensure to drop the unused data tables in the rules schema.

  1. Verify that the user has the  correct privileges to view and edit the Optimize Schema landing page. Set these to true: 

    - ViewAndOptimizeSchema
    - Dynamic System Setting (DSS) databases/AutoDBSchemaChanges
    - ViewSchemaOnImport
    - SchemaImport

    For more information, refer to the article, 'How to set privileges to restrict database schema changes generated from Process
    Commander' (

  2. Click Designer Studio > System > Database > Optimize Schema to open the Optimize Schema wizard.
  3. Select the PegaDATA database.
  4. Click View the unused tables to display a list of Pega application tables without class mappings. Select the tables that must be deleted.
  5. Click Proceed with Changes such that the application drops the tables, or drop them manually in the database.
  6. Repeat Steps 3 and 4 for the PegaRULES database.
  7. Restart the application.

    Published December 25, 2018 - 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