Upgrade Application Schema Wizard generates DDL that includes changes to internal columns
After upgrading to from Pega 7.3 to Pega 8.3, the generated DDL from the post upgrade step "Upgrade Application Schemas" is including alterations to several internal Pega properties. Examples include:
... MODIFY PZINSKEY VARCHAR2 (512 CHAR)
... MODIFY PYMEMO VARCHAR2 (512 CHAR)
... MODIFY PYLABEL VARCHAR2 (128 CHAR)
... MODIFY PXOBJCLASS VARCHAR2 (128 CHAR)
... MODIFY PXRULEACTION VARCHAR2 (128 CHAR)
... MODIFY PXRESOLUTIONCOSTDELTA NUMBER (38, 3)
I would like to understand the cause for the increase in column lengths before proceeding with the DDL changes. Any feedback appreciated.
Posted: 2 months ago
Hi,
Column size adjustments is based on the recommended column size for current Pega version to which you are upgrading too.
The Upgrade Applications Schema utility only adds missing columns or missing indexes, and adjusts column sizes. The Upgrade Applications Schema utility does not make any other changes to your cloned tables. You can either apply the changes automatically, or review the changes first.
This step can be carried out automatically or skipped during the actual upgrade and can be performed at a later point as well from the designer studio.