Error 1067 when starting IBM Cognos TM1 Server Service

Post Reply
remus25
Posts: 5
Joined: Tue Aug 09, 2022 9:55 am
OLAP Product: IBM Cognos TM1
Version: 10.3.1.3900
Excel Version: 2019

Error 1067 when starting IBM Cognos TM1 Server Service

Post by remus25 »

Hello

When I try to start the service, I get the error 1067
also when I give a service user admin rights, this error comes up

Image

[Save TM1 Server configuration].
The data directory exists.
The TM1 Server configuration is available.

[Save TM1 Server configuration].
The data directory exists.
The TM1 server configuration is available.

[Save TM1 Server configuration].
The data directory exists.
The TM1 server configuration is available.

[Save TM1 Server configuration].
The data directory exists.
The TM1 server configuration is available.

[Save TM1 Server configuration].
The data directory exists.
The TM1 server configuration is available.

[Save TM1 Server configuration].
The data directory exists.
The TM1 Server configuration is available.

[Startup]
[ ERROR ] startup_tm1s.bat D:/TM1_2022_DP/Data
TM1 Configuration Path is D:\TM1_2022_DP/data
TM1 Server Name is bis_2022_DP
TM1_SERVICE_ID is default
BINARY_PATH_NAME : "C:\Program Files\ibm\cognos\tm1_64\bin64\tm1sd.exe"
The service "IBM Cognos TM1 Server - bis_2022_DP" is registered
errorlevel 0 exit 0
TM1 Configuration Path is D:\TM1_2022_DP\Data
TM1 Server Name is bis_2022_DP
TM1_SERVICE_ID is default
Starting the service "IBM Cognos TM1 Server - bis_2022_DP" ...
IBM Cognos TM1 Server - bis_2022_DP is started.
errorlevel 1 exit 1
IBM Cognos TM1 Server - bis_2022_DP could not be started.

A system error occurred.

System error 1067 occurred.

The process was terminated unexpectedly.
User avatar
Steve Rowe
Site Admin
Posts: 2416
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by Steve Rowe »

Suggest you look at the tm1server.log to see if there is further information. The windows event viewer may also ocassionally give you more information
Technical Director
www.infocat.co.uk
remus25
Posts: 5
Joined: Tue Aug 09, 2022 9:55 am
OLAP Product: IBM Cognos TM1
Version: 10.3.1.3900
Excel Version: 2019

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by remus25 »

In the Log I have:

Unable to receive server on port 35751. Check the log file for more details.
but I configure the port 35752 in the tm1s.cfg file, how can I change the port 35751 ?
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by burnstripe »

When the service is starting it it sounds like it is attempting to run on port 35751 but can't because something else is already using it.
You can view what ports are actively being used on the server by opening powershell and running netstat -a
Any ports listed are currently being used...

There are a few parameters to configure in tm1s.cfg
HttpPortNumber
PortNumber
ClientMessagePortNumber

If multiple models are running on the same server, differing ports must be set for each instance.
If any of these parameters are not listed in tm1s.cfg, create them as otherwise they'll be automatically assigned to something.

You'll also need to make sure any firewalls allow access through these ports to be able to communicate with them.
remus25
Posts: 5
Joined: Tue Aug 09, 2022 9:55 am
OLAP Product: IBM Cognos TM1
Version: 10.3.1.3900
Excel Version: 2019

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by remus25 »

I have chosen other ports from the beginning and netstat confirms that they are not used, where do I look ?
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by burnstripe »

"when I give a service user admin rights"

Have you checked that the service user running "IBM Cognos TM1 Server - bis_2022_DP" has got write access to D:\TM1_2022_DP\data

If the service account doesn't have access then the 1067 error will occur. The service account even if given permission may not be able to see the mapped drive. In which case use the unc instead to point to the folder
remus25
Posts: 5
Joined: Tue Aug 09, 2022 9:55 am
OLAP Product: IBM Cognos TM1
Version: 10.3.1.3900
Excel Version: 2019

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by remus25 »

yes, the user have full rights to this drive, folder and subfolder
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by MarenC »

Hi,

You might have already answered this but have you tried changing the port numbers?

Maren
remus25
Posts: 5
Joined: Tue Aug 09, 2022 9:55 am
OLAP Product: IBM Cognos TM1
Version: 10.3.1.3900
Excel Version: 2019

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by remus25 »

yes i have already changed the port numbers
ppniederbracht
Posts: 2
Joined: Wed Nov 28, 2018 1:10 pm
OLAP Product: TM1 / PA
Version: Latest
Excel Version: Office 365

Re: Error 1067 when starting IBM Cognos TM1 Server Service

Post by ppniederbracht »

Sorry for the late reply. I had the same error and found that the config-path in the registry (regedit) didn't update as I changed it in Cognos Configuration.

Way in Regedit: Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\<<Name given in Cognos Configuration>>

Maybe someone is still in need for this info ;-)
Post Reply