This discussion is archived
1 Reply Latest reply: Jan 26, 2011 4:47 AM by DavidGreenfield RSS

BIB-9509 OLAPI error viewing cubes data

713519 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points