When attempting to create a database connection in Framework Manager the following error message is displayed. Error: QE-DEF-0368 Unable to decrypt user name and password from the Content Store. Use Cognos Configuration to configure your reporting environment.
The signing and encryption certificates stored on the Framework Manager installation are not in sync with the content store, preventing Framework Manager from successfully accessing the encrypted data (specifically, the data source signon username and password).
This had worked previously but a recent change in the environment, in particular a change of application servers, has occurred. This usually occurs when Framework Manager is installed on a separate computer from the Cognos Business Intelligence server; however, it can happen if Framework Manager is installed in a separate folder on the same server.
Standalone Framework Manager Installation
Resolving The Problem
Note: Ensure that a backup is kept of all modified files and directories.
- Start up Cognos Configuration where Framework Manager is installed and re-save the configuration.
- Start up Framework Manager and attempt to create your database connection.
- If that doesn't work then continue with Step 2.
- Exit Framework Manager.
- Regenerate the encryption keys as per the following technotes:
10.2.1 and earlier: http://www-01.ibm.com/support/docview.wss?uid=swg21383421
10.2.2 and later: http://www-01.ibm.com/support/docview.wss?uid=swg21694322
15 June 2018