Troubleshooting
Problem
After the database password was changed, data source connection in Cognos® (bundled with Maximo) failed with error
The IBM Cognos gateway is unable to connect to the IBM Cognos BI server. The server may be unavailable or the gateway may not be correctly configured.
Symptom
Error in cognosserver.log
CAM-CRP
<errorCode>-13</errorCode>CAM-CRP-0277 Unable to open the key store file '/data/ibm/cognos/c10_64/cgi-b
Cause
The database password stored in the data source connection in Cognos is encrypted in a file because Cognos is integrated with Maximo.
When the database password changes it needs to be changed in the file, encrypted and replaced in Cognos.
Environment
Cognos bundled with Maximo.
Resolving The Problem
Step 1:
Open the Maximo installation folder
• Navigate to <maximo>\reports\cognos\analytics\configuration
• Edit mxcognosdatasources.properties file
• Change the database password
maximoDataSource.password=<password>
• Navigate to <maximo>\reports\cognos\analytics\configuration
• Edit mxcognosdatasources.properties file
• Change the database password
maximoDataSource.password=<password>
Step 2:
Navigate to reports<maximo>\reports\cognos\tools
• Run encryptproperties.cmd or encryptproperties.sh on unix/linux)
• Copy the mxcognosdatasources_enc.properties file from the <maximo>\reports\cognos\analytics\configuration folder in the Maximo installation directory to the configuration folder on the Cognos installation server <cognos>\analytics\configuration
• On the Cognos installation server navigate to the configuration folder <cognos>\analytics\configuration
• Rename the mxcognosdatasources_enc.properties file to mxcognosdatasources.properties
• Run encryptproperties.cmd or encryptproperties.sh on unix/linux)
• Copy the mxcognosdatasources_enc.properties file from the <maximo>\reports\cognos\analytics\configuration folder in the Maximo installation directory to the configuration folder on the Cognos installation server <cognos>\analytics\configuration
• On the Cognos installation server navigate to the configuration folder <cognos>\analytics\configuration
• Rename the mxcognosdatasources_enc.properties file to mxcognosdatasources.properties
Step 3:
Grant full Read and Write privileges to the files csk and cogconfig.prefs in the <cognos>\analytics\configuration
Step 4:
Restart the Cognos and Maximo services
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6sAAC","label":"Install-\u003EConfigure"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
07 July 2023
UID
ibm10843062