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."
"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
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"}]
Was this topic helpful?
Document Information
Modified date:
10 January 2023
UID
ibm16516102