AwE-5016 Master TimeZone doesn't match the Database

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Master can sometimes be seen in  TROUBLE Status with the following errors noted in the RmiServer log

Error MessageDetails:

AwE-5016 Master TimeZone doesn't match the Database 

Details: XX minutes offset

Environment

CA Automic Applications Manage 9.x

Cause

This error is caused by a mismatch between the Applications Manager Oracle database and the time defined for the Master.

Resolution

- Verify the current time of the database by logging into the Applications Manager database and issuing:

     select to_char(sysdate,'YYYY MM DD HH24:MI:SS') from dual;

- Next verify the Master machine's time by running the following command:

Windows:
     time

Unix/Linux:
     date

- If this matches the database time,  then check to see if the Master and the Applications Manager's Oracle database are in the same timezone by logging into SQL Plus as the Applications Manager's user and run the following SQL:

     select sop.so_oper_name, ats.aw_tz_name, ats.aw_gmt_diff from so_operators sop, aw_timezone_list ats where sop.so_time_zone=ats.aw_tz_seq;

- Also run the following command to get the Master's timezone information from the aw_master_config table:

     select item, value from aw_master_config where item='MASTER_TIMEZONE';

- If the timezone information in these 2 queries doesn't match, please contact Technical Support.