Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

Configuring CCC on a local server

  • 1.  Configuring CCC on a local server

    Posted Sun October 25, 2020 03:00 AM
    Edited by System Admin Fri January 20, 2023 04:32 PM
    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.html
    https://www.ibm.com/support/pages/configure-datasource-ibm-planning-analytics-20x-ibm-cognos-analytics-1106

    I 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