oracle.dss.dataSource.common.OLAPException: BIB-9009 Oracle OLAP could not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks OES: ORA-00904: "T5"."STATUS": invalid identifier , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery

Oracle Community | 851773 | 5 years ago
  1. 0

    Error build Graph and Crosstab

    Oracle Community | 5 years ago | 851773
    oracle.dss.dataSource.common.OLAPException: BIB-9009 Oracle OLAP could not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks OES: ORA-00904: "T5"."STATUS": invalid identifier , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery
  2. 0

    Common Schema Metadata Error? creating crosstabs

    Oracle Community | 1 decade ago | 438370
    oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP hat keinen Cursor erstellt. Invalid Metadata Objects: Invalid Object "Mtm.49": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.45": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.42": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.41": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.40": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.46": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.44": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.47": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.43": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.48": "Fehler beim Validieren von Objekt." Invalid Metadata Objects: Invalid Object "Mtm.49": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.45": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.42": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.41": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.40": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.46": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.44": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.47": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Fehler beim Validieren von Objekt." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.43": "Fehler beim Validieren von Objekt." Invalid Object "Mtm.48": "Fehler beim Validieren von Objekt."
  3. 0

    Cube Viewer Error BIB-9509

    Oracle Community | 1 decade ago | 431569
    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 SEL: XML Parser Errors: Error returned by xsOqXmlParserExecute. , Generic at XML Parser oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 SEL: XML Parser Errors: Error returned by xsOqXmlParserExecute. , Generic at XML Parser
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP did not cr

    Oracle Community | 10 years ago | 525304
    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::crtCurMgrs4 OES: ORA-00904: "AW44"."AW44_ATTRIBUTE_202": invalid identifier , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs4 OES: ORA-00904: "AW44"."AW44_ATTRIBUTE_202": invalid identifier , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery
  6. 0

    InAnalytic Worksapce manager getting error oracle olap:cannot create cursor

    Oracle Community | 9 years ago | 598490
    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::crtCurMgrs4 OES: ORA-06552: PL/SQL: Statement ignored ORA-06553: PLS-222: no function with name 'OLAP_TABLE' exists in this scope , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs4 OES: ORA-06552: PL/SQL: Statement ignored ORA-06553: PLS-222: no function with name 'OLAP_TABLE' exists in this scope , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.dss.dataSource.common.OLAPException

      BIB-9009 Oracle OLAP could not create cursor. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to execute the query, Generic at TxsOqCursorManager::fetchInitialBlocks OES: ORA-00904: "T5"."STATUS": invalid identifier , Generic at TxsRdbRandomAccessQuery::TxsRdbRandomAccessQuery

      at oracle.dss.dataSource.common.Query.applyLayoutAccess()
    2. oracle.dss.dataSource
      Query.applyLayoutAccess
      1. oracle.dss.dataSource.common.Query.applyLayoutAccess(Query.java:2069)
      1 frame
    3. oracle.dss.util
      CrosstabLayout.apply
      1. oracle.dss.util.gui.layout.Layout.apply(Layout.java:667)
      2. oracle.dss.util.gui.layout.CrosstabLayout.apply(CrosstabLayout.java:171)
      2 frames
    4. oracle.dss.queryBuilder
      QueryBuilder.applyChanges
      1. oracle.dss.queryBuilder.QueryBuilder.applyChanges(QueryBuilder.java:1721)
      1 frame
    5. oracle.dss.addins
      PresentationWizardDialog.wizardFinished
      1. oracle.dss.addins.wizard.presentation.PresentationWizardState.applyQuery(PresentationWizardState.java:105)
      2. oracle.dss.addins.wizard.presentation.PresentationWizardDialog.wizardFinished(PresentationWizardDialog.java:293)
      2 frames
    6. oracle.bali.ewt
      BaseWizard.doFinish
      1. oracle.bali.ewt.wizard.BaseWizard.processWizardEvent(Unknown Source)
      2. oracle.bali.ewt.wizard.BaseWizard.processEventImpl(Unknown Source)
      3. oracle.bali.ewt.LWComponent.processEvent(Unknown Source)
      4. oracle.bali.ewt.wizard.BaseWizard.doFinish(Unknown Source)
      4 frames
    7. oracle.dss.datautil
      CustomWizard.doFinish
      1. oracle.dss.datautil.gui.CustomWizard.doFinish(CustomWizard.java:395)
      1 frame
    8. oracle.bali.ewt
      BaseWizard$Action.actionPerformed
      1. oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
      1 frame
    9. Java RT
      Component.setVisible
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
      6. java.awt.Component.processMouseEvent(Component.java:5100)
      7. java.awt.Component.processEvent(Component.java:4897)
      8. java.awt.Container.processEvent(Container.java:1569)
      9. java.awt.Component.dispatchEventImpl(Component.java:3615)
      10. java.awt.Container.dispatchEventImpl(Container.java:1627)
      11. java.awt.Component.dispatchEvent(Component.java:3477)
      12. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
      13. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
      14. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
      15. java.awt.Container.dispatchEventImpl(Container.java:1613)
      16. java.awt.Window.dispatchEventImpl(Window.java:1606)
      17. java.awt.Component.dispatchEvent(Component.java:3477)
      18. java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
      19. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
      20. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
      21. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
      22. java.awt.Dialog$1.run(Dialog.java:540)
      23. java.awt.Dialog.show(Dialog.java:561)
      24. java.awt.Component.show(Component.java:1133)
      25. java.awt.Component.setVisible(Component.java:1088)
      25 frames
    10. oracle.dss.addins
      PresentationWizardDialog.setVisible
      1. oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(AbstractBuilderDialog.java:295)
      2. oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(PresentationWizardDialog.java:391)
      2 frames
    11. oracle.bali.ewt
      WizardDialog.runDialog
      1. oracle.bali.ewt.wizard.WizardDialog.runDialog(Unknown Source)
      1 frame
    12. oracle.dss.datautil
      DefaultBuilderDialog.runDialog
      1. oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog(DefaultBuilderDialog.java:506)
      1 frame
    13. oracle.dss.addins
      AbstractBuilderDialog.runDialog
      1. oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog(AbstractBuilderDialog.java:275)
      1 frame
    14. oracle.ide.dialogs
      WizardLauncher.runDialog
      1. oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)
      1 frame
    15. oracle.dss.addins
      BIDesignerAddin.actionPerformed
      1. oracle.dss.addins.common.BIWizardImpl.invoke(BIWizardImpl.java:199)
      2. oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeCommon(PresentationWizardAddin.java:54)
      3. oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeFromMenu(PresentationWizardAddin.java:89)
      4. oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(BIDesignerAddin.java:791)
      4 frames
    16. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:289)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
      7. javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
      8. java.awt.Component.processMouseEvent(Component.java:5100)
      9. java.awt.Component.processEvent(Component.java:4897)
      10. java.awt.Container.processEvent(Container.java:1569)
      11. java.awt.Component.dispatchEventImpl(Component.java:3615)
      12. java.awt.Container.dispatchEventImpl(Container.java:1627)
      13. java.awt.Component.dispatchEvent(Component.java:3477)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
      17. java.awt.Container.dispatchEventImpl(Container.java:1613)
      18. java.awt.Window.dispatchEventImpl(Window.java:1606)
      19. java.awt.Component.dispatchEvent(Component.java:3477)
      20. java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
      21. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
      22. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
      23. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
      25. java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
      25 frames