Some application processes (for example data flow runs) might fail after migrating to a newer Pega Platform™ version as a result of missing tables or columns in the Interaction History schema.   

Cause

The root cause of the issue is that the Pega Platform upgrade process does not include externally hosted Interaction History schema.

Solution

Extend the existing Interaction History tables by adding new columns or dimension tables. By expanding the tables, you ensure that the updated Interaction History schema corresponds to the format that is expected by Pega Platform.

Extending Interaction History

These steps provide sample scripts for extending the Interaction History schema in a Postgres database with columns or dimension tables. For other database types, customize the scripts appropriately.

Upgrading from Pega 7.2.2 to 7.3.0

No actions required.

Upgrading from Pega Platform 7.3.0 to 7.3.1

Create new tables and columns to ensure that your Interaction History schema is compatible with the Pega Platform 7.3.1 standard.

1. Create the pr_data_ih_dim_journey dimension table by running the following script:

   CREATE TABLE <external_schem_name>.pr_data_ih_dim_journey (
   
   pzid numeric(19) NOT NULL,
   
   pxcreatedatetime timestamp NOT NULL,
   
   pyjourney varchar(255) NULL,
   
   pystep varchar(255) NULL,
   
   pystage varchar(255) NULL,
   
   CONSTRAINT pr_data_ih_dim_journey_pk PRIMARY KEY (pzid)
   
   );
   

2. Add the pzjourneyid column in the pr_data_ih_fact table by running the following script:

   ALTER TABLE <external_schema_name>.pr_data_ih_fact
   
   ADD COLUMN pzjourneyid numeric(19);
   

3. Add the pylabel column in the pr_data_ih_dim_action table by running the following script:

   ALTER TABLE <external_schema_name>.pr_data_ih_dim_action
   
   ADD COLUMN pylabel varchar(255);
   

Upgrading from Pega Platform 7.3.1 to 7.4.0

Create a new column to ensure that your Interaction History schema is compatible with the Pega Platform 7.4.0 standard.

• Add the pysubjecttype column in the pr_data_ih_dim_customer table by running the following script:

  ALTER TABLE <external_schema_name>.pr_data_ih_dim_customer
  
  ADD COLUMN pysubjecttype varchar(255);
  

Upgrading from Pega Platform 7.4.0 to 7.4.1

No actions required.

Upgrading from Pega Platform 7.4.1 to 8.1.0

No actions required.

Upgrading from Pega Platform 8.1.0 to 8.2.0

No actions required.

Upgrading from Pega 8.2.0 to 8.3.0

No actions required.