Question
USDA
US
Last activity: 17 Jul 2017 16:25 EDT
Is PEGARules Schema export/import process works in PEGA 7.1.7?...
Hi,
a) In DEV environment , we have upgraded to PEGA 7.1.7 from 6.3 SP1 which was successful and completed with a single to split schema approach.
b) Now we would like to upgrade our QA environment. But we don't to follow the traditional approach that we followed at step "a". So we decided to export only "PEGARules" from DEV and import into QA environment. The import was successful without any issues. This is for PEGARules Schema.
c) Now, we wanted to use existing PRPC 6.3 SP1 Pega schema in QA environment as a data schema. We don't want to export "PEGAData" schema from DEV.
d) So, we executed data upgrade scripts on existing PRPC 6.3 SP1 Pega Schema. But it was failing. I attached the errors.
Please take a look into It and help me with a best answer.
Thanks,
Jayavardhan
***Updated by moderator: Marissa to close 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.
Accepted Solution
Pegasystems Inc.
US
The problem is with the database user that you are using to run the dataOnly upgrade. From the log file you are using the prpc_app user which is your data schema. The database user needs to be able to access both the rules and data schemas. If you look in the upgrade guide it tells you to use a "Deployment User" for this step which is essentially a user who has dba privileges.
[pega:propertyparser] pega.jdbc.username=prpc_app
[pega:propertyparser] pega.jdbc.password=******
[pega:propertyparser] rules.schema.name=PRPC7_RULES
[pega:propertyparser] data.schema.name=prpc_app