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.
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 .
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