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