org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC

Pentaho BI Platform Tracking | David Kincade | 7 years ago
  1. 0

    This appears to be related to the query timeout / preview cancel functionality that was added for the CITRUS release. Create a blank report and add a complex metadata query (or a query against a remote database that will take a few seconds to execute). Still in the metadata query dialog, try to preview the query and the following will appear in the log after a few seconds: ERROR 17-07 16:16:54,137 - UncaughtExcpetionsModel.addException org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:516) at org.pentaho.reporting.ui.datasources.pmd.PreviewDialog.showData(PreviewDialog.java:134) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor$PreviewAction.actionPerformed(PmdDataSourceEditor.java:300) 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.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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:1051) at java.awt.Dialog$3.run(Dialog.java:1103) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1101) at java.awt.Component.show(Component.java:1516) at java.awt.Component.setVisible(Component.java:1468) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:991) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor.performConfiguration(PmdDataSourceEditor.java:390) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourcePlugin.performEdit(PmdDataSourcePlugin.java:41) at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:60) 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.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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: Query execution was interrupted at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1360) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2369) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:451) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2076) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1451) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1787) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1439) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:255) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:516) at org.pentaho.reporting.ui.datasources.pmd.PreviewDialog.showData(PreviewDialog.java:134) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor$PreviewAction.actionPerformed(PmdDataSourceEditor.java:300) 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.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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:1051) at java.awt.Dialog$3.run(Dialog.java:1103) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1101) at java.awt.Component.show(Component.java:1516) at java.awt.Component.setVisible(Component.java:1468) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:991) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor.performConfiguration(PmdDataSourceEditor.java:390) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourcePlugin.performEdit(PmdDataSourcePlugin.java:41) at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:60) 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.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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)

    Pentaho BI Platform Tracking | 7 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC
  2. 0

    This appears to be related to the query timeout / preview cancel functionality that was added for the CITRUS release. Create a blank report and add a complex metadata query (or a query against a remote database that will take a few seconds to execute). Still in the metadata query dialog, try to preview the query and the following will appear in the log after a few seconds: ERROR 17-07 16:16:54,137 - UncaughtExcpetionsModel.addException org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:516) at org.pentaho.reporting.ui.datasources.pmd.PreviewDialog.showData(PreviewDialog.java:134) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor$PreviewAction.actionPerformed(PmdDataSourceEditor.java:300) 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.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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:1051) at java.awt.Dialog$3.run(Dialog.java:1103) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1101) at java.awt.Component.show(Component.java:1516) at java.awt.Component.setVisible(Component.java:1468) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:991) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor.performConfiguration(PmdDataSourceEditor.java:390) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourcePlugin.performEdit(PmdDataSourcePlugin.java:41) at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:60) 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.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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: Query execution was interrupted at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1360) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2369) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:451) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2076) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1451) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1787) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1439) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:255) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:516) at org.pentaho.reporting.ui.datasources.pmd.PreviewDialog.showData(PreviewDialog.java:134) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor$PreviewAction.actionPerformed(PmdDataSourceEditor.java:300) 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.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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:1051) at java.awt.Dialog$3.run(Dialog.java:1103) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1101) at java.awt.Component.show(Component.java:1516) at java.awt.Component.setVisible(Component.java:1468) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:991) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor.performConfiguration(PmdDataSourceEditor.java:390) at org.pentaho.reporting.ui.datasources.pmd.PmdDataSourcePlugin.performEdit(PmdDataSourcePlugin.java:41) at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:60) 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.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6216) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5981) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4583) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4413) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4413) 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)

    Pentaho BI Platform Tracking | 7 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC
  3. 0

    Starting with a blank report, I created a new JDBC connection and hand-typed a SQL query which was invalid. When I clicked the preview button, a dialog flashed on the screen and disappeared but received no other feedback. The log file contains the following information: WARN 17-07 15:24:07,235 - Query thread received exception [Failed at query: select foo from bar] WARN 17-07 15:24:07,280 - QueryPanel.actionPerformed org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:107) at org.pentaho.reporting.ui.datasources.jdbc.ui.PreviewDialog$QueryThread.run(PreviewDialog.java:195) ParentException: java.sql.SQLException: Table not found in statement [select foo from bar] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:155) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:107) at org.pentaho.reporting.ui.datasources.jdbc.ui.PreviewDialog$QueryThread.run(PreviewDialog.java:195)

    Pentaho BI Platform Tracking | 7 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Pentaho - Couldn't find SQLSERVER drivers to connect

    Stack Overflow | 3 years ago | Yann Braga
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM Client;
  6. 0

    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)

    Pentaho BI Platform Tracking | 6 years ago | Jem Matzan
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: ListColumns

    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. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException

      Failed at query: SELECT DISTINCT BT_JIRAISSUE_JIRAISSUE.ASSIGNEE AS COL0 ,BT_JIRAISSUE_JIRAISSUE.pkey AS COL1 ,BT_ISSUETYPE_ISSUETYPE.pname AS COL2 ,BT_PRIORITY_PRIORITY.pname AS COL3 FROM issuetype BT_ISSUETYPE_ISSUETYPE ,jiraissue BT_JIRAISSUE_JIRAISSUE ,priority BT_PRIORITY_PRIORITY WHERE ( BT_JIRAISSUE_JIRAISSUE.issuetype = BT_ISSUETYPE_ISSUETYPE.ID ) AND ( BT_PRIORITY_PRIORITY.ID = BT_JIRAISSUE_JIRAISSUE.PRIORITY ) ORDER BY COL0 DESC ,COL3 DESC ,COL1 DESC

      at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData()
    2. org.pentaho.reporting
      PmdDataSourceEditor$PreviewAction.actionPerformed
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265)
      2. org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:516)
      3. org.pentaho.reporting.ui.datasources.pmd.PreviewDialog.showData(PreviewDialog.java:134)
      4. org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor$PreviewAction.actionPerformed(PmdDataSourceEditor.java:300)
      4 frames
    3. Java RT
      Dialog.setVisible
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      6. java.awt.Component.processMouseEvent(Component.java:6216)
      7. javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
      8. java.awt.Component.processEvent(Component.java:5981)
      9. java.awt.Container.processEvent(Container.java:2041)
      10. java.awt.Component.dispatchEventImpl(Component.java:4583)
      11. java.awt.Container.dispatchEventImpl(Container.java:2099)
      12. java.awt.Component.dispatchEvent(Component.java:4413)
      13. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
      14. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
      15. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
      16. java.awt.Container.dispatchEventImpl(Container.java:2085)
      17. java.awt.Window.dispatchEventImpl(Window.java:2475)
      18. java.awt.Component.dispatchEvent(Component.java:4413)
      19. java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      20. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      21. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      22. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      23. java.awt.Dialog$1.run(Dialog.java:1051)
      24. java.awt.Dialog$3.run(Dialog.java:1103)
      25. java.security.AccessController.doPrivileged(Native Method)
      26. java.awt.Dialog.show(Dialog.java:1101)
      27. java.awt.Component.show(Component.java:1516)
      28. java.awt.Component.setVisible(Component.java:1468)
      29. java.awt.Window.setVisible(Window.java:841)
      30. java.awt.Dialog.setVisible(Dialog.java:991)
      30 frames
    4. org.pentaho.reporting
      AddDataFactoryAction.actionPerformed
      1. org.pentaho.reporting.ui.datasources.pmd.PmdDataSourceEditor.performConfiguration(PmdDataSourceEditor.java:390)
      2. org.pentaho.reporting.ui.datasources.pmd.PmdDataSourcePlugin.performEdit(PmdDataSourcePlugin.java:41)
      3. org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:60)
      3 frames
    5. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:357)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225)
      7. javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266)
      8. java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      9. java.awt.Component.processMouseEvent(Component.java:6216)
      10. javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
      11. java.awt.Component.processEvent(Component.java:5981)
      12. java.awt.Container.processEvent(Container.java:2041)
      13. java.awt.Component.dispatchEventImpl(Component.java:4583)
      14. java.awt.Container.dispatchEventImpl(Container.java:2099)
      15. java.awt.Component.dispatchEvent(Component.java:4413)
      16. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
      17. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
      18. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
      19. java.awt.Container.dispatchEventImpl(Container.java:2085)
      20. java.awt.Window.dispatchEventImpl(Window.java:2475)
      21. java.awt.Component.dispatchEvent(Component.java:4413)
      22. java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      23. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      24. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      25. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      26. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      27. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      28. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      28 frames