Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Maintaining Cube

842519Mar 27 2011 — edited Mar 29 2011
Hi 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2011
Added on Mar 27 2011
7 comments
570 views