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

Password encryption pegarules 1005 72000 ORA-01005 error



User is facing an issue while trying to encrypt the passwords in prconfig, prbootstrap and Business Intelligence Exchange (BIX) files.
When user tries to generate a keyring file by following the instructions provided in the PDN artcile for command line execution, user is facing an error:

Error Messages Database-General Problem encountered when getting connection for database pegarules 1005 72000 ORA-01005: null password given; logon denied

From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 72000, Error code 1005: java.sql.SQLException: ORA-01005: null password given; logon denied


Steps to Reproduce

1. Create a keyring file.
2. Remove the password from prconfig.xml.
3. Run BIX extract through command line.

Root Cause

Additional settings which are required to communicate the use of a keyring file were not done, due to which password is not being read from the keyring file.


In addition to the things that are specified in the PDN articles mentioned below, include the below line, along with the existing JVM arguments in the BIX XML file.
<jvmarg value="-Dpegarules.keyring=<relative path of the prconfig file> "/>
For example: config/pegarules.keyring

If the name of keyring file is different from the default name of pegarules, include below setting in prconfig.xml file.

<env name="identification/KeyringPrefix" value="<name of the file without extension>" />
For example: pegarules

Encryption of BIX password, can be done in the same step where the password in prconfig.xml is encrypted, however there will be a difference in the arguments. Use the below command to encrypt passwords in prconfig.xml and BIX:

java -Xms512m -Xmx768m -classpath "<Path to prbootstrap.jar>;<Path to prbootstrap-api.jar>;<Path to prdbcp.jar>;<Path to ojdbc6.jar>;<Path to jsr94-1.0.jar>;%CLASSPATH%"\ -Dpegarules.config=config\prconfig.xml -Dpegarules.logging.configuration=config\prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true com.pega.pegarules.exec.internal.util.crypto.KeyringImpl .\config\pegarules.keyring .\config\prconfig.xml <Path to PegaRULES deployment directory / Pega Media> bix


Published August 17, 2016 - Updated December 2, 2021

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