search cancel

Master in TROUBLE Status

book

Article ID: 89867

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Master in TROUBLE Status


Error MessageDetails:


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

Details: 59 minutes offset

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Applicable to Applications Manager Versions:  v7.1, v8.0, v9.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 Automic support with the gathered information at [email protected]