Troubleshooting
Problem
After configuring Planning Analytics Spreadsheet Services (TM1 Web) with custom SSL / TLS / HTTPS, the "IBM Planning Analytics Spreadsheet Services" service is started but is not listening (by default, javaw.exe is listening on port 9510)
One of these errors can occur:
In tm1_messages.log:
CWPKI0819I: The default keystore is not created because there is no password in the <keyStore id="defaultKeyStore"/> element, and the 'keystore_password' environment variable is not set.
In console.log:
CWWKG0014E: The configuration parser detected an XML syntax error while parsing the root of the configuration and the referenced configuration documents. Error: The reference to entity "xxx" must end with the ';' delimiter. File: file:/C:/Program%20Files/ibm/cognos/tm1web/wlp/usr/servers/tm1web/server.xml
(where "xxx" corresponds to the last part on the PFX password)
Cause
An ampersand character "&" is detected by the WebSphere Liberty XML parser when reading the password that is set in the <keyStore> tag.
Resolving The Problem
Escape the ampersand character by replacing it by its corresponding HTML encoded form: &
For example, open server.xml from "C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web" folder, and find this line:
<keyStore id="defaultKeyStore" location="${wlp.user.dir}/../../bin64/ssl/MyKeystore.pfx" password="ThereIsA&InMyPasswd" />
Replace it by this line (again this is an example):
<keyStore id="defaultKeyStore" location="${wlp.user.dir}/../../bin64/ssl/MyKeystore.pfx" password="ThereIsA&InMyPasswd" />
Finally, restart the TM1 Web service.
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":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzK7AAK","label":"Security-\u003ESSL"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
18 January 2022
UID
ibm16541472