The time logged in TM1Server.log is one hour behind

Post Reply
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

The time logged in TM1Server.log is one hour behind

Post 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 3872 times
Inside the log, it shows 2:30 AM
Inside the log, it shows 2:30 AM
screen2.JPG (22.86 KiB) Viewed 3872 times
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

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

Post 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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

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

Post 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
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

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

Post 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!
Post Reply