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' -
ue constraint (SQLOPR4.PK_USERS_LOG) violated
ORA-06512: at "SQLOPR4.LOG_ROLLOVER", line 102
ORA-06512: at line 1
These types of problems can be caused by a bad value entered in the Time Zone field for the Master.
To enter a valid value in the time zone field, you will need to update the database from SQL*Plus:
select aw_tz_name, aw_tz_seq from aw_timezone_list order by aw_tz_name;
update so_operators set so_time_zone=<valid time zone seq>;