Question
Publicis Sapient
IN
Last activity: 24 Apr 2023 15:58 EDT
Data Type instance migration error Insufficient Privileges
HI All,
I am trying to move the Data Type from DEV region to Test. The product rules contains, Data Type pzinskey and Class. Getting error while importing the package in the Test.
com.pega.pegarules.pub.database.DatabaseException:Database-General problem executing SQL to update database schema 1031 42000 ORA-01031: insuffiecient privileges DatabaseException caused by prior exception: java.sql.SQLSysintaxErrorException: ORA-01031: insufficient privileges | SQL Code: 1031 | SQL State: 42000 From: SQL: CREATE TABLE TESTDBNAME ............
PRPCDatabaseAdminstrator and SysAdm4 is already add to my access group. Could someone please assist is there any other privileges do I need to add to my access group. or any idea how to to resolve this issue..
JPMC
IN
@MuzzuShaik I think the user(db) does not have privilege to execute a create table statement . The workaround would be to download the sql which would be available while we are importing and execute it before importing is done.