Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-2836

OutOfBounds Exception when deleting a data source in the Add Parameter dialogue

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.6.1 GA [3.6.0 GA (Platform Release)]
    • Labels:
      None
    • Environment:
      PRD 3.6.1-GA through the graphical BI Suite installer, Sun JRE 1.6.0, Ubuntu 10.4 x86
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Ubuntu 8.x

      Description

      Open the JDBC Custom sample report in the Advanced folder. Select the Data tab, then double-click the Param1 parameter. Click the Table data source folder, then click the red X to delete it. Click Yes to confirm. The following errors appear:

      org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: ListColumns
      at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:236)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$QuerySelectionHandler.contentsChanged(ParameterDialog.java:584)
      at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100)
      at org.pentaho.reporting.designer.core.editor.parameters.StaticTextComboBoxModel.setValues(StaticTextComboBoxModel.java:46)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.valueChanged(ParameterDialog.java:404)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.treeStructureChanged(ParameterDialog.java:386)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.Component.processMouseEvent(Component.java:6263)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      at java.awt.Dialog$1.run(Dialog.java:1046)
      at java.awt.Dialog$3.run(Dialog.java:1098)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Dialog.java:1096)
      at java.awt.Component.show(Component.java:1563)
      at java.awt.Component.setVisible(Component.java:1515)
      at java.awt.Window.setVisible(Window.java:842)
      at java.awt.Dialog.setVisible(Dialog.java:986)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009)
      at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267)
      at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130)
      at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
      at java.awt.Component.processMouseEvent(Component.java:6266)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      ParentException:
      java.sql.SQLException: Statement does not generate a result set
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.checkIsRowCount(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
      at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:376)
      at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:232)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$QuerySelectionHandler.contentsChanged(ParameterDialog.java:584)
      at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100)
      at org.pentaho.reporting.designer.core.editor.parameters.StaticTextComboBoxModel.setValues(StaticTextComboBoxModel.java:46)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.valueChanged(ParameterDialog.java:404)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$DataSetQueryUpdateHandler.treeStructureChanged(ParameterDialog.java:386)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.Component.processMouseEvent(Component.java:6263)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      at java.awt.Dialog$1.run(Dialog.java:1046)
      at java.awt.Dialog$3.run(Dialog.java:1098)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Dialog.java:1096)
      at java.awt.Component.show(Component.java:1563)
      at java.awt.Component.setVisible(Component.java:1515)
      at java.awt.Window.setVisible(Window.java:842)
      at java.awt.Dialog.setVisible(Dialog.java:986)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009)
      at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267)
      at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130)
      at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
      at java.awt.Component.processMouseEvent(Component.java:6266)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

      And:

      java.lang.IndexOutOfBoundsException
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeCellRenderer.getTreeCellRendererComponent(DataFactoryTreeCellRenderer.java:69)
      at javax.swing.plaf.basic.BasicTreeUI$NodeDimensionsHandler.getNodeDimensions(BasicTreeUI.java:2712)
      at javax.swing.tree.AbstractLayoutCache.getNodeDimensions(AbstractLayoutCache.java:475)
      at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.updatePreferredSize(VariableHeightLayoutCache.java:1342)
      at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(VariableHeightLayoutCache.java:1469)
      at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(VariableHeightLayoutCache.java:1270)
      at javax.swing.tree.VariableHeightLayoutCache.rebuild(VariableHeightLayoutCache.java:725)
      at javax.swing.tree.VariableHeightLayoutCache.treeStructureChanged(VariableHeightLayoutCache.java:626)
      at javax.swing.plaf.basic.BasicTreeUI$Handler.treeStructureChanged(BasicTreeUI.java:3824)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:221)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.fireTreeDataChanged(DataFactoryTreeModel.java:211)
      at org.pentaho.reporting.designer.core.editor.parameters.DataFactoryTreeModel.remove(DataFactoryTreeModel.java:269)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog$RemoveDataSourceAction.actionPerformed(ParameterDialog.java:480)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      at java.awt.Component.processMouseEvent(Component.java:6263)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      at java.awt.Dialog$1.run(Dialog.java:1046)
      at java.awt.Dialog$3.run(Dialog.java:1098)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Dialog.java:1096)
      at java.awt.Component.show(Component.java:1563)
      at java.awt.Component.setVisible(Component.java:1515)
      at java.awt.Window.setVisible(Window.java:842)
      at java.awt.Dialog.setVisible(Dialog.java:986)
      at org.pentaho.reporting.designer.core.editor.parameters.ParameterDialog.performEditParameter(ParameterDialog.java:2009)
      at org.pentaho.reporting.designer.core.actions.report.EditParametersAction.performEditMasterReportParameters(EditParametersAction.java:267)
      at org.pentaho.reporting.designer.core.editor.structuretree.StructureTreePanel$ReportTreeContextMenuHandler.mouseClicked(StructureTreePanel.java:130)
      at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
      at java.awt.Component.processMouseEvent(Component.java:6266)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6028)
      at java.awt.Container.processEvent(Container.java:2041)
      at java.awt.Component.dispatchEventImpl(Component.java:4630)
      at java.awt.Container.dispatchEventImpl(Container.java:2099)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4247)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      at java.awt.Container.dispatchEventImpl(Container.java:2085)
      at java.awt.Window.dispatchEventImpl(Window.java:2478)
      at java.awt.Component.dispatchEvent(Component.java:4460)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

        Attachments

          Activity

            People

            • Assignee:
              kcruzada Kurtis Cruzada
              Reporter:
              jmatzan Jem Matzan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: