3 Replies Latest reply: Oct 31, 2012 8:48 AM by user798043-Oracle RSS

    ORA-00904 when maintaining a dimension

    user798043-Oracle
      Hello,

      we just started using OLAP on a customer's machine. We created a dimension, configured it and then tried to maintain (load) it. During the process we get "ORA-00904" with the following stack:
      >>>>>>>>>>>>>>>>>>>>>>>>>>
      java.sql.SQLException: ORA-00904: : ungültiger Bezeichner

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
      at $Proxy1.executeQuery(Unknown Source)
      at oracle.olap.app.db.DatabaseUtils.ExecuteSQL(DatabaseUtils.java:405)
      at oracle.olap.awm.buildlog.UBuildTableModel.populateTableDataModel(UBuildTableModel.java:41)
      at oracle.olap.awm.buildlog.UBuildStatusPanel.populateTableDataModel(UBuildStatusPanel.java:704)
      at oracle.olap.awm.buildlog.UBuildStatusPanel.populateAllBuildModels(UBuildStatusPanel.java:649)
      at oracle.olap.awm.buildlog.UBuildStatusDialog.enableClose(UBuildStatusDialog.java:126)
      at oracle.olap.awm.wizard.awbuild.UBuildWizardHelper$2.finished(UBuildWizardHelper.java:513)
      at oracle.olap.awm.ui.SwingWorker$1.run(SwingWorker.java:103)
      at java.awt.event.InvocationEvent.dispatch(Unknown Source)
      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
      at java.awt.EventQueue.access$000(Unknown Source)
      at java.awt.EventQueue$1.run(Unknown Source)
      at java.awt.EventQueue$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.Dialog$1.run(Unknown Source)
      at java.awt.Dialog$3.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Unknown Source)
      at java.awt.Component.show(Unknown Source)
      at java.awt.Component.setVisible(Unknown Source)
      at java.awt.Window.setVisible(Unknown Source)
      at java.awt.Dialog.setVisible(Unknown Source)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(Unknown Source)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(Unknown Source)
      at oracle.olap.awm.util.MiscUtils.showError(MiscUtils.java:216)
      at oracle.olap.awm.buildlog.UBuildStatusPanel.populateTableDataModel(UBuildStatusPanel.java:729)
      at oracle.olap.awm.buildlog.UBuildStatusPanel.populateAllBuildModels(UBuildStatusPanel.java:649)
      at oracle.olap.awm.buildlog.UBuildStatusPanel.showBuildStatus(UBuildStatusPanel.java:964)
      at oracle.olap.awm.buildlog.UBuildStatusDialog.showBuildStatus(UBuildStatusDialog.java:100)
      at oracle.olap.awm.wizard.awbuild.UBuildWizardHelper.runBuild(UBuildWizardHelper.java:550)
      at oracle.olap.awm.navigator.node.olapi.UDimensionNode.actionPerformed(UDimensionNode.java:460)
      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      at javax.swing.AbstractButton.doClick(Unknown Source)
      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
      at java.awt.Component.processMouseEvent(Unknown Source)
      at javax.swing.JComponent.processMouseEvent(Unknown Source)
      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Window.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
      at java.awt.EventQueue.access$000(Unknown Source)
      at java.awt.EventQueue$1.run(Unknown Source)
      at java.awt.EventQueue$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
      at java.awt.EventQueue$2.run(Unknown Source)
      at java.awt.EventQueue$2.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)
      <<<<<<<<<<<<<<<<<<<<<<<<<<

      The error keeps popping up, until we log off and close AWM. However, the dimension was populated, as we checked it in AWm after logging back on. So apparently the process completes on the database side. Same happens when maintaining a cube?! Could it be just a GUI issue?

      Any help appreciated?