Hello,
I am able to set up DB2 data sources both through FM and Cognos Connection (passwords required) and test succesfully- however when I try to use these datasources in FM I get the error message below.
"This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.
QE-DEF-0368 Unable to decrypt user name and password credentials from the content store. Review and save the Cognos Configuration settings to configure your reporting environment."
My colleagues are able to use the datasources I create no problem and it seems to be FM on my machine causing the problem,
Help anybody??
After installing FM on your machine, did you configure it? You have to open Cognos Configuration and do the settings there otherwise it will not connect to Content store. The configuration of your app server will use the user-id/password that is provided in the configuration. It will not use your user-id to connect to the content store so your local configuartion has to point to the app server.
Thanks, I have checked all the Configeration settings with other machines that work and tested the URI settings with no problems- but still no joy.
Hello All,
Finally resolved this issue- whew!
In case anybody else gets this issue this is the process I followed is from
http://www-01.ibm.com/support.
Instructions
Problem(Abstract)After a re-install of the Cognos Express server (or a regeneration of the crypto keys for another reason), the error below is returned when attempting to publish a package from FM or other operation that requires FM to access the Cognos Express dispatcher.
SymptomQE-DEF-0368 Unable to decrypt user name and password credentials from the content store. Review and save the Cognos Configuration settings to configure your reporting environment.
Resolving the problem
1. Launch cogconfig.bat from the fm_install\bin directory and go File -> Export and save this configuration as newconfig.xml under fm_install\configuration\ e.g., C:\Program Files\IBM\Cognos Express Clients\Framework Manager\configuration
2. Close Cognos Configuration
3. Go to C:\Program Files\IBM\Cognos Express Clients\Framework Manager\configuration to delete the crypto key folders (csk, encryptkeypair and signkeypair 3 directories)
4. Rename cogstartup.xml -> cogstartup.xml.old
5. Rename newconfig.xml to cogstartup.xml
6. Launch cogconfig.bat again and click Save to regenerate the keys
:)