My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.