ORA-00904: "FTKM"."DATA_PRECISION": Invalid Identifier Adding Olap Option (Doc ID 1085104.1)

Last updated on APRIL 15, 2010

Applies to:

Oracle OLAP - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

You upgraded your database from 10g to 11g.

You ended up with the following Invalid OLAP objects:

select owner, object_name, object_type, status from dba_objects where status ='INVALID' ;

OWNER     OBJECT_NAME    OBJECT_TYPE      STATUS
----------------------------------- -------------------- ------------------- --------- -------
OLAPSYS CWM2_OLAP_METADATA_REFRESH PACKAGE BODY INVALID
OLAPSYS CWM2_OLAP_VERIFY_ACCESS PACKAGE BODY INVALID
OLAPSYS MRV$OLAP1_FACTTBLKEYMAPS VIEW INVALID
PUBLIC    MRV_OLAP1_FACTTBLKEYMAPS SYNONYM INVALID

 

You receive errors when you try to compile the objects:

SQL> alter package olapsys.CWM2_OLAP_METADATA_REFRESH compile body;

Warning: Package Body altered with compilation errors.

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

LINE/COL ERROR
-------- -----------------------------------------------------------------
1254/1 PL/SQL: SQL Statement ignored
1257/42 PL/SQL: ORA-00904: "DATA_PRECISION": invalid identifier

If you run olap.sql script to reinstall OLAP, you receive the following errors:

 

grant select on mrv$olap1_facttblkeymaps to public
*
ERROR at line 1:
ORA-04063: view "OLAPSYS.MRV$OLAP1_FACTTBLKEYMAPS" has errors


Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY CWM2_OLAP_METADATA_REFRESH:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1254/1 PL/SQL: SQL Statement ignored
1257/42 PL/SQL: ORA-00904: "DATA_PRECISION": invalid identifier


Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY CWM2_OLAP_VERIFY_ACCESS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
777/5 PL/SQL: SQL Statement ignored
779/10 PL/SQL: ORA-04063: view "OLAPSYS.MRV$OLAP1_FACTTBLKEYMAPS" has
errors


PL/SQL procedure successfully completed.


Grant succeeded.

BEGIN cwm2_olap_metadata_refresh.mr_refresh; END;

*
ERROR at line 1:
ORA-04063: package body "OLAPSYS.CWM2_OLAP_METADATA_REFRESH" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"OLAPSYS.CWM2_OLAP_METADATA_REFRESH"
ORA-06512: at line 1


Changes

You upgraded your database to 11g but the mrv$olap1_facttblkeymaps table was not upgraded.

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