Error Maintaining Cube
842519Mar 27 2011 — edited Mar 29 2011Hi All,
There is a very strange issue I'm facing. When I build a cube, using multiple processes, i.e. setting parallelism to a value > 1, the build completes successfully the first time. However, the second time I maintain the cube, I am getting the following error:
BEGIN dbms_cube.build('STOCK USING (load, solve)', parallelism=>6, add_dimensions=>false, scheduler_job=>'Stock_Cube', method=>'C'); END;
*
ERROR at line 1:
ORA-37162: OLAP error
XOQ-00703: error executing OLAP DML command
"(SYS.AWXML!R11_ACQUIRE_MEAS('STOCK.CUBE' NA) : ORA-00600: internal error code,
arguments: [xsMAKDPTR02], [], [], [], [], [], [], [], [], [], [], []
)"
ORA-06512: at "SYS.DBMS_CUBE", line 236
ORA-06512: at "SYS.DBMS_CUBE", line 280
ORA-06512: at line 1
It seems that the previous build just corruped the cube in the AW?
Running it from the AWM produces the following error:
oracle.express.idl.util.OlapiException: java.sql.SQLException: ORA-00600: internal error code, arguments: [xsMAKDPTR02], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.GENDATAPROVIDERINTERFACE", line 62
ORA-06512: at line 1
at oracle.express.idl.ExpressOlapiDataSourceModule.DataProviderInterfaceStub.generic(Unknown Source)
at oracle.olapi.data.source.DataProvider.callGeneric(Unknown Source)
at oracle.olapi.data.source.DataProvider.callGeneric(Unknown Source)
at oracle.olapi.data.source.DataProvider.executeBuild(Unknown Source)
at oracle.olap.awm.wizard.awbuild.UBuildWizardHelper$2.construct(Unknown Source)
at oracle.olap.awm.ui.SwingWorker$2.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I am using Oracle 11.2.0.1, on an AIX 64 bit platform.
Any idea?