E005102 Agent error -- jobs aren't running

Document ID : KB000090048
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
E005102 Agent error -- jobs aren't running
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>;