My Oracle Support Banner

XOQ-01706 and 'STALE CUBE DIMENSION' error during AW build in 11g (Doc ID 559616.1)

Last updated on MARCH 10, 2020

Applies to:

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

Symptoms

The following error was raised when trying to create a Materialized View (MV) for an OLAP cube in AWM:
 
An error has occurred on the server
Error class: OLAPI
Server error descriptions:
INI: ORA-37162: OLAP error
XOQ-01706: An unexpected condition occurred during the build: "STALE CUBE DIMENSION MV: <MVIEW NAME>"
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2537
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2743
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2712
ORA-06512: at line 1
 in function: TxsRdbSQLStatement::execute(), Generic at TxsOqConnection::generic<BuildProcess>/
// /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$1.construct(Unknown Source)
at oracle.olap.awm.ui.SwingWorker$2.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

It was possible to load the dimensions and cube and display the data in AWM .

Changes

 

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
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.