Support Article
ORA-01031: insufficient privileges when running Data upgrade
SA-1547
Summary
Attempting a split schema upgrade from 7.1.5 to 7.1.6 fails in DATA upgrade step
Error Messages
[java] WARNING: Failed to execute SQL in file oracledate00010.sql
[java] Sep 19, 2014 6:03:39 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: drop trigger PEGASAND_DATA715.trpr_dataadm
[java] java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:193)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:197)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1245)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1585)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2493)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2433)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:896)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:298)
Steps to Reproduce
N/A
Root Cause
This step requires use of a database user with DBA role with elevated privileges.
Resolution
The information about Deployment user is part of installation guide.
https://pdn.pega.com/documents/prpc-716-installation-guide-for-apache-tomcat-on-oracle
Database User Accounts
Oracle databases require a Deployment user with the DBA role for PRPC installation or upgrade.
This user can be removed after the installation or upgrade is complete. This is due to the unique nature of
Oracle to associate schemas with user accounts. For split schema environments, you will create a Rules
and Data schema, which will create associated user accounts. PRPC uses the Deployment user to
assign privileges to the Rules and Data users.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.