My Oracle Support Banner

Invalid Analytical Workspace After 32 Bit - 64 Bit Migration (Doc ID 1281464.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Oracle OLAP - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 5-Nov-2019***

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

After migrating  32 bit database to 64 bit, all 3 Olap components are valid in the DBA_REGISTRY.

SQL> select rpad(comp_name,35), status, version from dba_registry where
comp_name like '%OLAP%';


RPAD(COMP_NAME,35) STATUS VERSION
----------------------------------- ----------- ------------------------------
OLAP Analytic Workspace VALID 11.1.0.7.0
Oracle OLAP API VALID 11.1.0.7.0
OLAP Catalog VALID 11.1.0.7.0


However, you have the following 3 invalid OLAPSYS objects:

SQL> select owner, object_name, status from dba_objects where status = 'INVALID' and OWNER = 'OLAPSYS' ;

OLAPSYS CWM2_OLAP_OLAPAPI_ENABLE INVALID
OLAPSYS DBMS_AWM INVALID
OLAPSYS CWM2_OLAP_METADATA_REFRESH INVALID


Manually compiling  the objects fails with following errors:

SQL> alter package olapsys.DBMS_AWM compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY OLAPSYS.DBMS_AWM:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2475/25 PL/SQL: SQL Statement ignored
2475/39 PL/SQL: ORA-00980: synonym translation is no longer valid
2482/5 PL/SQL: Statement ignored
2482/27 PLS-00364: loop index variable 'C_DIM_ENABLED' use is invalid
2492/5 PL/SQL: Statement ignored

SQL> alter package olapsys.CWM2_OLAP_METADATA_REFRESH compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY OLAPSYS.CWM2_OLAP_METADATA_REFRESH:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2581/1 PL/SQL: SQL Statement ignored
2594/6 PL/SQL: ORA-00980: synonym translation is no longer valid

SQL> alter package olapsys.CWM2_OLAP_OLAPAPI_ENABLE compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
93/30 PL/SQL: SQL Statement ignored
93/57 PL/SQL: ORA-01775: looping chain of synonyms

Changes

You upgraded your database from 32 bit to 64 bit.

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.