Discussion

6
Replies
598
Views
AnimeshD6938 Member since 2015 32 posts
Accenture Services Pvt Ltd
Posted: 5 years ago
Last activity: 5 years 1 month ago
Closed

Upgrade from PRPC 6.3 to PRPC 7.1.8

We are upgrading Pega platform from PRPC6.3 SP1 to PRPC 7.1.8. In one environment we successfully completed upgrade from PRPC6.1 SP1 single schema to PRPC7.1.8 split schema.

In order to update another environment we imported the previously upgraded PEGARULES schema and upgraded only the PRPCDATA one with dataOnly set to true.

We have performaed the below steps

1. created PRPCRULES schema in the second environment by importing the PEGARULES schema dump from previously upgraded environment.

2. created PRPCDATA schema in the second environment by importing the dump of PRPC6.3 SP1 which contains both data and rules.

3. configured the setupDatabase.properties files like below

pega.jdbc.driver.jar=/data01/app/oracle/product/11.2.0/db_1/jdbc/lib/ojdbc6.jar
pega.jdbc.driver.class=oracle.jdbc.OracleDriver
pega.database.type=oracledate
pega.jdbc.url=jdbc:oracle:thin:@x.x.x.x:1521/prpcprod
pega.jdbc.username=prpcdata
pega.jdbc.password=xxxxxx

rules.schema.name=prpcrules

data.schema.name=prpcdata

4. executing the upgrade script with --dataOnly true

The process fails with the below error

Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (PRPCRULES.PR_DATA_RESTORE_PK) violated

Please suggest.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn