Primary Key changed how to move existing cases

General
, ,
1

If Primary Key is changed how to move the existing cases?

2

in my opinion, that’s not recommended and not supported directly in Pega.

  • pzInsKey / pxInsName is referenced across multiple tables (work, history, assignments, indexes, links, etc.)

  • Changing it will break referential integrity and can corrupt data

If it’s absolutely mandatory:

  • It has to be done as a full data migration (offline approach)

  • You would need to update:

    • Work tables

    • Assignments

    • History tables

    • Index tables

    • Any exposed references / external systems

  • Typically done using DB scripts or ETL tools, not from Pega rules

Safer alternative (recommended):

  • Keep old cases as-is

  • Introduce a new business key and handle mapping

3

you could use alternative key? it will mean you can move to the new key for new records but still keep the primary key on the class?

image
image1425×436 36.7 KB

I have no done this but in the Constellation world I commonly see this configuration underutilised.