Identifying missing database tables

To confirm that all the required database tables in the Pega Platform base schema are present in your system after an upgrade, view the Upgrade Applications Schema tab.

Before you begin: This report is visible only to users with the ViewAndOptimizeSchema privilege.
  1. In the header of Dev Studio, click Configure > System > Release > Upgrade > Upgrade Applications Schema.
  2. Optional: Click Refresh All to generate a new report evaluating the current state of the system.
  3. Review the information under each heading:
    • Missing Pega Platform Shipped Schema lists tables, views or columns that are expected for the Pega Platform release you upgraded to but are missing from your system.
    • Upgrade Rule Tables lists Rule- classes that are not mapped to the expected Pega Platform Rule tables as shipped for the upgrade release.
    • Upgrade Data Tables lists Data- classes that are not mapped to the expected Pega Platform Data tables as shipped for the upgrade release.
    • Upgrade Work and History Tables lists Work- and History- classes that are not mapped to the expected Pega Platform Work and History tables as shipped for the upgrade release.
    • Upgrade Auto Generated Tables lists Work- and History- classes that are not mapped to auto-generated classes consistent with the tables mapped to Pega shipped classes.