oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP did not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize()


Solutions on the web4

Solution icon of oraclecommunity
via Oracle Community by 455412, 1 year ago
datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize()

Solution icon of oraclecommunity
BIB-9509 Oracle OLAP did not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs4 OES: ORA-00904: "AW44

Solution icon of oraclecommunity
via Oracle Community by 420197, 11 months ago
BIB-9509 Oracle OLAP heeft cursor niet gemaakt. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-12801: error

Solution icon of oraclecommunity
via Oracle Community by 438370, 1 year ago
BIB-9509 Oracle OLAP did not create cursor. Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45

Stack trace

oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP did not create cursor.
oracle.express.ExpressServerExceptionError class: OLAPI
Server error descriptions:
DPR: Unable to create server cursor, Generic
at TxsOqDefinitionManagerSince9202::crtCurMgrs2
OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
, Generic
at TxsRdbStatement::initialize()
oracle.express.ExpressServerExceptionError class: OLAPI
Server error descriptions:
DPR: Unable to create server cursor, Generic
at TxsOqDefinitionManagerSince9202::crtCurMgrs2
OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
, Generic
at TxsRdbStatement::initialize()
	at oracle.dss.dataSource.QueryEvaluator.setUpCursors(QueryEvaluator.java:3669)
	at oracle.dss.dataSource.QueryEvaluator._setUpCursorsForMainQuery(QueryEvaluator.java:2563)
	at oracle.dss.dataSource.QueryEvaluator.getCursorForCube(QueryEvaluator.java:2595)
	at oracle.dss.dataSource.QueryEvaluator.createCubeAndCursor(QueryEvaluator.java:986)
	at oracle.dss.dataSource.MainQueryEvaluator.createCubeAndCursor(MainQueryEvaluator.java:171)
	at oracle.dss.dataSource.QueryServer.createCubeAndCursor(QueryServer.java:3761)
	at oracle.dss.dataSource.QueryServer._createCommonQuery(QueryServer.java:3730)
	at oracle.dss.dataSource.QueryServer._initCubeQuery(QueryServer.java:3610)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at oracle.dss.util.Operation.execute(Operation.java:72)
	at oracle.dss.dataSource.OperationQueue.update(OperationQueue.java:68)
	at oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
	at oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
	at oracle.dss.dataSource.QueryServer.queueOperation(QueryServer.java:6953)
	at oracle.dss.dataSource.QueryServer.initCubeQuery(QueryServer.java:3560)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at oracle.dss.util.Operation.execute(Operation.java:72)
	at oracle.dss.dataSource.QueryManagerServer.sendQueue(QueryManagerServer.java:1991)
	at oracle.dss.dataSource.common.OperationQueue.update(OperationQueue.java:207)
	at oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
	at oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
	at oracle.dss.dataSource.client.QueryClient._initCubeQuery(QueryClient.java:2385)
	at oracle.dss.dataSource.client.QueryClient.initCubeQuery(QueryClient.java:2368)
	at BICheckConfig.runDefaultMeasureQuery(BICheckConfig.java:479)
	at BICheckConfig.printFolder(BICheckConfig.java:405)
	at BICheckConfig.printFolder(BICheckConfig.java:464)
	at BICheckConfig.checkConnection(BICheckConfig.java:350)
	at BICheckConfig.main(BICheckConfig.java:1367)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.