IBM Support

Must gather: PA_SSL_Checker tool on Windows to gather SSL/TLS information for IBM Support

Troubleshooting


Problem

The attached Powershell script is to be used for any kind of issues involving custom SSL/TLS on one of these components:
  • TM1 Server
  • TM1 Admin Server
  • TM1 Web
  • TM1 Application Web (pmpsvc)
  • Planning Analytics Spreadsheet Services
  • Planning Analytics Workspace

Resolving The Problem

     The following Powershell script is created to accelerate Support case resolution by gathering all SSL/TLS information that is required for initial analysis.
It does not modify anything in the existing configuration, and it neither installs any third-party product.
It doesn't matter whether the Planning Analytics services or tools are currently running or not.
 
     Download the following Powershell script, replace .TXT by .PS1, place it in a folder of your choice on the Windows machine where Planning Analytics Workspace is installed (note: the folder name must not contain any spaces).
PA_SSL_Checker.txt
 
On some systems, the following error message can occur when the script is running:
"File PA_SSL_Checker.ps1 cannot be loaded. The file PA_SSL_Checker.ps1 is not digitally signed."
"You cannot run this script on the current system."
Or
"The script will not execute on the system"
In that case, open a Powershell window manually and run this line:

Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass
Then, still in that same window, type the path to the script to run it.
If not sufficient, try one or both of these other commands:
 
Set-ExecutionPolicy unrestricted
Unblock-File -Path C:\<your_download_path>\PA_SSL_Checker.ps1

 
 
     After execution is complete, send the resulting "Audit_SSL_for_IBM_Support_<DateTime>.txt" file, along with all exported certificates *.CER files to IBM Support (all files are in the same folder as the script itself)
     In addition, take a look at the Powershell window before to close it, since this window contains important formatted information and advices about your configuration.
     Also provide the documentation links you followed when you implemented SSL/TLS configuration, as well as all steps followed (and output) of each command ran.

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":"a8m50000000KzK7AAK","label":"Security-\u003ESSL"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
10 January 2023

UID

ibm16516102