My Oracle Support Banner

NI: XOQ-00703: Error Executing OLAP DML Command "(AW ATTACH AW1 RO : ORA-33262: Analytic workspace T2.AW1 does not exist) (Doc ID 2041163.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

Symptoms

You had a working system based on Oracle Database with OLAP option on 10g version. After upgrading from 10g to 11g , you are no longer able to access AW objects owned by another user.

The only user able to query cubes in the AW is the AW owner. You have an 11g database but the AWs are Cube Type: OLAP 10g .

You have 2 users: GLOBAL and T2.  AW1 AW is owned by user global. You grant  select on global.aw$aw1 to T2.

 

GRANT SELECT ON global.aw$global TO T2;

GRANT SELECT ON product TO T2;  where product is a dimension.

Errors with:

SQL Error: ORA-00942: table or view does not exist

Note: While it is necessary to grant object lever (dimensions, cubes etc) security in 11g, if your AW is 10g cube type, then this is not needed. YOu only need to grant security at the AW level
 but even after that, user T2 is still not able to view any data in the global AW owned by global. In AWM data viewer, or Discoverer for olap, you get this error:
INI: XOQ-00703: error executing OLAP DML command "(AW ATTACH GLOBAL RO : ORA-33262: Analytic workspace T2.GLOBAL does not exist.

Note: In the error message above, Oracle is looking for the AW in schema T2 and not global.

Changes

 Upgrade from 10G to 11G and AWs still in 10G format.

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
References


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