Daylight Savings Problem

[Former Member]

Version 11.5 MII

I have a quick question about a Daylight savings problem we are experiencing since yesterday. All of the MII queries that have "Date between [SD] and [ED]" are displaying the ED as one earlier which is causing problems for people. I looked on the servers to see if I just had to adjust the time, but everything looked good.

It was recommended that I download the Java Timezone patch to fix this problem (http://java.sun.com/javase/timezones/). We installed this on our DEV server and it did not solve the problem so we are running out of options. What should we do?

[agentry_src]

Hi Chip,

You may also want to google the OS DST patches available. They should have addressed it last year, but perhaps not.

Good luck,

Mike

Edited by: Michael Appleby on Oct 28, 2008 8:34 PM

[Former Member]

The operating system is reporting the correct time. It is MII that is not.

[agentry_src]

Chip,

Which service pack are you up to? I am testing 11.5.4 and I do not see the problem.

Also check this thread out: [DST|]

Mike

Edited by: Michael Appleby on Oct 28, 2008 8:43 PM

Edited by: Michael Appleby on Oct 28, 2008 8:44 PM

[Former Member]

The operating system is Windows 2003 Server Standard Edition. I am not sure which service pack it is.

[agentry_src]

Sorry, I meant the Service Release for 11.5. It should be up to 11.5.5 now. Sam's posting in the link references an update to the jre as well.

Mike

[Former Member]

Product Version: 11.5.2 b64

Plugin Version: Sun Microsystems Inc. 1.4.2_07

How do I get the update for MII and should I update the java to 1.4.2_13?

[agentry_src]

Hi Chip,

Try Download Manager for the upgrade to MII. And yes, I would update to 1.4.2_13 (or higher).

Thanks,

Mike

I would stay away from 1.4.2_18. A number of folks have reported problems with that specific release.

Edited by: Michael Appleby on Oct 29, 2008 12:05 PM

[Former Member]

Either upgrade to JAVA 1.4.2_13 or download the "TZUpdater" tool from SUN. I used the TZUpdater and it fixed the problem for me.

http://java.sun.com/javase/timezones/

[erik_schrampf]

Fix java DST issue in MII - Note # 1045572

If you are upgrading Java here is a note to uninstall it compeletly - Note # 1030041

Erik

[Former Member]

Please give me a link to these notes

[erik_schrampf]

Chip,

All SAP Notes are stored at https://service.sap.com/notes you just have to put the note number in the upper right hand corner. You will need login credential to Service Marketplace.

[Former Member]

It is asking for a user/pwd which I am not sure what it is. I tried to generate a new user, but it threw an error.

[erik_schrampf]

Chip,

This username and password is the same one you would use to download the SAP MII software or enter a support ticket. You may not have a login to this as your administrator may. It is something your SAP Super Administrator must create for you.

Here is basically what the note is saying I believe you found the answer already thought with the TZUpdater.

Sun has proposed two workarounds to address these issues

1. Apply the tzupdater tool with the -bc (backward compatibility) flag. If the tool has not been previously run this will update your installation to the latest available time zone data but will not add data for the EST, MST and HST IDs. If the tool has been previously run or your time zone data is already up to date you can run the tool with the -f (force) and -bc flags. This causes the data for the EST, MST and HST IDs to be removed from your installation. For more details on the tzupdater tool, please refer to http://java.sun.com/javase/tzupdater_README.html.

2. Manually remove the three time zone data files, EST, MST, and HST in the <JDK_HOME>/jre/lib/zi directory (or <JRE_HOME>/lib/zi).

Both workarounds have the effect of removing the data files for EST, MST and HST. When the system can't find the data files for EST, MST or HST it will fall back to using America/New_York for EST, America/Denver for MST, and Pacific/Honolulu for HST. These alternates observe daylight savings time and are thus compatible with the JDK's traditional behavior.

Note that by applying the above workarounds you choose compatibility with the JDK's traditional behavior over compatibility with the Olson time zone standard for the EST, MST and HST time zone IDs. Because the Olson definition for these three IDs is fairly recent (late 2005) and the availability of this data in a Java SE release is even more recent (mid 2006) Sun expects few current applications will require strict Olson compatibility.

According to the following SUN Java Bug links:

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6530336

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6466476

There are issues with the "tzupdater" tool that updates the timezone information for certain JDKs.

Your best bet is to upgrade to Java 1.4.2_13 or greater JDK/JRE 5.0u8 and above.

This note applies for all versions of Java.