IBM Support

Error 'Could not start the TM1 Server / tm1servername service on Local Computer' when starting Windows service

Troubleshooting


Problem

Administrator right-clicks on the Windows server 'TM1 Server / ' and chooses 'start'. After a few seconds, an error message appears.

Symptom

Screen:

Services

Could not start the TM1 Server / myservername service on Local Computer.

Error 1067: The process terminated unexpectedly

Event Viewer (Application Log)


Event Type: Error
Event Source: tm1sd
Event Category: None
Event ID: 0
Date: 21/01/2010
Time: 10:00:29
User: N/A
Computer: MYSERVERNAME
Description:
The description for Event ID ( 0 ) in Source ( tm1sd ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: tm1sd error: 3, Data directory not specified. Aborting server start up..

Cause

The TM1 Server data location folder had not been created/populated correctly.

Resolving The Problem

TIP: The following instructions assume the software has been installed in the default location. If not, then please modify as appropriate. For example, modify <tm1servername> for the name of your TM1 server.

  1. On the TM1 server, create a new folder (to store data) such as D:\TM1Data\<tm1servername>
  2. Copy the file "C:\Program Files\Cognos\TM1\Custom\TM1Data\PlanSamp\Tm1s.cfg” to the new folder (such as D:\TM1Data\<tm1servername>\Tm1s.cfg)
  3. Repeat for the file TM1s.lic
  4. Click ‘Start – Run’ and type the following (modify folder as necessary) and then press <Enter>: notepad "D:\TM1Data\<tm1servername>\Tm1s.cfg"
  5. Modify the ‘DataBaseDirectory’ to the correct value (for example ‘D:\TM1Data\<tm1servername>\’)
  6. Modify the ‘ServerName’ to the correct value (for example myservername)
  7. Normally you can leave the PortNumber value as the default (12345). However, if you have multiple services started (for example ‘PortNumber=12345’) then you must make each server run under a unique TCP port number
  8. For best results add (or modify the existing) the following setting (inside the ‘[TM1S]’ section): GroupsCreationLimit=20

    ...TIP: This can be increased (default = 20, maximum = 65535) later if necessary but keep in mind that the TM1 server allocates memory for the value you choose, so you should keep the value as small as possible. The value is based on how many groups you are likely to create in a single server session. So, if you use GroupsCreationLimit=50 you will be able to create 50 groups now and then another 50 each time you restart your TM1 service. An established TM1 model is likely fine setting this to 20 because you will not be adding that many groups per TM1 session. Please see the Operation's Guide for more detail (link below) on all tm1s.cfg parameters.
  9. Save and re-try.

Related Information

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.1;9.5;9.4 MR1;9.4;9.1;9.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21418346