org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar

Pentaho BI Platform Tracking | David Kincade | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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 | 8 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar
  2. 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 | 8 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar

    Root Cause Analysis

    1. 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()
    2. org.pentaho.reporting
      PreviewDialog$QueryThread.run
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265)
      2. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:107)
      3. org.pentaho.reporting.ui.datasources.jdbc.ui.PreviewDialog$QueryThread.run(PreviewDialog.java:195)
      3 frames