IBM Support

After enable IBM Planning Analytics Spreadsheet Service with Custom SSL unable to see any instances , Authentication error Login failed

Troubleshooting


Problem

After enable IBM Planning Analytics Spreadsheet Service with Custom SSL unable to see any instances

Symptom

unable to see any instances
Login failed error possible.
image-20230707114815-1

Cause

in console.log under <install directory> tm1web\wlp\usr\servers\tm1web\logs you can see entry like
ERROR   ] CWPKI0823E: SSL HANDSHAKE FAILURE:  A signer with SubjectDN [CN=TM1Server, OU=TM1, O=www.ibm.com, C=US] was sent from the host [127.0.0.1:5498].  The signer might need to be added to local trust store [C:/Program Files/ibm/cognos/tm1web/bin64/ssl/customKeystore.pfx], located in SSL configuration alias [defaultSSLConfig].  The extended error message from the SSL handshake exception is: [unable to find valid certification path to requested target].

Resolving The Problem

import Data tier to keystore used by the Planning Analytics Spreadsheet Service
to import data tier certificate  you can use keytool located un tm1web\jre\bin
keytool -importcert -keystore ..\..\bin64\ssl\customKeystore.pfx -storepass admin1234EXPORT -storetype pkcs12 -noprompt -alias ibmtm1 -file ..\..\bin64\ssl\dataTier.arm
please remember to customize the above command to match your environment 
 **The -keystore should reflect your keystore path which is set in server.xml 
  **The -storepass  must match pfx file password 
  **The -file should reflect path to the certficate which you want to import to the store
restart service is require to apply change
If issue still presented , please check if a new custom Planning Analytics Spreadsheet Service certificate is trusted by Data Tier

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000PC7fAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EInstall Configure and Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m3p000000PC7fAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EInstall Configure and Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
20 July 2023

UID

ibm17010315

Page Feedback