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 April 21, 2017 - Updated May 12, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.