Unable to Migrate Upgraded Rule Schema

General
, , , ,
1

Hi,

We are trying to migrate our rule schema from one database to another as we are trying to perform the upgrade in out-of-place manner (for Pega 8.4.2). We are following the upgrade guide for 8.4.2 (Pegasystems Documentation)

Migration fails stating ORA-01031: insufficient privileges for INSERT statements (please refer to the attached log for more details). We checked the privileges for User which is responsible for migration and they look fine. here are the privileges which are granted to the user:–

ALTER ANY TABLE
ALTER ANY TRIGGER
ANALYZE ANY
ANALYZE ANY DICTIONARY
CREATE ANY INDEX
CREATE ANY PROCEDURE
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW
CREATE SESSION
DELETE ANY TABLE
DROP ANY INDEX
DROP ANY PROCEDURE
DROP ANY TABLE
DROP ANY TRIGGER
DROP ANY VIEW
EXECUTE ANY PROCEDURE
GRANT ANY OBJECT PRIVILEGE
INSERT ANY TABLE
SELECT ANY TABLE
UPDATE ANY TABLE

CLI-Migrate-log-Oct-13-2020-10-53-14.txt (1.76 MB)

2

Hello,

Can this be helpful: Migrating Upgraded Rule Schema | Support Center

3

This post was also shared by me & migration using Pega v8.1 works perfectly fine. we are facing this issue for 8.4.2

I have raised an incident INC-148251

4

Hello @AnandP It appears you have two schema’s in your Database, FLP30_APP_RULES
FLP50_APP_RULES_V8.

Look like your SQL Login doesnt have access to V8 scema or V8 schema owner need to be changed.

5

Hi @gumudavelly, we have checked the privileges and they are fine. Moreover, I think if there was a privilege issue then it should have failed for 8.1 or 8.3. I recently run the migration script for Pega v8.3.0 on the same Database and it worked fine. It’s only failing for 8.4.x which is quite strange.

6

Couldn’t find the root cause in the investigation if someone is facing a similar problem, the migration script for 8.3 can be used.

7

This is currently being investigated as part of INC-154211 by product team