Troubleshooting
Problem
IBM Planning Analytics Spreadsheet Services after update/fresh install of version 2.0.99 or newer, cannot list database instances when using custom SSL
Symptom
Unable to see DB instances in the TM1 Web in login screen.
Instances are up and running.
DB can be accessed using different clients
Custom SSL are in use.
In older version with this same configuration all was working fine.
In tm1_messages.log located in <INSTAL_DIR>\tm1web\wlp\usr\servers\tm1web\logs\ we can see entry like
11/29/24, 15:16:18:050 CET] 0000004a com.ibm.ws.ssl.core.WSX509TrustManager E CWPKI0824E: SSL HANDSHAKE FAILURE: Host name verification error while connecting to host [IP_ADDRESS]. The host name used to access the server does not match the server certificate's [Subject Alternative Name [dnsName:FQDN]]. The extended error message from the SSL handshake exception is: [No subject alternative names matching IP address IP_ADDRESS found].
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC7fAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EInstall Configure and Upgrade"}],"ARM Case Number":"TS017931539","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.9;and future releases"},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
19 May 2025
UID
ibm17177474