Fatal error during upgrade

Document ID : KB000100798
Last Modified Date : 11/06/2018
Show Technical Document Details
Issue:
The install fails with a fatal error message. In the aw_install.log file located in the master's log directory, an error similar to the following is seen:

ERROR at line 1:
   ORA-20001: Submit_chains job_seq=3067-ORA-20000: General Failure "schedule   ORA-20001: Submit_chains job_seq=3067-ORA-20000: General Failure "schedule
   start from date is null" - Submit TESTSCHED sched=TESTSCHED seq=3068
   ORA-06512: at "APPWORX.AW_TIMEZONES", line 2211   ORA-06512: at "APPWORX.AW_TIMEZONES", line 2211
   ORA-06512: at "APPWORX.AWAPI3", line 2828   ORA-06512: at "APPWORX.AWAPI3", line 2828
   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 726   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 726
   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 895   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 895

 
Cause:
The "Reschedule from date" value is not required in Applications Manager version 8x but is required in 9.x.
Resolution:
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;
 
While we recommend manually updating schedules from the Java Web Client prior to the upgrade, 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.