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

Last updated on FEBRUARY 22, 2013

Applies to:

Oracle OLAP - Version 11.2.0.2 and later
Information in this document applies to any platform.

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 (\''DP.CHECKSLREF\'')'' -
  '' then delete DP.CHECKSLREF'' -
  ''define DP.CHECKSLREF PROGRAM '' -
)');
  dbms_aw.execute('call TEMP.PROGRAM');
  dbms_aw.execute('PROPERTY DELETE ALL');
  dbms_aw.execute('PROPERTY ''FILENAME'' ''MSDCHECKSLREF.sql''');
  dbms_aw.execute('cns DP.CHECKSLREF;program;
" Copyright (C) Oracle Corporation 2003. All rights reserved.
"*-------------------------------------------------------------------------*
"* Title: DP.CHECKSLREF
"* 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 ''DP.CHECKSLREF''
push oknullstatus
oknullstatus = YES
poplevel ''DP.CHECKSLREF''
return
"*------------------------------ Modifications ---------------------------------*
"*------------------------------------------------------------------------------*
;end');
  msd_aw_loader.update_code_aw;
end;

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms