My Oracle Support Banner

Invalid OLAP Objects After Upgrading the Database TO 12C or Above (Doc ID 1593666.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle OLAP - Version 12.1.0.1 and later
Information in this document applies to any platform.

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 upgrading Oracle Database to 12C or higher, you have the following invalid OLAP objects:

select owner, object_name, object_type from all_objects where status='INVALID' and owner like '%SYS%' order by owner;

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_VERIFY_ACCESS        PACKAGE BODY
OLAPSYS    CWM$EXPORT                     PACKAGE BODY
OLAPSYS    DBMS_AWM                       PACKAGE BODY
OLAPSYS    DBMS_AWM_PRV                   PACKAGE BODY
OLAPSYS    DBMS_AWM_PRV                   PACKAGE
OLAPSYS    CWM2_OLAP_OLAPAPI_ENABLE       PACKAGE BODY
OLAPSYS    DBMS_ODM                       PACKAGE BODY
OLAPSYS    OLAPDIMVIEW                    PACKAGE BODY
OLAPSYS    OLAPFACTVIEW                   PACKAGE BODY
OLAPSYS    CWM2_OLAP_METADATA_REFRESH     PACKAGE BODY
OLAPSYS    CWM2_OLAP_MR_SESSION_POP       PACKAGE BODY

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_MR_SECURITY_INIT     PACKAGE BODY
OLAPSYS    CWM2_OLAP_CLASSIFY             PACKAGE BODY
OLAPSYS    CWM2_OLAP_TABLE_MAP            PACKAGE BODY
OLAPSYS    CWM2_OLAP_DELETE               PACKAGE BODY
OLAPSYS    CWM2_OLAP_EXPORT               PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE             PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE_METADATA    PACKAGE BODY
OLAPSYS    CWM1_OLAP_VALIDATE_METADATA    PACKAGE BODY
OLAPSYS    CWM2_OLAP_VALIDATE_UTILITY     PACKAGE BODY
OLAPSYS    CWM2_OLAP_MEASURE              PACKAGE BODY
OLAPSYS    CWM2_OLAP_LEVEL_ATTRIBUTE      PACKAGE BODY

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -----------------
OLAPSYS    CWM2_OLAP_LEVEL                PACKAGE BODY
OLAPSYS    CWM2_OLAP_HIERARCHY            PACKAGE BODY
OLAPSYS    CWM2_OLAP_DIMENSION_ATTRIBUTE  PACKAGE BODY
OLAPSYS    CWM2_OLAP_DIMENSION            PACKAGE BODY
OLAPSYS    CWM2_OLAP_CATALOG              PACKAGE BODY
OLAPSYS    CWM2_OLAP_UTILITY              PACKAGE BODY
OLAPSYS    CWM2_OLAP_MANAGER              PACKAGE BODY
OLAPSYS    CWM2_OLAP_UTILITY              PACKAGE
OLAPSYS    CWM2_OLAP_VALIDATE_UTILITY     PACKAGE
OLAPSYS    CWM$UTIL                       PACKAGE BODY
OLAPSYS    CWM2_OLAP_CUBE                 PACKAGE BODY
SYS    CWM2_OLAP_INSTALLER          PACKAGE BODY


33 rows selected.

 

Changes

 

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.