Re: Daylight Savings Time bug? Experts requested

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"bjohs" <bjohs@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CC7C380-39D8-4E22-A961-67B6D5129710@xxxxxxxxxxxxxxxx

This is NOT really a TIME update -- it is a DISPLAY based on time zone
and
DST.

This could be the main problem. If it is just "displaying" the correct
time, there may be something in the OS time that is not sync'ing.

No, that is entirely unlikely (which was my point) since the TIME is
still set to the Universal Time it always had.

From you description you have largely eliminated System problems
and pointed the finger strongly at the application.

The OS time is still maintained in Universal Time (aka GMT).
What API call does your software use?

The software is written in JSP and runs on Apache Tomcat 5.0, Java Runtime
Environment and MySQL. Again, the application does not have any time
settings of its own.

Are you sure that neither the JSP, the Apache, the Java Runtime, nor
the MySql server doesn't have time settings?


The data just gets written according to server time.

Likely the software (at some level above) is reading the UT time and
applying
the WRONG offset on it's own.

This is very common for software that either has no "DST" update OR
has not yet been updated.

You really should look for JSP, the Apache, the Java Runtime, and MySql
updates or query newsgroups on this software for problems with DST
date changes.

If I manally changed the server clock to read 12:59pm when the real time
would only be 12:15pm, a new file would show up for 1:00pm even though it
was
not actually 1pm yet. I hope that explains that it is not our software
reading incorrectly, it is reading an incorrect time caused by the server.

No it doesn't explain that.

Do you suppose that since the 2:00 AM hour was SKIPPED that the
software never "saw" 2:00 AM?

It shouldn't have seen 2am at all but it was writing data to the 2am file.
The time on the server said 3am.

How does the software "know" when the time is due? Does it poll or
wait for callback?

It just reads the timestamp on a data file that is written on the server.
Let's say the server time is off by 20 minutes for some reason. Our
software
will then also be off by 20 minutes.


So this implies the server was properly updated (Automatic Updates
etc.).
Yes, it was properly updated.

You have an application problem -- what specific languages and API calls
are you using?

Yes, it was set to Central Time with the box checked to adjust for DST.
So the problem is in your app (code).

I honestly don't believe it is. If I manually changed the clock on the
server to read 5pm right now, our software will begin reading files on the
server for 5pm and mark that there is data for 5pm.

Because the app is then working from the "wrong TIME" and by applying
the WRONG OFFSET getting the time (accidentally) correct at the expense
of having all the other problems associated with the wrong time.

IF you must change something (temporarily) change the TIME ZONE as you
said earlier.

Temporary fix: I had to change the timezone to Eastern time instead
of
Central Time in order to display the correct hour in our software.

Do this instead.

That was the PROPER way to adjust a machine without the patch -- as
opposed to the incorrect method of changing the actual time which
would
change the Universal Time (GMT) used for time sync purposes.

This would make me believe that Microsoft didn't "really" fix the
problem.

Why? The computer changed it's display of the correct time.

I wonder if there is more to what needs to be fixed other than just
"displaying" the correct time. Kind of like the saying: You can put
lipstick
on a pig, but it is still a pig.

No. The time is maintained in UT, and shown by TimeZone offset with the
adjustment for DST.

So if you look at the file system (open a command prompt and type "DIR")
do you see the correct time stamp on the Write and Create times?

C:\>copy con TEST.txt
(type something) press control-Z

C:\>dir test.txt
03/11/2007 11:54 AM 6 Test.txt

OR:
C:\>dir /T C test.txt (time CREATED)
C:\>dir /T W test.txt (time WRITTEN)


That is what I am trying to figure out. If the patch covered everything,
we
should not have seen any data in a file for 2am.

I agree, but our server still wrote data to a 2am file even though the
time
on the server said 3am.

You don't really mean to a "2:00 AM FILE" do you? But rather it wrote
data INTO a file with that time OR it INVENTED a FILE NAME that
encoded that time, right?

The file itself actually shows the correct CREATED and WRITTEN times
using the commands I gave you above doesn't it?


--
Herb Martin, MCSE, MVP
http://www.LearnQuick.Com
(phone on web site)


.

Relevant Pages

  • Re: AD, Win 2000, and new 2007 Daylight savings time
    ... You need to do it on every machine that you locally want displaying the proper time. ... An Exchange server that runs server side scripts could have an issue though if the scripts work in localtime instead of UTC. ... Will we need to patch our clients are will the time be ok Since we are using authoritative time server manage the time. ...
    (microsoft.public.win2000.active_directory)
  • Re: tcl cgi script
    ...    My goal is to setup a web server which will display home page. ... I click on a button in the homepage, server should execute some script ... But it is displaying like above. ... Don't use Tcl with Apache. ...
    (comp.lang.tcl)
  • Re: Connection string for ASP.NET or ASP
    ... Displaying is not so complex... ... second, if you don't know how to play with your cube, maybe you have to ... SSPI=Kerberos is required when the web server and the OLAP server are ... What is general Connection String script used? ...
    (microsoft.public.sqlserver.olap)
  • authentication problem with index containing include
    ... It contains a Server Side Include. ... however the include component itself isn't displaying on ... READ/Execute permissions to the index page and the ... ssinc.dll is registered in IIS Manager to handle .shtml ...
    (microsoft.public.inetserver.iis)
  • Re: Daylight Savings Time bug? Experts requested
    ... Unfortunately it is just a web-based application that runs on the server ... When it displays an hour of data, it is just reading from the ... Even though the server time was displaying correctly, ... make me believe that Microsoft didn't "really" fix the problem. ...
    (microsoft.public.windows.server.general)