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

Last updated on JUNE 27, 2012

Applies to:

Oracle OLAP - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Jun-2012***

Symptoms

You migrate 32 bit 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


When you try to manually compile the objects, you get 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

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