AppWorx, Dollar Universe and Sysload Community

 View Only
  • 1.  Production upgrade failed

    Posted Sep 25, 2020 05:38 PM
    Im upgrading production AM from 9.1.3 to 9.2 and the upgrade fails with

      *
       ERROR at line 1:
       ORA-20001: Submit_chains job_seq=1308-ORA-20000: General Failure "schedule   ORA-20001: Submit_chains job_seq=1308-ORA-20000: General Failure "schedule
       start from date is null" - Submit MTL_TO_ITEM_COST_COMPARE sched=MONTHLY
       seq=1312
       ORA-06512: at "APWXPROD.AW_TIMEZONES", line 2115   ORA-06512: at "APWXPROD.AW_TIMEZONES", line 2115
       ORA-06512: at "APWXPROD.AWAPI3", line 2828   ORA-06512: at "APWXPROD.AWAPI3", line 2828
       ORA-06512: at "APWXPROD.SCHED_MIGRATION", line 726   ORA-06512: at "APWXPROD.SCHED_MIGRATION", line 726
       ORA-06512: at "APWXPROD.SCHED_MIGRATION", line 895   ORA-06512: at "APWXPROD.SCHED_MIGRATION", line 895
       ORA-06512: at line 18   ORA-06512: at line 18
    Fatal Error occurred - check the log /55h/appworx/AM/install/aw_install.log

    I opened a P1 but while Im waiting I thought Id post the issue here to see if anyone here has seen this.
    Thanks




    ------------------------------
    Craig Victor
    ------------------------------


  • 2.  RE: Production upgrade failed
    Best Answer

    Posted Sep 26, 2020 12:59 AM
    The following sql can be run to easily find all schedules which has a missing "Reschedule from date" value:

    SQL> 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:
    nolog> 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;

    SQL> exec awapi3.update_scheds;
    PL/SQL procedure successfully completed.
    SQL> commit;


    This will resolved the issue, i faced the same issue while upgrading to 9.3



  • 3.  RE: Production upgrade failed

    Posted Sep 28, 2020 12:37 PM
    This is from support it resolved my issue. Thanks for the reply.
    ​Case Summary:

    Error message seen:

    ORA-20001: Submit_chains job_seq=1308-ORA-20000: General Failure "schedule ORA-20001: Submit_chains job_seq=1308-ORA-20000: General Failure "schedule
    start from date is null"

    Issue was resolved using the following KE:

    https://knowledge.broadcom.com/external/article?articleId=100798
    Thanks
    Craig