Support Article
BIX requiring explicit password even using keyring
SA-36923
Summary
Using a keyring file when running Business Intelligence Exchange (BIX) extraction from the command line.
Business Intelligence Exchange (BIX) log shows a successful connection to the database but then the extraction fails with an error that the password is missing when the database password is part of the keyring file.
Error Messages
ERROR - Username was specified with no password
Steps to Reproduce
Execute BIX extract from command line specifying the keyring file as a system parameter.
Root Cause
A defect or configuration issue in the operating environment.
The keyring file specified contains the database username or password but the BIX extraction includes the -a parameter with the Pega username of the operator to use for rule resolution when running the extraction.
It is the username or password of this user that is not included in the keyring file.
Resolution
This article has an example command under the “Specifying PRPC user credentials for rule resolution (BIX example)” section for adding a BIX username and password to a keyring file:
https://pdn.pega.com/security/how-to-encrypt-passwords-properties-and-blobs
Published May 12, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.