My Oracle Support Banner

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

Last updated on NOVEMBER 05, 2022

Applies to:

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


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 Source)
at Source)
at Source)
at oracle.olap.awm.wizard.awbuild.UBuildWizardHelper$1.construct(Unknown Source)
at oracle.olap.awm.ui.SwingWorker$ Source)
at Source)

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




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

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