Question
Nordea
SE
Last activity: 7 Aug 2023 10:34 EDT
Unable to Migrate Upgraded Rule Schema
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 (https://community.pega.com/knowledgebase/documents/pega-platform-84-upgrade-guide-ibm-websphere-and-oracle) 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