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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web2

  • via Oracle Community by 366678, 1 year ago
    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
  • via Oracle Community by 398394, 1 year ago
    BIB-9509 Oracle OLAP haven't create the cursor¡£ DPR: TxsOqDefinitionManager::createCursorManager
  • Stack trace

    • 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(Query.java:2011) at oracle.dss.util.gui.layout.Layout.apply(Layout.java:667) at oracle.dss.util.gui.layout.CrosstabLayout.apply(CrosstabLayout.java:171) at oracle.dss.queryBuilder.QueryBuilder.applyChanges(QueryBuilder.java:1720) at oracle.dss.addins.wizard.presentation.PresentationWizardState.applyQuery(PresentationWizardState.java:105) at oracle.dss.addins.wizard.presentation.PresentationWizardDialog.wizardFinished(PresentationWizardDialog.java:293) at oracle.bali.ewt.wizard.BaseWizard.processWizardEvent(Unknown Source) at oracle.bali.ewt.wizard.BaseWizard.processEventImpl(Unknown Source) at oracle.bali.ewt.LWComponent.processEvent(Unknown Source) at oracle.bali.ewt.wizard.BaseWizard.doFinish(Unknown Source) at oracle.dss.datautil.gui.CustomWizard.doFinish(CustomWizard.java:395) at oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141) at java.awt.Dialog$1.run(Dialog.java:540) at java.awt.Dialog.show(Dialog.java:561) at java.awt.Component.show(Component.java:1133) at java.awt.Component.setVisible(Component.java:1088) at oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(AbstractBuilderDialog.java:295) at oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(PresentationWizardDialog.java:391) at oracle.bali.ewt.wizard.WizardDialog.runDialog(Unknown Source) at oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog(DefaultBuilderDialog.java:506) at oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog(AbstractBuilderDialog.java:275) at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51) at oracle.dss.addins.common.BIWizardImpl.invoke(BIWizardImpl.java:199) at oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeCommon(PresentationWizardAddin.java:54) at oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeFromMenu(PresentationWizardAddin.java:89) at oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(BIDesignerAddin.java:791) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.