oracle.dss.dataSource.common.OLAPException

BIB-9509 Oracle OLAP did not create cursor. Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Error occurred while validating object." Invalid Object "Mtm.42": "Error occurred while validating object." Invalid Object "Mtm.41": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Error occurred while validating object." Invalid Object "Mtm.40": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Error occurred while validating object." Invalid Object "Mtm.46": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Error occurred while validating object." Invalid Object "Mtm.44": "Error occurred while validating object." Invalid Object "Mtm.47": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Error occurred while validating object." Invalid Object "Mtm.43": "Error occurred while validating object." Invalid Object "Mtm.48": "Error occurred while validating object." Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Error occurred while validating object." Invalid Object "Mtm.42": "Error occurred while validating object." Invalid Object "Mtm.41": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Error occurred while validating object." Invalid Object "Mtm.40": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Error occurred while validating object." Invalid Object "Mtm.46": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Error occurred while validating object." Invalid Object "Mtm.44": "Error occurred while validating object." Invalid Object "Mtm.47": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Error occurred while validating object." Invalid Object "Mtm.43": "Error occurred while validating object." Invalid Object "Mtm.48": "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 web18

  • via Oracle Community by 438370, 1 year ago
    BIB-9509 Oracle OLAP did not create cursor. Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45
  • via Oracle Community by 415792, 8 months ago
    BIB-9509 Oracle OLAP did not create cursor. Invalid Metadata Objects: Invalid Object "Mtm.615": "Dimension "(%(1)s)" appears in multiple aggregation steps." Invalid Object "Mtm.633": "Dimension "(%(1)s)" appears in multiple aggregation steps
  • via Oracle Community by 438460, 8 months ago
    BIB-9509 Oracle OLAP did not create cursor. oracle.express.ExpressServerExceptionError class: Unknown Error Server error descriptions: DPR: Unknown error occurred, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2
  • Stack trace

    • oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP did not create cursor. Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Error occurred while validating object." Invalid Object "Mtm.42": "Error occurred while validating object." Invalid Object "Mtm.41": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Error occurred while validating object." Invalid Object "Mtm.40": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Error occurred while validating object." Invalid Object "Mtm.46": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Error occurred while validating object." Invalid Object "Mtm.44": "Error occurred while validating object." Invalid Object "Mtm.47": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Error occurred while validating object." Invalid Object "Mtm.43": "Error occurred while validating object." Invalid Object "Mtm.48": "Error occurred while validating object." Invalid Metadata Objects: Invalid Object "Mtm.49": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME.CALENDAR": "Error occurred while validating object." Invalid Object "Mtm.45": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWT_TIME": "Error occurred while validating object." Invalid Object "Mtm.42": "Error occurred while validating object." Invalid Object "Mtm.41": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS": "Error occurred while validating object." Invalid Object "Mtm.40": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS.PRODUCTS": "Error occurred while validating object." Invalid Object "Mtm.46": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS.PROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES.STANDARD": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPROMOTIONS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWCHANNELS.CHANNELS": "Error occurred while validating object." Invalid Object "Mtm.44": "Error occurred while validating object." Invalid Object "Mtm.47": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWPRODUCTS": "Error occurred while validating object." Invalid Object "D_CS_OLAP.SHAWGEOGRAPHIES": "Error occurred while validating object." Invalid Object "Mtm.43": "Error occurred while validating object." Invalid Object "Mtm.48": "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.common.BIWizardImpl.handleNewObjectInvoke(BIWizardImpl.java:177) at oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(PresentationWizardAddin.java:61) at oracle.ide.WizardManager.invokeWizard(WizardManager.java:484) at oracle.ide.WizardManager$1.run(WizardManager.java:538) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178) at java.awt.EventQueue.dispatchEvent(EventQueue.java:454) 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.