IBM Support

TM1runTI with CAM security gives (TM1 API Error) SystemServerClientNotFound

Troubleshooting


Problem

Trying to execute a process through TM1runTI.exe, on a TM1 Server that is using CAM security (IntegratedSecurityMode=5), the following error occurs:
(TM1 API Error)
SystemServerClientNotFound
Server connection failed

Resolving The Problem

Here is a example of command that will work with the "Planning Sample" that was configured with CAM security :

tm1runti.exe -adminhost MyAdminHostName -server "Planning Sample" -CAMNamespace "CognosEx" -user "Admin" -pwd "MyPa$$w0rd" -process "plan_load_actual_ascii"
-> In the TM1runTI command, if some parameter includes spaces, then enclose that parameter in double-quotes

-> The CAMNamespace must match the "Namespace id" that is displayed on the right side of the Cognos Configuration, on the Cognos Analytics installation (Content Manager component): this must not match the namespace name that is displayed on the left side of Cognos Configuration.
-> If the CAM security is based on "OIDC" then TM1runTI cannot work : check this in the Cognos Configuration tool on the Cognos Analytics side, in the "Type" property.

-> If there are special characters in the password, then temporarily change the user's password so that to exclude all special characters, and test again ; if it is confirmed that special characters are causing the problem, then report this issue to IBM Support.

-> Verify that the windows user / domain user who is running TM1runTI has at least read permission on the /tm1_64/bin64/ssl and all its files.
-> On the same machine where TM1runTI is installed, open a cmd.exe command window, and run "telnet MyAdminHostName 5498" so that to check whether TM1 Admin Server is accessible from here. If not accesible, then verify "IBM Cognos TM1 Admin Server (x64)" service is running. If it is running, then verify that port 5498 is not blocked by some firewall between the machine where TM1runTI is executed and the machine where TM1 Admin Server is running.

-> On the same machine where TM1runTI is installed, open Architect and verify that it can access the TM1 Server using the same user/password. If Architect cannot list the available TM1 Servers, then there is a problem with certificates ; report this issue to IBM Support. If Architect can see the TM1 Server but cannot connect, then report this issue to IBM Support, providing detailed error message, tm1server.log and tm1s.cfg.
-> If TM1runTI command is executed through Powershell, then try a classic command-line window instead (cmd.exe)
-> If nothing helps, then set all these parameters in the tm1s-log.properties that should be found in the same directory as tm1s.cfg on the TM1 Server:
log4j.logger.TM1.Lock.Exception=DEBUG
log4j.logger.TM1.Login=DEBUG
log4j.logger.TM1.CAMSecurity=DEBUG
log4j.logger.TM1.SSPI=DEBUG
log4j.logger.TM1.SSPISecurity=DEBUG
If there is no existing tm1s-log.properties then copy it from the samples directory (C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\tm1s-log.properties), then add the above lines to this file, and put that file in the same directory as the tm1s.cfg config file of your TM1 server. After reproducing the problem, send the whole tm1server.log to IBM Support.
Please be aware that there is now a new "RunProcess" Turbo Integrator command that may be used instead of the TM1runTI since Planning Analytics 2.0.7:
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/pa_nf_run_ti_process_on_own_thread.html

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":"a8m50000000KzJeAAK","label":"Security->CAM (Business Intelligence, Cognos Analytics)"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]

Document Information

Modified date:
05 November 2020

UID

ibm16349135

Page Feedback