1 Reply Latest reply: Jan 26, 2011 6:47 AM by DavidGreenfield RSS

    BIB-9509 OLAPI error viewing cubes data

    713519
      Hi, I'm using 11.1.0.7 Oracle Server and AWM 11.1.0.7.0B. Last week I created a cube, mantained it and I could view all the data. Today when I try to view the cube data I get this error:

      An error has occurred on the server
      Error class: OLAPI
      Server error descriptions:
      DPR: Unable to create server cursor, Generic at TxsOqDefinitionManager::crtCurMgrs4
      OES: ORA-00600: internal error code, arguments: xscbTest, 18446744073709551615], [, ], [, ], [, ], [, ], [, []
      , Generic at TxsRdbSQLQuery::absolute()

      at oracle.dss.dataSource.QueryEvaluator.setUpCursors(QueryEvaluator.java:3979)
      at oracle.dss.dataSource.QueryEvaluator._setUpCursorsForMainQuery(QueryEvaluator.java:2822)
      at oracle.dss.dataSource.QueryEvaluator.getCursorForCube(QueryEvaluator.java:2854)
      at oracle.dss.dataSource.QueryEvaluator.createCubeAndCursor(QueryEvaluator.java:1234)
      at oracle.dss.dataSource.MainQueryEvaluator.createCubeAndCursor(MainQueryEvaluator.java:171)
      at oracle.dss.dataSource.QueryServer.createCubeAndCursor(QueryServer.java:3863)
      at oracle.dss.dataSource.QueryServer._createCommonQuery(QueryServer.java:3822)
      at oracle.dss.dataSource.QueryServer._initCubeQuery(QueryServer.java:3702)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      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:7079)
      at oracle.dss.dataSource.QueryServer.initCubeQuery(QueryServer.java:3652)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at oracle.dss.util.Operation.execute(Operation.java:72)
      at oracle.dss.dataSource.QueryManagerServer.sendQueue(QueryManagerServer.java:2001)
      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 oracle.olap.awm.dataobject.dialog.olapi.UBiBeanUtil.doQueryTop3(Unknown Source)
      at oracle.olap.awm.dataobject.dialog.olapi.UBiBeanUtil.showCrosstab(Unknown Source)
      at oracle.olap.awm.dataobject.dialog.olapi.UBiBeanUtil.showData(Unknown Source)
      at oracle.olap.awm.navigator.node.olapi.UCubeNode.actionPerformed(Unknown Source)
      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      at javax.swing.AbstractButton.doClick(Unknown Source)
      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
      at java.awt.Component.processMouseEvent(Unknown Source)
      at javax.swing.JComponent.processMouseEvent(Unknown Source)
      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Window.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)

      anyone can help me??
        • 1. Re: BIB-9509 OLAPI error viewing cubes data
          DavidGreenfield
          It is clearly a database bug. It could be related to

          Bug 7329946 - ORA-600 [XSCBTEST] WHEN TRYING TO VIEW CUBE DATA WITH AWM DATA VIEWER

          The AWM data viewer uses the BI Beans code, so it is probably the same thing. It is related to

          Bug 8719947 - CC CRASHES WHEN THERE IS NEGATIVE VALUES IN CCINCR TUPLES

          My advice is to raise a service request so that you can supply proper trace file information and can get a patch for your specific platform.

          For a faster response to OLAP server related problems you could post to the OLAP Forum

          OLAP