Jobs scheduled in IST timezone run 30 minutes later than scheduled

Document ID : KB000084616
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :

Jobs defined in Applications Manager (AM) that have schedules that use the IST time-zone run 30 minutes later than their scheduled time.

OS Version: N/A
Cause type:
Root Cause: Definition of IST incorrectly set as GMT 5 in the aw_timezone_list table causing jobs which have schedules using IST to run 30 minutes late.
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Applications Manager 9.1.1 - Available
Applications Manager 8.0.17 - Available
Additional Information:
Workaround :
Log into the Application Manager database as the AM Oracle userid and run the following SQL.

SQL>update aw_timezone_list set aw_gmt_diff = 5.5 where aw_tz_name = 'IST'; SQL>commit;

This will adjust the 30 minute time discrepancy with IST schedules.

BEWARE: If awinstall is run using a version that does not contain the fix after running the above update statement, the default value will revert back to GMT5.