My Oracle Support Banner

OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER Viewing Cube OR Measure Data in AWM (Doc ID 1589523.1)

Last updated on AUGUST 05, 2021

Applies to:

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

Symptoms

 You are trying to view data for a cube or measure and you receive the following errors:

oracle.dss.dataSource.common.QueryRuntimeException: BIB-9009 Oracle OLAP could not create cursor.
An error has occurred on the server
Error class: OLAPI
Server error descriptions:
DPR: cannot execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks
OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
, Generic at TxsRdbSQLQuery::absolute()

oracle.dss.dataSource.common.OLAPException: BIB-9009 Oracle OLAP could not create cursor.
An error has occurred on the server
Error class: OLAPI
Server error descriptions:
DPR: cannot execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks
OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
, Generic at TxsRdbSQLQuery::absolute()

An error has occurred on the server
Error class: OLAPI
Server error descriptions:
DPR: cannot execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks
OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
, Generic at TxsRdbSQLQuery::absolute()

Changes

 This only happens with an AW created from an EIF file and the relational tables are missing. The server changes the value of the
AllowAutoDataTypeChange property set by the client during the eif export.

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.