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

Insufficient privileges issue while running BIX Extract



User reported that there is a problem with BIX extract that they didn't face on TEST environment. When they run it, all versions of the extract rules are getting executed. It appears that the -a and -p parameters are not being picked up properly.

Error Messages

Seen in log file :

INSERT failed: ORA-01031: insufficient privileges

UPDATE also failed: ORA-01031: insufficient privileges

2016-06-14 13:40:10,561 [      app-pins-452-1] [  STANDARD] [                    ] [                    ] (piler.DatabaseCompilationSaver) ERROR   - Problem saving Java classes to database
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges


Steps to Reproduce

run BIX extract from script files 

Root Cause

A defect or configuration issue in the operating environment.
Database changes found missing in file


Here’s the explanation for the reported behaviour: 

User needs to update both prconfig.xml and files while updating Database settings in configuration files.

The database details are updated for a different environment.
As database information is mentioned in both the above mentioned files, it needs to be changed in both the files.


Published July 3, 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