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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web80

  • via Pentaho BI Platform Tracking by David Kincade, 1 year ago
    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
  • via Pentaho BI Platform Tracking by David Kincade, 1 year ago
    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
  • Failed at query: SELECT r."NO_RACA_COR_PESSOA", SUM(f."NU_PESSOAS") as "NU_PESSOAS" FROM "IPSTB061_AGG_TOTAIS_FAMILIAS_POR_RACA" f, "IPSTB027_DIM_RACA_COR_PESSOA" r, "IPSTB046_DIM_MUNICIPIOS" m WHERE r."CO_RACA_COR_PESSOA" = f
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.