HI,
Hoping someone can guide me on configuring CCC on my local server to connect to Planning Analytics. CCC is working with the Cloud instance but having certificate issues when trying to configure a Computing resource to point to my local TM1 server.
TM1 instance has HTTPPortnumber=62302. IntegratedSecurityMode=1 UseSSL=T
First issue I ran into was this message:
URI: GET
https://localhost:62302/api/v1/Configuration?$select=ServerName,ProductVersion HTTP/1.1
Error: com.ibm.jsse2.util.h: PKIX path building failed: java.security.cert.CertPathBuilderException: unable to find valid certification path to requested target
Exit with code 12
If I browse to
https://localhost:62302/api/v1/Configuration?$select=ServerName,ProductVersion, I also get a certificate error relating to an unknown issuer.
I found some articles telling me to install the TM1_Server_Certificate in all the JRE environments like.
https://www.ibm.com/support/knowledgecenter/SSPLNP_10.2.2/com.ibm.swg.ba.cognos.ag_ccc.10.2.2.doc/c_ug_ccc_pi_tm1_1022_configuration.htmlhttps://www.ibm.com/support/pages/configure-datasource-ibm-planning-analytics-20x-ibm-cognos-analytics-1106I tried converting the tm1svrcert.pem to CER and adding to the keystore with the Alias TM1Server. No change in error.
I then tried ibmtm1.arm and received a different error:
URI: GET
https://localhost:62302/api/v1/Configuration?$select=ServerName,ProductVersion HTTP/1.1
Error: Host name 'localhost' does not match the certificate subject provided by the peer (CN=TM1Server, OU=TM1, O=www.ibm.com, C=US)
Exit with code 12
I have tried the machine name, IP Address etc. but the mismatch obviously relates to something else.
Any ideas? Do I need to create a self-signed certificate and use this? If so, any pointers?
Thank you.
------------------------------
George Tonkin
------------------------------
#PlanningAnalyticswithWatson