ORA-36848:Object Name UNIT Is Different Than TIME
(Doc ID 1984360.1)
Last updated on OCTOBER 25, 2019
Applies to:Oracle OLAP - Version 126.96.36.199 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.
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