Kbase P148046: AppServer showing the wrong time when posting transactions on AIX 6.1 when Time Zone is set to Ameri
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/08/2009 |
|
Status: Verified
SYMPTOM(s):
AppServer is showing the wrong time when posting transactions on AIX 6.1 when the Time Zone is set to America/New_York
AppServer broker and server log files showing times that are about 4 hours in the future.
Code to display time on the AppServer is showing times that are bout 4 hours in the future.
Sample code to check time on the AppServer:
DEFINE VARIABLE systime AS CHARACTER.
DEFINE OUTPUT PARAMETER system-time AS CHARACTER.
systime = string(time,"HH:MM:SS").
system-time = systime.
proadsv script contains the line: ICU_DATA=${ICU_DATA-$DLC/lib/icu/data}; export ICU_DATA
4GL/ABL: TIME & NOW functions return wrong result when the Time Zone (TZ) is set using the Olson time zone naming conventions.
TIME & NOW functions return the Coordinated Universal Time (UTC) instead of the correct local time when the TZ environment variable is set using the Olson time zone database.
TIME & NOW functions return correct result when the TZ environment variable is set using the POSIX time zone specification.
If the TZ environment variable is set using the Olson time zone, then any 4GL application data calculated using either the TIME or the NOW functions will reflect the UTC time and not the local time.
If the TZ environment variable is set using the Olson time zone, then the times in the AppServer broker and server log files will reflect the UTC time and not the local time.
TZ (Time zone) via smit is getting set to America/New_York
If the ICU_DATA environment variable is removed from the proadsv scripts the AppServer Agents behave as expected even if the time zone (TZ) environment variable is specified as Olson time zone naming convention.
FACT(s) (Environment):
TZ (Time zone) is being set using the AIX smit utility.
TX (Time zone) is being set to Olson time zone naming convention instead of POSIX time zone.
Previous versions of AIX used the POSIX time zone specification. Example: TZ=EST5EDT
IBM AIX POWER 6.1
IBM AIX POWER 6.1 64-bit
OpenEdge 10.1B
OpenEdge 10.1C
CAUSE:
Bug# OE00186187
FIX:
A workaround for this issue is to manually set the Time Zone enviroment variable using the POSIX time zone specification. Example: TZ=EST5EDT or
Remove the ICU_DATA environment variable from the $DLC/bin/proadsv scripts.
FIX:
References to Written Documentation:
See the section in the IBM AIX Version 6.1 Differences Guide that deals with Olson time zone support located at: http://www.redbooks.ibm.com/redbooks/pdfs/sg247559.pdf
Progress Solution(s):
P132024, "4GL/ABL: TIME & NOW functions return wrong result when the Time Zone (TZ) is set using the Olson time zone naming conventions."