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:
- Log into the AppWorx database as the AppWorx user.
- 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;
- Update the so_operators table by issuing the following command:
update so_operators set so_time_zone=<valid time zone seq>;