PA 2.0.7 - PA as datasource in CA 11.1.5

Post Reply
svar229
Posts: 5
Joined: Mon Mar 16, 2020 4:10 pm
OLAP Product: TM1/ Planning Analytics
Version: 10.2.2/ PA2.07
Excel Version: 2016

PA 2.0.7 - PA as datasource in CA 11.1.5

Post by svar229 »

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?
jorelb
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

Post by jorelb »

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.
burnstripe
Regular Participant
Posts: 197
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

Post by burnstripe »

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
Post Reply