Thursday, November 29, 2018

EBS ADOP Phase Failing Due to ORA-600 Error


There’s an issue in EBS 12.2 and database 12.1.0.2 versions related to Materialized Views. While executing ADOP (prepare, apply, finalize or cutover) phases, the cycle could fail due to an ORA-600 : internal error code, arguments: [kqllod:no stub for dependency parent] error.

After working with Oracle, they provided information about BUG 27883586 related to MView Refresh or Create while they are editioned.

The solution is to apply patch 27883586 to the database which is currently available for August 2017 release and then recreate the MViews. Oracle also released a merge patch on top if this (28820125).

If you need it for a different release, please contact Oracle to provide it.


Happy patching,
Alfredo

1 comment:

  1. great note, today I had a similar issue on cutover adop phase, I was checking on the net and I found this note from a good fried, as an additional comment I have applied the following patch on DB side, this patch is for have more details about the DB objects in conflict

    Patch: 19953905



    Before Patch application:

    Fri Mar 15 13:38:12 2019
    Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_19120.trc (incident=296022):
    ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [], [], [], [], [], [], [], [], [], [], []


    After patch application


    Fri Mar 15 13:54:21 2019
    Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30970.trc (incident=327856):
    ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_DMRT_UTILS_PKG], [], [173], [9], [APPS], [1035232], [1075], [], [], [], []
    Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327856/EBSSUPT_ora_30970_i327856.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 15 13:54:24 2019
    Dumping diagnostic data in directory=[cdmp_20190315135424], requested by (instance=1, osid=30970), summary=[incident=327856].
    Fri Mar 15 13:54:24 2019
    Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30976.trc (incident=327857):
    ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_INV_ORG_V], [], [173], [4], [APPS], [1669770], [710], [], [], [], []
    Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327857/EBSSUPT_ora_30976_i327857.trc


    In mi case two objects, one view and one package were the objects in conflict, (XXBLA_DMRT_UTILS_PKG and XXBLA_INV_ORG_V) after that I had to drop, execute cutover and then recreate the objects) now I am checking with Oracle support for check if there is a patch for does not have this kind of errors when the objects are views and packages


    Good Job Alfred
    Regards
    Carlos Romero

    ReplyDelete