Master in TROUBLE Status

Document ID : KB000089867
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Master in TROUBLE Status
Resolution:
Applicable toApplications Manager Versions:  v7.1, v8.0

Error MessageDetails:

AwE-5016 Master TimeZone doesn't match the Database (09/01/09 18:53)

Details: 59 minutes offset


Symptom

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 Automic support with the gathered information at support@automic.com.