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 laterInformation 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
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
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
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 |