Is This Content Helpful?
We're glad to know this article was helpful.
When IBM Cognos and Esri Maps for IBM Cognos are configured to use the SSL security protocol, viewing a map-enabled report in PDF or Excel 2007 formats displays an empty box instead of the map image. The map displays correctly when the report runs in HTML.
There is an incomplete or missing Chain of Trust for SSL within the IBM Cognos Keystore.
When viewing a map-enabled report in PDF or Excel 2007 format, the IBM Cognos Gateway is unable to access the map images on the web server because a chain of trust for SSL has not been established between the web server and IBM Cognos application-tier components.
To set up trust between the web server and IBM Cognos, the IBM Cognos administrator must import the SSL certificate Chain of Trust into the IBM Cognos CA keystore.
As noted in the IBM Cognos Installation and Configuration guide, this task must be performed on each computer that has IBM Cognos components installed, including Content Manager, Application Tier components, gateway, and modeling components.
It is highly recommended to create a backup of the IBM Cognos Content Store before running this command
The order of the certificates is important. Begin with the root, then proceed through intermediate CA certificates.
<cognos_root>\bin\ThirdPartyCertificateTool.bat -java:local -T -i –r ca.cer -D ../configuration/signkeypair -p NoPassWordSet
Ensure that the JAVA_HOME environment variable is set before running the command.
<cognos_root>/bin/ThirdPartyCertificateTool.sh -T -i –r ca.cer -D ../configuration/signkeypair -p NoPassWordSet