0 Replies Latest reply on Nov 17, 2008 9:32 PM by 544274

    Analytical Workspace maintanence

    544274
      I initially installed AWM 10.2.0.1 which worked fine. I then installed 10.2.0.3, but I keep getting a "sql command not properly ended" error message when executing the maintenance feature. Any ideas? The database is at 10.2.0.4

      Thanks Todd


      ava.sql.SQLException: ORA-00933: SQL command not properly ended


      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:671)

      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:597)

      at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:777)

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)

      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1678)

      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1644)

      at oracle.olap.awm.dataobject.dialog.olapcatalog.TableDialog.populateTableDataModel(TableDialog.java:164)

      at oracle.olap.awm.dataobject.dialog.olapcatalog.TableDialog.initialiseAndPopulate(TableDialog.java:68)

      at oracle.olap.awm.dataobject.dialog.olapcatalog.TableDialog.<init>(TableDialog.java:57)

      at oracle.olap.awm.wizard.awbuild.BuildWizardHelper.runBuild(BuildWizardHelper.java:252)

      at oracle.olap.awm.navigator.node.modeler.ModelerDimensionNode.actionPerformed(ModelerDimensionNode.java:335)

      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

      at javax.swing.AbstractButton$ForwardActionEvents.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$MouseInputHandler.mouseReleased(Unknown Source)

      at java.awt.Component.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.dispatchEvent(Unknown Source)

      at java.awt.EventDispatchThread.pumpOneEventForHierarchy(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)