ORA-36848:Object Name UNIT Is Different Than TIME
Last updated on FEBRUARY 26, 2015
Applies to:Oracle OLAP - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
Right click on cube UNITS and choose view data. Takes a while but then error pops up.
This works in 10g.
Upgraded from 10g to 11g.
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