Apply Oracle E-Business Suite 12.2.12 Release Update Pack 33527700 failed:
===========================================================================ADOP (C.Delta.15)
Session ID: 2
Node: prod
Phase: apply
Log: /prod/fs_ne/EBSapps/log/adop/2/20250325_115806/adop.log
===========================================================================
Applying patch 33527700.
[WARNING] Skipping patch 33527700 as it has already been applied.
[WARNING] You can reapply a patch by adding options=forceapply to the adop command line.
Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2025/03/25 11:59:27"
[WARNING] Skipping patch 33527700 as it has already been applied.
[WARNING] You can reapply a patch by adding options=forceapply to the adop command line.
Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log:/prod/fs_ne/EBSapps/log/adop/2/20250325_115806/apply/prod/log/cutover.log
AutoPatch error:
Error running SQL and EXEC commands in parallel
You should check the file
/prod/fs_ne/EBSapps/log/adop/2/20250325_115806/apply/prod/log/cutover.log
for errors.
[UNEXPECTED]Error occurred in CUTOVER.
[UNEXPECTED]Apply phase has failed.
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
As per worker log :
Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Done AutoPatch R120 ADZDWRKR.sql FAILED
sqlplus -s APPS/***** @/prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &pw_apps CUTOVER 1 1 1'
Connected.
PL/SQL procedure successfully completed.
Connected.
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qsmqbtss_build_table_subordsets:
topsqb is null], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1243
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 465
ORA-06512: at "APPS.AD_ZD_PARALLEL_EXEC", line 465
ORA-06512: at line 61
Fix:
1) Worker logfile did not capture much information2) Most of the issues due to objects INVALID, check objects as per worker log and compile them and try restart worker
2) Check alert log and find details of trace file or error.
In my case i found there is a Meterialized view causing issue WORKER ADZDWRKR.sql failure.
qsmqbtss_build_table_subordsets: dump qsmksum
MV: owner = APPS name = XXCUS_PEOPLE_IN_PARTIES
3) Check and drop MV , we can recreate post upgrade.
SQL> DROP MATERIALIZED VIEW APPS.XXCUS_PEOPLE_IN_PARTIES;
Materialized view dropped.
SQL>
4) Restar worker
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Done AutoPatch R120 ADZDWRKR.sql Fixed & restart
5) Restart patch with restart=yes and abondon=no option and patch completed succesful.
adop phase=apply apply_mode=downtime patches=33527700 patchtop=<33527700 location> restart=yes abandon=no
Happy troubleshooting, please comment if you need any further help/information 👍
0 Comments