Page 1 of 1

Client Timezone sets improperly after server restart

PostPosted: Wed Apr 23, 2014 3:10 pm
by mmcmanus
I have looked around a bit for this issue including Java webstart Stuff. But have not found a fix or a good reason. Some clients have their timezone set to UTC when launched after we restart the Server. Only after a Server restart. If the client is inactive for a week after the restart, when they open again, the timezone might be UTC. Not every client. Only some. This includes some Windows users and MAc users. When the client restarts again, the timezone goes back to their normal. Forcing the timezone won't work, since we have users in other timezones. I have tried setting the timezones on those users clients, but it does no stay. Has anyone else seen this and have any experience with it?

Its an issue for timestamps, which get set improperly when the time is UTC. And timestamps are kinda important for some things here.

We are running:
Servoy version 6.1.6 -releaseNumber 1439
JVM Information
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.version=1.6.0_35
java.vm.info=mixed mode
java.vm.vendor=Apple Inc.
Operating System Information
os.name=Mac OS X
os.version=10.7.5
os.arch=x86_64

Re: Client Timezone sets improperly after server restart

PostPosted: Wed Apr 23, 2014 3:44 pm
by m.vanklink
Very interesting we have a similar problem that we cannot exactly address. We have a table that has an id of type servoy_seq and a field log_creation_dt of type datetime. When a new record is created the field log_creation_dt is automatically filled using Auto Enter>System Value>creation server datetime.

Now we see in the database that sometimes the highest id-value does not have the newest log_creation_dt. It looks like this record was created using the wrong timezone and thus was placed two hours back (our difference with UTC).

How do you determine that these clients have their timezone set to UTC? Is application.getServerTimeStamp() different from application.getTimeStamp() in this case?

Re: Client Timezone sets improperly after server restart

PostPosted: Wed Apr 23, 2014 7:06 pm
by mmcmanus
The easiest way is to check in Server admin in the Clients tab. Double click on a client and it will give you the clients details, including the locale which specifies a timezone. You can also check in the client itself under preferences in the locale tab. You can change it there if you desire.

The two should be different if the locales are different.

Re: Client Timezone sets improperly after server restart

PostPosted: Fri May 09, 2014 4:34 pm
by jcompagner
what you have seems to be this:

https://support.servoy.com/browse/SVY-4984

thats a bug in the java/javawebstart. We created a workaround for that (included in 7.3 and also backported to 6.0.x)