Ora-33272: Analytic Workspace Mp_aw.Mp_aw Cannot Be Opened (Doc ID 1409164.1)

Last updated on JULY 07, 2017

Applies to:

Oracle OLAP - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


On : 11.2.0.1 version, DBA Utilities for OLAP Catalog

When attempting to refresh an OLAP cube the following error occurs.

ERROR
-----------------------
<ERROR TEXT="ORA-33272: Analytic workspace MP_AW.MP_AW cannot be opened.
ORA-33275: Autonomous transaction query of an UPDATEd analytic workspace is not supported"/>


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

DECLARE
jobid VARCHAR2(100);
BEGIN
SELECT DBMS_SCHEDULER.GENERATE_JOB_NAME('JOB$_') INTO jobid FROM DUAL;
DBMS_SCHEDULER.CREATE_JOB(
jobid, 'plsql_block',
'begin
dbms_cube.build(
''units_cube, price_cost_cube'',
atomic_refresh=>true,
parallelism=>0);
end;',
0, null, null, null, 'DEFAULT_JOB_CLASS', true, true, 'CUBE Job');
END;
/

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms