oracle.dss.dataSource.common.QueryRuntimeException: BIB-9509 Oracle OLAP haven't create the cursor¡£ DPR: TxsOqDefinitionManager::createCursorManager

Oracle Community | 398394 | 1 decade ago
  1. 0

    A problem about BI Beans 905

    Oracle Community | 1 decade ago | 398394
    oracle.dss.dataSource.common.QueryRuntimeException: BIB-9509 Oracle OLAP haven't create the cursor¡£ DPR: TxsOqDefinitionManager::createCursorManager
  2. 0

    How to repaire OLAP catalog?

    Oracle Community | 1 decade ago | 366678
    oracle.dss.dataSource.common.QueryRuntimeException: BIB-9509 Oracle OLAP Unable to create cursor。 Invalid Metadata Objects: Invalid Object "Mtm.960": "Error occurred while validating object." Invalid Object "D_NEW_AW.SPECIALITY_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.959": "Error occurred while validating object." Invalid Object "Mtm.958": "Error occurred while validating object." Invalid Object "Mtm.965": "Error occurred while validating object." Invalid Object "D_NEW_AW.SPECIALITY_DIM": "Error occurred while validating object." Invalid Object "Mtm.957": "Error occurred while validating object." Invalid Object "Mtm.968": "Error occurred while validating object." Invalid Object "D_NEW_AW.PROD_ASSO_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.962": "Error occurred while validating object." Invalid Object "D_NEW_AW.REGION_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.956": "Error occurred while validating object." Invalid Object "D_NEW_AW.TBH_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.967": "Error occurred while validating object." Invalid Object "D_NEW_AW.POS_STATUS_DIM": "Error occurred while validating object." Invalid Object "D_NEW_AW.INDUSTRY_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.963": "Error occurred while validating object." Invalid Object "D_NEW_AW.PROD_ASSO_DIM": "Error occurred while validating object." Invalid Object "Mtm.964": "Error occurred while validating object." Invalid Object "D_NEW_AW.TBH_DIM": "Error occurred while validating object." Invalid Object "Mtm.953": "Error occurred while validating object." Invalid Object "D_NEW_AW.TEAM_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.969": "Error occurred while validating object." Invalid Object "Mtm.966": "Error occurred while validating object." Invalid Object "Mtm.955": "Error occurred while validating object." Invalid Object "D_NEW_AW.LEVEL_DIM": "Error occurred while validating object." Invalid Object "D_NEW_AW.TEAM_DIM": "Error occurred while validating object." Invalid Object "D_NEW_AW.POS_STATUS_DIM.STD_H": "Error occurred while validating object." Invalid Object "Mtm.954": "Error occurred while validating object." Invalid Object "Mtm.961": "Error occurred while validating object." Invalid Object "D_NEW_AW.EMP_STATUS_DIM.STD_H": "Error occurred while validating object." Invalid Object "D_NEW_AW.EMP_STATUS_DIM": "Error occurred while validating object." Invalid Object "D_NEW_AW.REGION_DIM": "Error occurred while validating object." Invalid Object "D_NEW_AW.INDUSTRY_DIM": "Error occurred while validating object." Invalid Object "Mtm.970": "Error occurred while validating object." Invalid Object "D_NEW_AW.LEVEL_DIM.STD_H": "Error occurred while validating object."

    Root Cause Analysis

    1. oracle.dss.dataSource.common.QueryRuntimeException

      BIB-9509 Oracle OLAP haven't create the cursor¡£ DPR: TxsOqDefinitionManager::createCursorManager

      at oracle.dss.dataSource.common.Query.applyLayoutAccess()
    2. oracle.dss.dataSource
      Query.applyLayoutAccess
      1. oracle.dss.dataSource.common.Query.applyLayoutAccess(Query.java:1660)
      1 frame
    3. oracle.dss.util
      CrosstabLayout.apply
      1. oracle.dss.util.gui.layout.Layout.apply(Layout.java:683)
      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:1592)
      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:289)
      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:393)
      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)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:414)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
      6. java.awt.Component.processMouseEvent(Component.java:5134)
      7. java.awt.Component.processEvent(Component.java:4931)
      8. java.awt.Container.processEvent(Container.java:1566)
      9. java.awt.Component.dispatchEventImpl(Component.java:3639)
      10. java.awt.Container.dispatchEventImpl(Container.java:1623)
      11. java.awt.Component.dispatchEvent(Component.java)
      12. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java)
      13. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
      14. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
      15. java.awt.Container.dispatchEventImpl(Container.java:1609)
      16. java.awt.Window.dispatchEventImpl(Window.java)
      17. java.awt.Component.dispatchEvent(Component.java)
      18. java.awt.EventQueue.dispatchEvent(EventQueue.java:452)
      19. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
      20. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
      21. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
      22. java.awt.Dialog.show(Dialog.java:538)
      23. java.awt.Component.show(Component.java:1134)
      24. java.awt.Component.setVisible(Component.java:1089)
      24 frames
    10. oracle.dss.addins
      PresentationWizardDialog.setVisible
      1. oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(AbstractBuilderDialog.java:292)
      2. oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(PresentationWizardDialog.java:387)
      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:272)
      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:147)
      2. oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(PresentationWizardAddin.java:54)
      3. oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeFromMenu(PresentationWizardAddin.java:83)
      4. oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(BIDesignerAddin.java:592)
      4 frames
    16. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:414)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java)
      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:5134)
      9. java.awt.Component.processEvent(Component.java:4931)
      10. java.awt.Container.processEvent(Container.java:1566)
      11. java.awt.Component.dispatchEventImpl(Component.java:3639)
      12. java.awt.Container.dispatchEventImpl(Container.java:1623)
      13. java.awt.Component.dispatchEvent(Component.java)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
      17. java.awt.Container.dispatchEventImpl(Container.java:1609)
      18. java.awt.Window.dispatchEventImpl(Window.java)
      19. java.awt.Component.dispatchEvent(Component.java)
      20. java.awt.EventQueue.dispatchEvent(EventQueue.java:452)
      21. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
      22. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
      23. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
      25. java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
      25 frames