Troubleshooting
Problem
When installing IBM Planning Analytics Spreadsheet Services using the short-cadence (SC) installer version 59 or earlier, invalid paths could be created in the WebSphere liberty server configuration files. These paths must be corrected in order to run the service, and before upgrading the service.
Symptom
The most common symptom is that the Spreadsheet Services cannot access the TM1 Servers due to invalid Java trust store certificates. When this happens:
- No TM1 Servers are visible in the web interface.
- Error messages referencing the invalid paths will be found in the Websphere Liberty Server logs.
In rare cases, depending on how the LC installation was configured, the Websphere Liberty Server may not be able to run. When this happens:
- The web interface will be unavailable (404 or similar error response).
- Error messages referencing the invalid paths will be found in the Websphere Liberty Server logs.
Cause
The issue arises in the following circumstances:
- The system has a long-cadence (LC) installation of IBM TM1.
- IBM Planning Analytics Spreadsheet Services is installed with the short-cadence (SC) installer, using version 59 or earlier.
- The path to the LC installation directory is a prefix of the path to the SC installation directory.
After the SC installation, the configuration file <sc-install-directory>/wlp/usr/servers/tm1web/jvm.options will have invalid paths.
Example in a Windows installation:
- The LC path is "C:\ "C:\Program Files\ibm\pa"
- The SC path is "C:\Program Files\ibm\pa-web".
- The invalid paths will start with "C:\Program Files\ibm\pa-web-web".
Resolving The Problem
-
Stop the IBM Planning Analytics Spreadsheet Services if it is running.
-
Using a text editor, open the configuration file <sc-install-directory>/wlp/usr/servers/tm1web/jvm.options .
-
Locate the lines with invalid paths. The trustStore parameter is usually affected, and will look like:
-Djavax.net.ssl.trustStore=<invalid path>/bin64/ssl/tm1store
*Other lines may also be affected, depending on the LC configuration. -
Correct the paths in the invalid lines and save the file.
-
Restart the IBM Planning Analytics Spreadsheet Services.
Note: Performing an upgrade of the SC installation using version 60 or higher will not correct the problem. SC upgrades preserve the existing configuration files, so will preserve the invalid file paths. The paths must be corrected and the IBM Planning Analytics Spreadsheet Services must be in an operational state before doing an SC upgrade.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzIaAAK","label":"Installation and Configuration"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
02 December 2020
UID
ibm16376124