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

Oracle Community | 438370 | 1 decade ago
  1. 0

    Common Schema Metadata Error? creating crosstabs

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

    errors!! help!

    Oracle Community | 1 decade ago | 438460
    oracle.dss.dataSource.common.OLAPException: 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 oracle.express.ExpressServerExceptionError class: Unknown Error Server error descriptions: DPR: Unknown error occurred, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2
  3. 0

    Transfer error

    Oracle Community | 1 decade ago | 455412
    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 OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER , Generic at TxsRdbStatement::initialize()
  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

    Oracle OLAP Catalog BI checkconfig diagnose warning

    Oracle Community | 1 decade ago | 420197
    oracle.dss.dataSource.common.OLAPException: BIB-9509 Oracle OLAP heeft cursor niet gemaakt. oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-12801: error signaled in parallel query server P007 ORA-00910: specified length too long for its datatype , Generic at TxsRdbSelectStatement:execute() oracle.express.ExpressServerExceptionError class: OLAPI Server error descriptions: DPR: Unable to create server cursor, Generic at TxsOqDefinitionManagerSince9202::crtCurMgrs2 OES: ORA-12801: error signaled in parallel query server P007 ORA-00910: specified length too long for its datatype , Generic

    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-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.QueryEvaluator.setUpCursors()
    2. oracle.dss.dataSource
      QueryServer._initCubeQuery
      1. oracle.dss.dataSource.QueryEvaluator.setUpCursors(QueryEvaluator.java:3645)
      2. oracle.dss.dataSource.QueryEvaluator._setUpCursorsForMainQuery(QueryEvaluator.java:2547)
      3. oracle.dss.dataSource.QueryEvaluator.getCursorForCube(QueryEvaluator.java:2579)
      4. oracle.dss.dataSource.QueryEvaluator.createCubeAndCursor(QueryEvaluator.java:940)
      5. oracle.dss.dataSource.MainQueryEvaluator.createCubeAndCursor(MainQueryEvaluator.java:144)
      6. oracle.dss.dataSource.QueryServer.createCubeAndCursor(QueryServer.java:3698)
      7. oracle.dss.dataSource.QueryServer._createCommonQuery(QueryServer.java:3681)
      8. oracle.dss.dataSource.QueryServer._initCubeQuery(QueryServer.java:3561)
      8 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    4. oracle.dss.util
      Operation.execute
      1. oracle.dss.util.Operation.execute(Operation.java:72)
      1 frame
    5. oracle.dss.dataSource
      QueryServer.initCubeQuery
      1. oracle.dss.dataSource.OperationQueue.update(OperationQueue.java:68)
      2. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
      3. oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
      4. oracle.dss.dataSource.QueryServer.queueOperation(QueryServer.java:6966)
      5. oracle.dss.dataSource.QueryServer.initCubeQuery(QueryServer.java:3511)
      5 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    7. oracle.dss.util
      Operation.execute
      1. oracle.dss.util.Operation.execute(Operation.java:72)
      1 frame
    8. oracle.dss.dataSource
      Query.applyLayoutAccess
      1. oracle.dss.dataSource.QueryManagerServer.sendQueue(QueryManagerServer.java:1991)
      2. oracle.dss.dataSource.common.OperationQueue.update(OperationQueue.java:207)
      3. oracle.dss.dataSource.common.BaseOperationQueue.setAutoUpdate(BaseOperationQueue.java:86)
      4. oracle.dss.dataSource.common.Query.updateAccessOperationQueue(Query.java:2024)
      5. oracle.dss.dataSource.common.Query.applyLayoutAccess(Query.java:2007)
      5 frames
    9. 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
    10. oracle.dss.queryBuilder
      QueryBuilder.applyChanges
      1. oracle.dss.queryBuilder.QueryBuilder.applyChanges(QueryBuilder.java:1720)
      1 frame
    11. 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
    12. 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
    13. oracle.dss.datautil
      CustomWizard.doFinish
      1. oracle.dss.datautil.gui.CustomWizard.doFinish(CustomWizard.java:395)
      1 frame
    14. oracle.bali.ewt
      BaseWizard$Action.actionPerformed
      1. oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
      1 frame
    15. 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
    16. 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
    17. oracle.bali.ewt
      WizardDialog.runDialog
      1. oracle.bali.ewt.wizard.WizardDialog.runDialog(Unknown Source)
      1 frame
    18. oracle.dss.datautil
      DefaultBuilderDialog.runDialog
      1. oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog(DefaultBuilderDialog.java:506)
      1 frame
    19. oracle.dss.addins
      AbstractBuilderDialog.runDialog
      1. oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog(AbstractBuilderDialog.java:275)
      1 frame
    20. oracle.ide.dialogs
      WizardLauncher.runDialog
      1. oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)
      1 frame
    21. oracle.dss.addins
      PresentationWizardAddin.invoke
      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.common.BIWizardImpl.handleNewObjectInvoke(BIWizardImpl.java:177)
      4. oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(PresentationWizardAddin.java:61)
      4 frames
    22. oracle.ide
      WizardManager$1.run
      1. oracle.ide.WizardManager.invokeWizard(WizardManager.java:484)
      2. oracle.ide.WizardManager$1.run(WizardManager.java:538)
      2 frames
    23. Java RT
      EventDispatchThread.run
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
      5. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
      6. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
      7. java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
      7 frames