Jobs abort with a FIN-DB ERROR

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Jobs may abort with a FIN-DB ERROR if any one or more Schedules do not have a "Reschedule from date" value. Generally, if the Job is reset, it finishes successfully.

Reviewing the RmiServer<timestamp>.log during time of error will show a similar error as below:

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-20999: Scheduling has encountered an exception - Scheduling will not continue until issue is resolved
ORA-20000: General Failure "schedule start from date is null"

In addition to this error, a missing 'Reschedule from date' value in a Schedule can also generate a number of additional errors. One particular error is a "numeric or value error: character string buffer too small" as seen below.

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPWORX.AWAPI", line 553
ORA-20000: Not logged into AppWorx

Environment

Release: 9.3
Component: APPMGR

Cause

The "Reschedule from date" value is not required in Applications Manager version 8x but is required in 9.x.

Resolution

Find and fix all Schedules that have a missing "Reschedule from date" value. The affected schedule is generally provided within the RmiServer error message.

The following sql can be run to easily find all schedules which has a missing "Reschedule from date" value:

 

select aw_job_seq, aw_sch_name from aw_module_sched where aw_sch_units in ('-1','-2') and aw_sch_frm_date is NULL;

Additionally, while we recommend manually updating schedules from the Java Web Client, the following sql can be used to set affected schedules' "Reschedule from date" value to the "Scheduled start date" value of each schedule:

update aw_module_sched set aw_sch_frm_date=aw_sch_start where aw_job_seq in (select so_job_seq from so_job_table) and aw_sch_units in (-1, -2) and aw_sch_frm_date is NULL;
commit;

Please refer to the DBA when before running any update statements.