Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

ORA-01031: insufficient privileges when running Data upgrade



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] at oracle.jdbc.driver.T4CTTIoer.processError(
[java] at oracle.jdbc.driver.T4CTTIoer.processError(
[java] at oracle.jdbc.driver.T4C8Oall.processError(
[java] at oracle.jdbc.driver.T4CTTIfun.receive(
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(
[java] at oracle.jdbc.driver.T4CStatement.doOall8(
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(
[java] at oracle.jdbc.driver.OracleStatement.execute(
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(
[java] at com.pega.pegarules.install.SQLLoader.main(

Steps to Reproduce


Root Cause

This step requires use of a database user with DBA role with elevated privileges.


The information about Deployment user is part of installation guide. 
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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us