Question & Answer
Question
Please ensure that you have already reviewed all of the relevant detail on the following page before you proceed: IBM Cognos TM1 SSL Expiration - Manual Fix Approach - Landing Page http://www-01.ibm.com/support/docview.wss?uid=swg21991653
Answer
To update your IBM Cognos Business Viewpoint Components, the below steps can be followed:
For both Cognos Business Viewpoint Server and Cognos Business Viewpoint Client
- Download the updated TM1 SSL Certificates from the following location: http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FCognos+TM1&fixids=BA-CTM1-SSL-ZIP-IF001
- Extract the downloaded file/archive to any directory. After extracting the files, look inside of the extracted folder. Confirm the following files are present.
- applixca.der
applixca.pem
applixcacrl.p7b
applixcacrl.pem
tm1admsvrcert.pem
tm1store
tm1svrcert.pem
1.
- Stop the Cognos Business Viewpoint service
- Make a backup of the <cognos>\BusinessViewpoint\bin\ssl\ directory. For example, C:\Program files\IBM\cognos\BusinessViewpoint\bin\sslBAK\
- Copy the extracted SSL certificate files into the <cognos>\BusinessViewpoint\bin\ssl\ directory. Overwrite any files of the same name
- Start the Cognos Business Viewpoint service
For IBM Cognos Business Viewpoint Clients
- Make sure the the Cognos Business Viewpoint client is closed
- Rename the <cognos>\BusinessViewpointClients\IntegrationComponents\TM1\tm1store file to <cognos>\BusinessViewpointClients\IntegrationComponents\TM1\tm1storeBAK
- Copy the tm1store file from the extracted new certificate files into the <cognos>\BusinessViewpointClients\IntegrationComponents\TM1\ directory
- Open and run Windows Command Prompt as an Administrator. Navigate to <cognos>\BusinessViewpointClients\bin\jre\6.0\bin . Execute the following commands:
- keytool -delete -alias applixca -keystore <cognos>\BusinessViewpointClients\bin\jre\6.0\lib\security\cacerts -storepass changeit
- keytool -keystore <cognos>\BusinessViewpointClients\bin\jre\6.0\lib\security\cacerts -alias applixca -import -file <extractedSSLCerts>\applixca.pem -storepass changeit -noprompt
Related Information
[{"Product":{"code":"SSWRXS","label":"Cognos Business Viewpoint"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Business Viewpoint","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 June 2018
UID
swg21993278