tm1sd.exe file mysteriously re-executed

[Kaveenga]

Hi

The tm1sd.exe file mysteriously re-executed today at 1:53 pm, ending all open sessions and reloading the TM1 data directory . This is the 2nd time this has happened, the previous time was the 11th of Feb.

No event was logged on the windows services event logs, and below are the entries in the TM1server.log before the crash.

Would appreciate any comments/insight. I have also forwarded this to IBM.

Many thanks

Kavee



2472 INFO 2010-03-01 13:51:23,664 TM1.Table Process }Drill_FS Source executed by user JHallew
2472 INFO 2010-03-01 13:51:23,680 TM1.Chore Process "A_Drill_View_2" run from process "}Drill_FS Source" by user "JHallew"
2472 INFO 2010-03-01 13:51:23,711 TM1.Chore Process "zTD_Security_Get_User_Name_svWhoAmI" run from process "A_Drill_View_2" by user "JHallew"
2472 INFO 2010-03-01 13:51:23,726 TM1.Process Process "zTD_Security_Get_User_Name_svWhoAmI" finished executing normally, elapsed time 0.00 seconds
2472 INFO 2010-03-01 13:51:23,758 TM1.Process Process "A_Drill_View_2" finished executing normally, elapsed time 0.05 seconds
2472 INFO 2010-03-01 13:51:23,758 TM1.Process Process "}Drill_FS Source" finished executing normally, elapsed time 0.08 seconds
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Data Directory: d:\tm1\tm1database\
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Admin Host: FN-SPES-TM01
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Logging Directory: d:\tm1\tm1logfiles\
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Configuration Directory: d:\tm1\tm1database
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Port: 12345
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Export Admin Server Certificate: 0
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Admin Server Certificate Authority: C:\Program Files\Cognos\TM1\bin\ssl\applixca.pem
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Admin Server SSL Cert ID: tm1adminserver
6732 INFO 2010-03-01 13:52:31,321 TM1.Server SSL Mode: 1
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Export Server Certificate: 0
6732 INFO 2010-03-01 13:52:31,321 TM1.Server SSL Certificate: C:\Program Files\Cognos\TM1\bin\ssl\tm1svrcert.pem
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Certificate Authority: applixca.pem
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Client Export Server Certificate: 0
6732 INFO 2010-03-01 13:52:31,321 TM1.Server DH 512 File: C:\Program Files\Cognos\TM1\bin\ssl\dh512.pem
6732 INFO 2010-03-01 13:52:31,321 TM1.Server DH 1024 File: C:\Program Files\Cognos\TM1\bin\ssl\dh1024.pem
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Private Key Password File: C:\Program Files\Cognos\TM1\bin\ssl\tm1cipher.dat
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Password Key File: C:\Program Files\Cognos\TM1\bin\ssl\tm1key.dat
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Security Mode: 2
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Principal Name: TM1Service-s@int-app.stockex.com
6732 INFO 2010-03-01 13:52:31,321 TM1.Server Start time: Mon Mar 01 2010 01:52:31 PM
3308 INFO 2010-03-01 13:52:31,337 TM1.Server --------------------Session Start--------------------

[Herman Moller]

I see the last action prior to the server restarting was :

"2472 INFO 2010-03-01 13:51:23,758 TM1.Process Process "}Drill_FS Source" finished executing normally, elapsed time 0.08 seconds"

Was this drill through run the previous month when you had a similar restart?

Herman

[Martin Ryan]

Following on from Herman's suggestion, while you are bug fixing you might want to ensure the automatic restart of the service is turned off, so that if it is TM1 crashing the issue won't be clouded by the implication that something external has stopped and started your service.

My initial guess would be that you are running a 32 bit server and that you have hit the RAM limit so the server has fallen over. If your service is set to automatically recover, then it looks like it is simply reloading.

Cheers,
Martin

[Kaveenga]

Hi Herman and Ryan,

Thank you for your replies.

The "Process "}Drill_FS Source" process is run regularly by users without issue.

The server is a 64 bit server with 16 gb ram. TM1 was using under 7 GB of ram when the services restarted. Performance logs did not record any spikes in ram.

The service is set to automatic restart if the services unexpectedly crashes. However, this will trigger an event to be recorded in the windows event log. In this case there was none. Windows did not record a crash nor the restart

Regards

Kavee

[paulsimon]

Kavee

Try searching the cubes directory for any *.*$ files. These might indicate the cause of a crash, particularly if the time coincides with the crash.

Do you have a TM1 Top log for the time of the problem? That might show something.

Check whether IT have the dump logging turned on. You may need to extend the Service restart time to 15 minutes to give the dump logging time to work. At any rate this will allow you to distinguish between a random re-start of the service, and a crash. I suspect that the latter is more likely. You will probably need the dump before IBM will/can do anything.

There was something like a tm1*.properties file in the cubes directory that turns on full debug logging which might turn up something in the TM1Server.log.

Are there any tm1s.log files or tm1processerror log files that might help?

Regards


Paul Simon