Page 1 of 1

The time logged in TM1Server.log is one hour behind

Posted: Tue Mar 02, 2010 9:18 am
by Sandhya Kumar
Hi,

In one of the 9.4 FP2 servers, I see the time logged in tm1server.log file is one hour behind the local time. For example, when the local time is 3:30 AM, the log shows 2:30 AM. In tm1s-log.properties, i have specified the time as LOCAL.

Code: Select all

# Specify GMT or Local timezone
log4j.appender.S1.TimeZone=Local
I'm not sure why there is a lag still. How can i make both the server time and the log time insync?

Thanks for your help!
The last updated time shows 3:30 AM here
The last updated time shows 3:30 AM here
screen1.JPG (8.52 KiB) Viewed 3948 times
Inside the log, it shows 2:30 AM
Inside the log, it shows 2:30 AM
screen2.JPG (22.86 KiB) Viewed 3948 times

Re: The time logged in TM1Server.log is one hour behind

Posted: Tue Mar 02, 2010 10:44 pm
by Martin Ryan
Hi Sandhya,

The log files are recorded in GMT (or UTC depending on your lingo), whereas the server time will be, well, the server time.

TM1 does this for replication purposes. If User A in New York makes a change to a cell at a certain time, and User B in New Delhi makes a change at another time, in order for replication to be certain that it picks up the latest number it must use the same time zone for both users.

It's one of the few highlights of working in London in the winter- at least the log files give you the right time!

Cheers,
Martin

Re: The time logged in TM1Server.log is one hour behind

Posted: Wed Mar 03, 2010 6:34 am
by Sandhya Kumar
Thanks Martin,

I've specified the time-zone as LOCAL in my tm1s-log.properties file. I was assuming by LOCAL, it means the server time so the time logged in the tm1server.log should reflect the current time of the server. Please correct me if I'm wrong

Re: The time logged in TM1Server.log is one hour behind

Posted: Wed Mar 03, 2010 7:00 am
by Sandhya Kumar
Got it!!

When we set to LOCAL time-zone, TM1 actually writes the server's local time into the logs. I was viewing that data directory(shared) from a machine whose time is one hour ahead of that server's time. That just occured to me. Silly :lol:

Thanks!