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

Error on importing the AES application bundle



After performing a new installation of Pega 7.3.1 and Autonomic Event Services (AES) 7.3, Oracle error message displays in the logs. Schema modifications by Pega application are not allowed by the Database Administrators (DBAs). Therefore, a separate Pega connect user is used in the WebLogic Java Database Connectivity (JDBC) connection to access the AES database. The Pega connect user has Data Manipulation Language (DML) privileges on the Pega database objects in the Rules schema and the Data Schema. As a result of this requirement, the user manually generates and applies the Data Definition Language (DDL) for Pega 7.3.1 and AES 7.3. The generateddl.bat script is used to generate the Pega 7.3.1 DDL. The DDL is generated as part of the import of the AES application bundle for AES 7.3. The Pega 7.3.1 DDL and the AES 7.3 DDL are applied before installing the rulebase (executing and before installing (importing) the AES application bundle through Oracle SQL*Plus.

The Oracle exception displays during the import of the AES application bundle despite the preparation of the Oracle database (applying the Pega 7.3.1 DDL and the AES 7.3 DDL in advance).

Error Messages

618 [fault (self-tuning)'] [ STANDARD] [ PegaRULES] (nal.access.DBSchemaDDLExecutor) ERROR [email protected] - Error occured while trying to add Index columns for an property Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

| SQL Code: 1031 | SQL State: 42000

at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.executeDBAddIndexColumns( ~[prprivate.jar:?]
com.pegarules.generated.activity.ra_action_savecircumstanceindex_270ca6b67141c1ef0e3d20a38ca6c80d.step6_circum0( ~[?:?]
com.pegarules.generated.activity.ra_action_savecircumstanceindex_270ca6b67141c1ef0e3d20a38ca6c80d.perform( ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity( ~[prprivate.jar:?]
at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngineUtilImpl.runActivity( ~[prprivate.jar:?]
at com.pega.pegarules.exec.internal.declare.infengine.TriggerImpl.evaluateNetworks( ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.BasicDeployDataModel.saveDeferred( ~[prprivate.jar:?]
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importInstance( ~[prprivate.jar:?]
com.pegarules.generated.activity.ra_action_pzimportcomponent_d2e7c47c5a5ed1549c03b34ef0253d0b.step1_circum0( ~[?:?] Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CTTIoer.processError( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4C8Oall.processError( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CTTIfun.receive( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CTTIfun.doRPC( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4C8Oall.doOALL( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CStatement.doOall8( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CStatement.doOall8( ~[ojdbc7.jar:]
at oracle.jdbc.driver.T4CStatement.executeForRows( ~[ojdbc7.jar:]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( ~[ojdbc7.jar:]
at oracle.jdbc.driver.OracleStatement.executeInternal( ~[ojdbc7.jar:]
at oracle.jdbc.driver.OracleStatement.execute( ~[ojdbc7.jar:]
at oracle.jdbc.driver.OracleStatementWrapper.execute( ~[ojdbc7.jar:]
at weblogic.jdbc.wrapper.Statement.execute( ~[weblogic.server.merged.jar:]
at ~[prprivate.jar:?]
at ~[prprivate.jar:?]

Steps to Reproduce

Install Pega 7.3.1 and AES 7.3 with a connect user which has no DDL privileges on Rules schema and Data Schema. 

Root Cause

Two columns which are to be added to the PR_INDEX_CIRCUMSTANCE_DEF table are not present in the DDL. Sufficient privileges are present to apply DDL changes according to the generate DDL. However, users restrict this privilege. Hence, a few SQLs fail. The users have no visibility of the failed SQLs and hence it is difficult to analyse which alter statements failed.


  1. Apply HFix-43015 
  2. Manually add the required columns to the DDL and the PR_INDEX_CIRCUMSTANCE_DEF table



Published August 19, 2019 - 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