When testing IBM Planning Analytics 2.0.7 data source from IBM Cognos Analytics 11.1.5 the following message is displayed :
XTR-ERR-0005 A request to TM1 resulted in error: "[400] javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.h: PKIX path building failed: java.security.cert.CertPathBuilderException: unable to find valid certification path to requested target".
We imported the certificate in the cacerts keystore through the ikeyman, but still not working. Is there any other certificates that should be imported?
PA 2.0.7 - PA as datasource in CA 11.1.5
-
- Posts: 71
- Joined: Fri Feb 13, 2009 1:41 am
- OLAP Product: IBM Planning Analytics Cloud
- Version: 2.0.9 IF (2)
- Excel Version: 2016
Re: PA 2.0.7 - PA as datasource in CA 11.1.5
If I am not mistaken, to be able to use PA as a CA data source, the PA version should be 2.0.8 IF (2) or higher.
-
- Regular Participant
- Posts: 212
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: PA 2.0.7 - PA as datasource in CA 11.1.5
Using PA as a datasource for CA has been around for ages, the version 2.0.7 should be fine to use of a datasource with 11.1.5.
When setting up a new data connection in Cognos Analytics you should be selecting the type "IBM Planning Analytics". If UseSSL=T is set in your TM1 instance then ensure use ssl is ticked when setting up the connection. If you using single sign on also set the signon type to integrated secuirty.
The host should be the servername of your planning analytics install
Port number should be the HTTPPortNumber specified in the tm1s.cfg file for your Planning Analytics instance
I suspect with your message the issue is perhaps the right certificate hasn't been imported (ibmtm1.arm from bin64/ssl). Follow the instructions given on this ibm page
https://www.ibm.com/support/pages/confi ... ytics-1106
If it's still not working check that the certificate is there using a tool like keystore explorer
https://keystore-explorer.org/
You'll be able to look at the certificate here
Also if SSO is enabled make sure your Planning Analytics instance is authenticating against the Cognos Analytics server you're trying to import the data
When setting up a new data connection in Cognos Analytics you should be selecting the type "IBM Planning Analytics". If UseSSL=T is set in your TM1 instance then ensure use ssl is ticked when setting up the connection. If you using single sign on also set the signon type to integrated secuirty.
The host should be the servername of your planning analytics install
Port number should be the HTTPPortNumber specified in the tm1s.cfg file for your Planning Analytics instance
I suspect with your message the issue is perhaps the right certificate hasn't been imported (ibmtm1.arm from bin64/ssl). Follow the instructions given on this ibm page
https://www.ibm.com/support/pages/confi ... ytics-1106
If it's still not working check that the certificate is there using a tool like keystore explorer
https://keystore-explorer.org/
You'll be able to look at the certificate here
Also if SSO is enabled make sure your Planning Analytics instance is authenticating against the Cognos Analytics server you're trying to import the data