adop phase=cutover FAILED: file ADZDWRKR.sql on worker 1
adop phase=cutover FAILED: file ADZDWRKR.sql on worker 1 ORA-00600: internal error code, arguments: [kqllod:no stub for dependency
Time is: Tue Jan 31 2023 13:34:01
(Deferment number 2 for this job)
Assigned: file ADZDWRKR.sql on worker 1 for product ad username APPLSYS.
Time is: Tue Jan 31 2023 13:34:01
FAILED: file ADZDWRKR.sql on worker 1 for product ad username APPLSYS.
Time is: Tue Jan 31 2023 13:34:16
ATTENTION: All workers either have failed or are waiting:
FAILED: file ADZDWRKR.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Jan 31 2023 13:34:16
Telling workers to quit...
1 worker has quit. Waiting for 23 more.
2 workers have quit. Waiting for 22 more.
All workers have quit.
Connecting to APPS......Connected successfully.
AutoPatch error:
Error running SQL and EXEC commands in parallel
Freeing includes hash table
Freeing fixes hash table
Freeing basedons hash table
Freeing entities hash table
You should check the file
/erp_appl/apps/fs_ne/EBSapps/log/adop/65/20230131_132638/cutover/appsnode1/log/cutover.log
for errors.
adworker logs
cat adwork001.log
-----------------------
************* Start of AD Worker session *************
AD Worker version: 12.2.0
AD Worker started at: Tue Jan 31 2023 13:33:11
APPL_TOP is set to /erp_appl/apps/fs1/EBSapps/appl
Worker id = 1
Started by: adpatch
NLS_LANG value from the environment is : AMERICAN_AMERICA.AR8MSWIN1256
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.AR8MSWIN1256
Connecting to SYSTEM......Connected successfully.
Already asked for the ORACLE username and password
of Application Object Library.
(The given username/password was: APPLSYS/*****)
Connecting to APPS......Connected successfully.
The status of various features in this run of AD Worker is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Currently, the following languages are installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
AR Arabic Install
Reading language information from applAR.txt ...
Your base language will be AMERICAN.
Your other languages to install are: ARABIC
Ready to run jobs.
Setting parallel context: PARALLEL AUTOPATCH AT R120
Time when worker started job: Tue Jan 31 2023 13:33:11
Start time for file is: Tue Jan 31 2023 13:33:11
sqlplus -s APPS/***** @/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 0 1 24'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Time when worker completed job: Tue Jan 31 2023 13:33:14
Time when worker started job: Tue Jan 31 2023 13:33:29
Start time for file is: Tue Jan 31 2023 13:33:29
sqlplus -s APPS/***** @/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 0 9 24'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Time when worker completed job: Tue Jan 31 2023 13:33:29
Time when worker started job: Tue Jan 31 2023 13:33:29
Start time for file is: Tue Jan 31 2023 13:33:29
sqlplus -s APPS/***** @/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 1 1 1'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency
parent], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1229
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 459
ORA-06512: at line 34
Time when worker failed: Tue Jan 31 2023 13:33:44
Time when worker started job: Tue Jan 31 2023 13:33:45
Start time for file is: Tue Jan 31 2023 13:33:46
sqlplus -s APPS/***** @/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 1 1 1'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency
parent], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1229
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 459
ORA-06512: at line 16
Time when worker failed: Tue Jan 31 2023 13:34:00
Time when worker started job: Tue Jan 31 2023 13:34:01
Start time for file is: Tue Jan 31 2023 13:34:01
sqlplus -s APPS/***** @/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 1 1 1'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency
parent], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1229
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 459
ORA-06512: at line 34
Time when worker failed: Tue Jan 31 2023 13:34:16
Manager says to quit.
Time when worker quit: Tue Jan 31 2023 13:34:16
AD Worker is complete.
Errors and warnings are listed in the log file
/erp_appl/apps/fs_ne/EBSapps/log/adop/65/20230131_132638/cutover/au1637/log/adwork001.log
and in other log files in the same directory.
Solution:
DROP MATERIALIZED VIEW before custover adop phase=cutover
recreate the MATERIALIZED VIEW after custover adop phase=cutover