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

Upgrade fails - DB permissions



Error messsages are generated when upgrading from Pega 7.1.6 to Pega 7.1.7.

Error Messages

[java] May 20, 2015 8:05:33 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Failed to execute SQL in file oracledate00490.sql
[java] May 20, 2015 8:05:33 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: GRANT ALL ON DATA_PEGA7.pwbv4_circumstance_duplicates TO RULES_PEGA7
[java] java.sql.SQLSyntaxErrorException: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
[java] at oracle.jdbc.driver.T4CTTIoer.processError(

Steps to Reproduce

Not Applicable

Root Cause

The root cause of this problem is software use/operation error. The deployment user does not have the correct permissions applied. 


Grant DBA privileges to the deployment user, which is only used during install/upgrade time. Refer notes in the upgrade guide regarding the deployment user. Further, the deployment user is discussed in detail in the installation guide (any of the guides for the Oracle database), and the specific permissions are detailed. 

Upgrade guide:
One of Pega 7.1.7 Installation Guides for Oracle:

Published June 12, 2015 - 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