aw_install fails in BEGIN sched_migration.upd_oae; END;

Document ID : KB000088410
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
aw_install fails in BEGIN sched_migration.upd_oae; END;
Resolution:
Detailed Description and Symptoms
 BEGIN sched_migration.upd_oae; END;
   *
   ERROR at line 1:
   ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes   ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
   ORA-06512: at "SYS.DBMS_OUTPUT", line 32   ORA-06512: at "SYS.DBMS_OUTPUT", line 32
   ORA-06512: at "SYS.DBMS_OUTPUT", line 97   ORA-06512: at "SYS.DBMS_OUTPUT", line 97
   ORA-06512: at "SYS.DBMS_OUTPUT", line 112   ORA-06512: at "SYS.DBMS_OUTPUT", line 112
   ORA-06512: at "APPWORX.AWAPI2", line 582   ORA-06512: at "APPWORX.AWAPI2", line 582
   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 504   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 504
   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 157   ORA-06512: at "APPWORX.SCHED_MIGRATION", line 157
   ORA-06512: at line 1   ORA-06512: at line 1
Fatal Error occurred - check the log /evnapwl1/apps/appwxl1/install/aw_install.log

Investigation
The installation will complete if aw_install is run again a few more times. The problem is with the SCHED_MIGRATION script. If there are alot of OAE jobs to update. You may receive the following error.

ERROR at line 1:
   ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes   ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

Solution
Need to change a line in the inst.pl file in the $AW_HOME/data directory.
 
 From:       &run_sql("set serveroutput on size 1000000\nexecute awapi2.set_debug(1);\nexecute sched_migration.upd_oae\nquit\n",$tmp_log);
  ---
 To:       &run_sql("set serveroutput on size UNLIMITED\nexecute awapi2.set_debug(1);\nexecute sched_migration.upd_oae\nquit\n",$tmp_log);