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 TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute()

Oracle Community | 32653 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    BINamingException

    Oracle Community | 1 decade ago | 32653
    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 TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute()
  2. 0

    Transfer error

    Oracle Community | 1 decade ago | 455412
    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()

    Root Cause Analysis

    1. 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 TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManager::createCursorManager OES: ORA-00942: table or view does not exist , Generic at TxsRdbSelectStatement:execute()

      at oracle.dss.dataSource.QueryUtilities.setUpCursors()
    2. oracle.dss.dataSource
      QueryServer._initQuery
      1. oracle.dss.dataSource.QueryUtilities.setUpCursors(QueryUtilities.java:505)
      2. oracle.dss.dataSource.QueryServer._setUpCursorsForMainQuery(QueryServer.java:6996)
      3. oracle.dss.dataSource.QueryServer._getCursorForCube(QueryServer.java:4056)
      4. oracle.dss.dataSource.QueryServer._createCubeAndCursor(QueryServer.java:4211)
      5. oracle.dss.dataSource.QueryServer._createCommonQuery(QueryServer.java:3854)
      6. oracle.dss.dataSource.QueryServer._initQuery(QueryServer.java:3801)
      6 frames
    3. Java RT
      Method.invoke
      1. java.lang.reflect.Method.invoke(Native Method)
      1 frame
    4. oracle.dss.util
      Operation.execute
      1. oracle.dss.util.Operation.execute(Operation.java:69)
      1 frame
    5. oracle.dss.dataSource
      QueryServer.initQuery
      1. oracle.dss.dataSource.OperationQueue.update(OperationQueue.java:68)
      2. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
      3. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
      4. oracle.dss.dataSource.QueryServer.queueOperation(QueryServer.java:7033)
      5. oracle.dss.dataSource.QueryServer.initQuery(QueryServer.java:3763)
      5 frames
    6. Java RT
      Method.invoke
      1. java.lang.reflect.Method.invoke(Native Method)
      1 frame
    7. oracle.dss.util
      Operation.execute
      1. oracle.dss.util.Operation.execute(Operation.java:69)
      1 frame
    8. oracle.dss.dataSource
      QueryClient.initQuery
      1. oracle.dss.dataSource.QueryManagerServer.sendQueue(QueryManagerServer.java:1442)
      2. oracle.dss.dataSource.common.OperationQueue.update(OperationQueue.java:198)
      3. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
      4. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
      5. oracle.dss.dataSource.client.QueryClient.initQuery(QueryClient.java:1566)
      5 frames
    9. Unknown
      BICheckConfig.main
      1. BICheckConfig.runDefaultDimensionQuery(BICheckConfig.java:454)
      2. BICheckConfig.printFolder(BICheckConfig.java:387)
      3. BICheckConfig.checkConnection(BICheckConfig.java:310)
      4. BICheckConfig.main(BICheckConfig.java:1172)
      4 frames