Question

4
Replies
35
Views
AnandP Member since 2013 140 posts
Swedbank AB
Posted: October 13, 2020
Last activity: October 27, 2020

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

 

***Edited by Moderator: Pooja to update product version, add support and moderator tags***
Pega Platform 8.4.2 System Administration Financial Services Senior System Architect SR Created Upgrade
Share this page LinkedIn