Event time mismatch in Calendar | Infragistics Forums

State See Verified Answer
Replies 3 replies
Subscribers 9 subscribers
Views 817503 views
Users 0 members are here

WebSchedule

Event time mismatch in Calendar

Jon posted over 16 years ago

I'm having a very strange problem in one of our servers, event start and end times are different on different web servers while both IIS are reading exactly the same DB.

Lets say I have a meeting from 11:00 am to 1:00 pm.
Server A shows that in calendar correctly but server B keeps showing it from 12:00 to 2:00 pm.

Infragistics component versions are the same.
If I add Response.Write("DateTime.Now") to the top of the page, both servers give the same time.

This has to be some sort of IIS problem but I don't know what else to check.

- Jouni -

Parents

1414

Verified Answer
Roger Bogh posted over 16 years ago

Jouni,My guess is that you are having a problem with using the Universal Time. I think the control uses the time differential on the client (Pacific Standard Time for instance), but maybe it is using the servers time. Have you checked the time on the servers? Are the servers in different time zones? Are the clients in the same time zones? Check the actual settings on each. I would not assume the customer is correct in this case.Sorry...Just reread. I would check the timezone settings on the clients as the primary culprit - not either of the three servers. I don't think you are having an IIS problem, and you obviously are not having a database server problem since both copies of the application point to the same database server. Again, the scheduleinfo control has a conversion process which retrieves a UTC time from the database and provides a Local time to the client object.
Sorry if this isn't real clear. However, maybe it will help in a ramblin' way...
Cancel
Reply

Reject Answer

Cancel

Reply

78

Jon posted over 16 years ago in reply to Roger Bogh

SOLVED
Roger, you were on right track with timezones.
It turned out that the one of the servers didn't have latests MS Daylight savings patch installed. New Zealand changed Daylight savings end time to 6th of April. When I checked system Date and Time settings other server was using Standard time while other was still in Daylight savings time
Cancel
Reply

Cancel

Children

1414

Roger Bogh posted over 16 years ago in reply to Jon

Jon,

A little known nasty almost hit me. The time differentials with UTC can be in 1/2 hour increments. I created some SQL to retrieve the Activity records desired and convert to Local Time before displaying to a grid (as an appointment list). I was using hours. I will have to change to minutes. Not hard, but kinda suprising.
Cancel
Reply

Cancel