MSDODPCODE.sql fails with ORA-00600: internal error code, arguments: [xspsELMAINT02] while Applying Patch 14247039 (Doc ID 1531469.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Symptoms

You are  installing patch 14247039 and  MSDODPCODE.sql fails with the following error:

ORA-00600: internal error code, arguments: [xspsELMAINT02], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 29271 (ORA 600 [xspsELMAINT02]) ========

*** 2013-02-17 07:25:19.068
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=g8achv3c83nyc) -----
DECLARE
  templob CLOB;
begin
  msd_aw_loader.attach_code_aw;
  dbms_aw.execute('&(if exists(''temp.program'') then ''cns TEMP.PROGRAM'' else ''dfn TEMP.PROGRAM program aw express'')');
  dbms_aw.execute('cns TEMP.PROGRAM');
  dbms_aw.execute('prg joinlines( ''if exists (\''<USER_NAME>.<AW_NAME>\'')'' -
  '' then delete <USER_NAME>.<AW_NAME>'' -
  ''define <USER_NAME>.<AW_NAME> PROGRAM '' -
)');
  dbms_aw.execute('call TEMP.PROGRAM');
  dbms_aw.execute('PROPERTY DELETE ALL');
  dbms_aw.execute('PROPERTY ''FILENAME'' ''MSDCHECKSLREF.sql''');
  dbms_aw.execute('cns <USER_NAME>.<AW_NAME>;program;
" Copyright (C) Oracle Corporation 2003. All rights reserved.
"*-------------------------------------------------------------------------*
"* Title: <USER_NAME>.<AW_NAME>
"* Description: Check references of saved selections in other objects
"*
"* Return Value(s):
"*-------------------------------------------------------------------------*
"* $Revision:
"* $Date:
"* $Author: lannapra $
"*-------------------------------------------------------------------------*
arg _custAgg text
vrb _length1 number
vrb _length2 number
vrb _ret text
lmt AG.ENTRY TO ALL
lmt AG.ENTRY TO AG.CATALOG(AG.PROP ''SAVEDSEL'') eq _custAgg
_length1 = statlen(ag.entry)
lmt pb.sl.entry to all
lmt pb.sl.entry to pb.sl.catalog(pb.sl.prop ''SAVEDSEL'') eq _custAgg
_length2 = statlen(pb.sl.entry)
if _length1 gt 0 or _length2 gt 0
then _ret = ''1''
if _length1 eq 0 and _length2 eq 0
then _ret = ''0''
show _ret
pushlevel ''<USER_NAME>.<AW_NAME>''
push oknullstatus
oknullstatus = YES
poplevel ''<USER_NAME>.<AW_NAME>''
return
"*------------------------------ Modifications ---------------------------------*
"*------------------------------------------------------------------------------*
;end');
  msd_aw_loader.update_code_aw;
end;

Stack Trace: xsoops xspsELMAINT PGKILL RSDEALOC RSEMPTY RSERASE eraseone xsOBJERASE xsDELDENT xsDELETE

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.