TI NOW() return GMT even though server is set to GMT+8

[kangkc]

Just encountered an issue with TI Now() function under 9.5.2 FP1 as I'm getting different results on two servers (2008R2) that have both System time set to GMT+8.
One server return GMT time, whereas another server return local time (which is GMT+8).

Based on my experience and document, Now() should return the local time which in my case GMT+8, hence something is very wrong with the first server.

I don't think this is a TM1 bug but rather some configuration on the sever OS, else I'll raise a ticket to IBM. Any suggestion ?

[qml]

Quite frankly I don't know for sure if this will affect what NOW() returns, but it is possible to configure transaction logging to use either local time or GMT. To do that edit the tm1s-log.properties file.

You can either use

Code: Select all

log4j.appender.S1.TimeZone=GMT

or

Code: Select all

log4j.appender.S1.TimeZone=LOCAL

Check if this parameter is the same or different for your servers.

[kangkc]

Thanks. I doubt this will change anything as both server has the exact same log setting.

NOW() in TM1 should be utilizing standard windows API to obtain the system time, I think I'll write a WSH script that call NOW() and see if I get the same results.

[rmackenzie]

I think I'll write a WSH script that call NOW() and see if I get the same results.

You can just do this on the command line:

Code: Select all

echo %time%