IBM Support

"Could not login to TM1 / SystemServerClientPasswordInvalid" with Cognos Controller FAP and TM1, caused by corrupt data mart definition

Troubleshooting


Problem

A new FAP/TM1 system is being set up. The initial connection to TM1 Server is via the default user 'admin' with blank password. On starting the Data Mart, it appears to connect and the TM1 log shows the process started. Then an error appears on the Log tab: "Could not login to TM1". Hovering over the error line with the mouse pointer shows the text "SystemServerClientPasswordInvalid". Yet the pasword saved in the Data Mart is definitely blank.

Symptom

Error inside Log:

Could not login to TM1

Hovering over the error line with the mouse pointer shows the text: "SystemServerClientPasswordInvalid"

However, the user has double-checked and the password saved in the Data Mart is definitely correct (blank in their case).

Cause

There are many potential causes for the generic error 'Could not login to TM1'.

  • TIP: For more examples, see separate IBM Technote #1664572.

This Technote specifically relates to the scenario where the cause is a corrupt Data mart definition.

Resolving The Problem

Delete and recreate the data mart definition.

Steps:

1. Make a screen print of the Data Mart tab in the Controller FAP client.

2. Delete this Data Mart.

3. Add it back using the same Periods etc, then admin as the client and no password.

4. Test again.

[{"Product":{"code":"SS9S6B","label":"Cognos Controller"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21472624