Question
Pega 7 Data Schema Upgrade for Additional Database Schemas
We are planing to update from Pega 7.1.5 version to Pega 7.3.1 version. I am looking for following information -
We shall go for In-Place Update process for Data schema using following script -
./update.sh --dataOnly true
My Question is - There are few additional database schema, some of the existing Custom classes are mapped to tables reside in these schema. But, there are NO Pega specific tables (e.g. table name with PC_* or PR_*) present in these schema. Do I need to update these schema using update.sh script? My understanding is - we do not need to update these database schema. Please confirm.
Note -
1. Current Configuration -
OS - Red Hat Linux Server v6.5
Application Server - Oracle Weblogic Server 12c
Datbase Server - Oracle 12c R1 Enterprise DB Server (12.1.0.1)
Database - Split Schema.
2. I do not have any update.sh script for reference, so that I can check from the script.
Thanks in advance for suggestion and help.
Hi Chandramoulee,
You cannot upgrade customer specific 'Custom Schema' using upgrade.sh script. In the "setupDatabase.properties" (Config file which needs to updated before running upgrade script) file we have two placeholders i.e. "rules.schema.name" and "data.schema.name" where you have to mention Pega rule and data schema name(s) (Provided Pega is setup as split-schema), there is no placeholder to mention any other custom schema name. So when we run the command "./update.sh --dataOnly true", It only updates the schema which is provided in "data.schema.name" placeholder.
To update the custom schema, you can follow the below steps post-upgrade.
- compare upgraded OOTB table with one of the custom table.
- If you find any new column present in the OOTB table, write and execute an Alter SQL script to update the tables.
We did an upgrade earlier from Pega 6.3 to 7.1.8. In Pega 7.1.8 two new columns (PXCOMMITDATETIME & PXSAVEDATETIME) were added in every data tables. We wrote a custom script like below to update all custom tables.
alter table XXXXX add (PXCOMMITDATETIME DATE,PXSAVEDATETIME DATE);
Regards,
Sandeep