Troubleshooting
Problem
After installing 11.0.11 on top of 11.0.5 where SSL access to the DB2 content store database was enabled and IBM JRE installed with Cognos Analytics was used saving in Cognos Configuration fails with the following error message:
The cryptographic information cannot be encrypted
Resolving The Problem
1) In 11.0.5 in Cognos Configuration File -> Export As - save as the file called before_upgrade_cogconfig.xml outside the installation folder, exit Cognos Configuration
2) Make a backup copy of the 11.0.5 installation folder
2)Install 11.0.11 into the same installation folder where 11.0.5 was installed
3) Navigate to the configuration folder, remove cogstartup.xml file, copy before_upgrade_cogconfig.xml to the configuration folder, rename it to cogstartup.xml
4) Copy JDBC drivers from the drivers folder of the 11.0.5 backup into drivers folder of 11.0.11
5) Copy certs folder from configuration folder of 11.0.5 backup to configuration folder of 11.0.11
7) Follow the documentation at
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.sw… to use a SSL enabled DB2 as the content store,
8) Copy the list of providers from jre\lib\security\java.security in 11.0.5 backup
security.provider.1=com.ibm.jsse2.IBMJSSEProvider2
security.provider.2=com.ibm.crypto.fips.provider.IBMJCEFIPS
security.provider.3=com.ibm.crypto.provider.IBMJCE
security.provider.4=com.ibm.security.jgss.IBMJGSSProvider
security.provider.5=com.ibm.security.cert.IBMCertPath
security.provider.6=com.ibm.security.sasl.IBMSASL
security.provider.7=com.ibm.xml.crypto.IBMXMLCryptoProvider
security.provider.8=com.ibm.xml.enc.IBMXMLEncProvider
security.provider.9=com.ibm.security.jgss.mech.spnego.IBMSPNEGO
security.provider.10=sun.security.provider.Sun
and replace a similar list of 9 providers in 11.0.11 with the list from 11.0.5
9) Copy unrestricted files from 11.0.5 backup to 11.0.11 or download them from https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=jcesdk
10) Run Cognos Configuration in 11.0.11 and save the configuration
11) Start the Cognos Analytics 11.0.11
Was this topic helpful?
Document Information
Modified date:
31 July 2018
UID
ibm10719557