search cancel

E005102 Agent error -- jobs aren't running

book

Article ID: 90048

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

E005102 Agent error -- jobs aren't running

Environment

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

Resolution

Symptoms

You are experiencing a variety of problems including FORECAST modules that are in the job queue but not running, and problems logging into the client.

When you check the RMI server log file, you see messages similar to the following:

ErrorMsg: E005102 Agent error (3/7/04 12:01 AM)
Details: ERROR -999 -ERR 171 Database error on 'LOG_ROLLOVER' -
ORA-00001: uniq
ue constraint (SQLOPR4.PK_USERS_LOG) violated
ORA-06512: at "SQLOPR4.LOG_ROLLOVER", line 102
ORA-06512: at line 1


Cause

These types of problems can be caused by a bad value entered in the Time Zone field for the Master.


Resolution

Solution

To enter a valid value in the time zone field, you will need to update the database from SQL*Plus:

  1. Log into the AppWorx database as the AppWorx user.

  2. Find the correct time zone sequence by issuing the following command:
    select aw_tz_name, aw_tz_seq from aw_timezone_list order by aw_tz_name;
  3. Update the so_operators table by issuing the following command:
    update so_operators set so_time_zone=<valid time zone seq>;