ORA-36848:Object Name UNIT Is Different Than TIME (Doc ID 1984360.1)

Last updated on FEBRUARY 26, 2015

Applies to:

Oracle OLAP - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Receiving the following error while trying to view data after upgrading to 11g.

oracle.dss.dataSource.common.QueryRuntimeException: BIB-9009 Oracle OLAP could not create cursor.
oracle.express.idl.util.OlapiException: java.sql.SQLException: ORA-36848: Object name UNIT is different than TIME
ORA-06512: at "SYS.GENCURSORMANAGERINTERFACE", line 42
ORA-06512: at line 1



STEPS TO REPRODUCE:
===================
Connect to database  using Analytical Workspace Manager (AWM). select OLAP 10g as Cube Type when connecting to database in AWM.
Expand AW
Right click on cube UNITS and choose view data. Takes a while but then error pops up.

This works in 10g.

Changes

 Upgraded from 10g to 11g.

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