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

Last updated on NOVEMBER 05, 2022

Applies to:

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

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