ORA-00600: [XSPG: RSALOC02] during create mview using dimension

(Doc ID 1497386.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle OLAP - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

 Creating mview using OLAP dimension was throwing ORA-00600: [XSPG: RSALOC02]

 Steps to reproduce case
 
1. create table aadna_test
   as
   select level id, 'fs'||to_char(level) first_name, 'ls'||to_char(level)
   last_name , 'country'||mod(level,100) country, mod(level,100) country_id
   from dual
   connect by level < 1;

   begin
     for i in 1..100
     loop
         insert into aadna_test
         select level+1000000*(i-1)  id, 'fs'||to_char(level+1000000*(i-1))
         first_name, 'ls'||to_char(level+1000000*(i-1)) last_name ,
         'country'||mod(level+1000000*(i-1),100) country, mod(level+1000000*(i-1),100)
         country_id
         from dual
         connect by level < 1000000;
     end loop;
     commit;
   end;
   /

3. delete from aadna_test where id = 1;

4. alter table aadna_test add constraint at_pk primary key (id);

5. create table aadna_test_fact
   as
   select id, 1 amount from aadna_test;

6. alter table aadna_test_fact
   add constraint atf_pk primary key (id);
   CREATE DIMENSION AADNA_test
    LEVEL CUSTOMERS IS (aadna_test.id)
    level country is (aadna_test.country_id)
   hierarchy people (customers child of country)
   ATTRIBUTE CUSTOMERS LEVEL CUSTOMERS DETERMINES
   (aadna_test.first_name,aadna_test.last_name)
   attribute country level country determines(aadna_test.country);

7. CREATE  materialized VIEW aadna_test_mv
   build deferred as
   select first_name,last_name, sum(amount)
   from aadna_test a , aadna_test_fact b
   where a.id  = b.id
   group by  first_name,last_name;
   /

8. declare
   myCubeMv varchar2(32);
   begin
     myCubeMv :=
     dbms_cube.create_mview(
     mvOwner =>user,
     mvName =>'aadna_test_mv',
     sam_parameters=>'logDest=ServerOut,build=immediate,partitionoption=NONE' );
   end;  
   /

----- Incident Context Dump -----
Address: 0x7ffff854ec60
Incident ID: 30091
Problem Key: ORA 600 [CRESET02]
Error: ORA-600 [CRESET02] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgesinv []
[08]: xsoops []<-- Signaling
[09]: xsCRESET []
[10]: xsldLoadDone []
[11]: xssqlImport []
[12]: SQLOUT []
[13]: xsxeq_pcode []
[14]: xsXEQ []
[15]: xsILPXEQ []
[16]: xsILPCALL []
[17]: xsILPENG []
[18]: xsxeq_pcode []
[19]: xsXEQ []
[20]: xsILPXEQ []
[21]: xsILPCALL []
[22]: xsILPENG []
[23]: xsxeq_pcode []
[24]: xsXEQ []
[25]: xsEXECUT []
[26]: xsOLAPIEvaluateSPLExpression []
[27]: _ZN14TxsOqAWManager18evaluateEx []
[28]: _ZN14TxsOqAWManager25evaluateIn []
[29]: _ZN19TxsOqStdFormCommand25evalu []
[30]: _ZN19TxsOqStdFormCommand7execut []
[31]: _ZN19TxsOqStdFormCommand14callR []
[32]: _ZN41TxsOqLoadCommandProcessorD []
[33]: _ZN25TxsOqLoadCommandProcessor1 []
[34]: _ZN25TxsOqLoadCommandProcessor3 []
[35]: _ZN26TxsOqBuildCommandProcessor []
[36]: _ZN23TxsOqBuildItemProcessor14r []
[37]: _ZN19TxsOqBuildProcessor14runNe []
[38]: _ZN19TxsOqBuildProcessor17perfo []
[39]: _ZN19TxsOqBuildProcessor10nextA []
[40]: _ZN19TxsOqBuildProcessor14perfo []
[41]: _ZN19TxsOqBuildProcessor11finis []
[42]: _ZN19TxsOqBuildProcessor7execut []
[43]: _ZN19TxsOqBuildProcessor12execu []
[44]: _ZN15TxsOqConnection12executeBu []
[45]: _ZN15TxsOqConnection7genericEPK []
[46]: eDataProvider_generic_so []
[47]: xsoqStreamCallout []
[48]: eDataProvider_generic []
[49]: spefcmpa []
----- END Incident Context Dump -----

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