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."

Oracle Community | 366678 | 1 decade ago
  1. 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."
  2. 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

    Root Cause Analysis

    1. 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."

      at oracle.dss.dataSource.common.Query.applyLayoutAccess()
    2. oracle.dss.dataSource
      Query.applyLayoutAccess
      1. oracle.dss.dataSource.common.Query.applyLayoutAccess(Query.java:2011)
      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:1720)
      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