Kbase P132024: 4GL/ABL: TIME & NOW functions return wrong result when the Time Zone (TZ) is set using the Olson tim
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/06/2009 |
|
Status: Verified
SYMPTOM(s):
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 database log file will reflect the UTC time and not the local time.
TZ (Time zone) via smit is getting set to Americas/New_York
If the ICU_DATA environment variable is removed from the pro or mpro scripts the 4GL client behaves 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 reset using the AIX smit utility.
Previous versions of AIX used the POSIX time sone specification. Example: TZ=EST5EDT
IBM AIX POWER 6.1
IBM AIX POWER 6.1 64-bit
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge Category: Language (4GL/ABL)
CAUSE:
Bug# OE00169752
FIX:
Upgrade to OpenEdge 10.2A or later.
If upgrading is not possible at this time, then 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/pro and $DLC/bin/mpro scripts.