org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query

Pentaho BI Platform Tracking | Thomas Morgner | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    See attached report to case PRD-2654. I've tried setting the param to numerous different data types with no success. Generates the following exception: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:483) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:491) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to generate SQL. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:296) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: java.lang.ClassCastException: java.util.Date at org.pentaho.pms.mql.dialect.DefaultSQLDialect$14.generateFunctionSQL(DefaultSQLDialect.java:286) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:569) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:542) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:673) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateFromAndWhere(SqlGenerator.java:214) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:437) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:292) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 7 years ago | Thomas Morgner
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query
  2. 0

    See attached report to case PRD-2654. I've tried setting the param to numerous different data types with no success. Generates the following exception: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:483) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:491) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to generate SQL. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:296) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: java.lang.ClassCastException: java.util.Date at org.pentaho.pms.mql.dialect.DefaultSQLDialect$14.generateFunctionSQL(DefaultSQLDialect.java:286) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:569) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:542) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:673) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateFromAndWhere(SqlGenerator.java:214) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:437) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:292) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 7 years ago | Thomas Morgner
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query
  3. 0

    See attached report. I've tried setting the param to numerous different data types with no success. Generates the following exception: org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:483) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:491) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to generate SQL. at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:296) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595) ParentException: java.lang.ClassCastException: java.util.Date at org.pentaho.pms.mql.dialect.DefaultSQLDialect$14.generateFunctionSQL(DefaultSQLDialect.java:286) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:569) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:542) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.generateSQL(SqlOpenFormula.java:673) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateFromAndWhere(SqlGenerator.java:214) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:437) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:354) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.generateSQL(PmdDataFactory.java:292) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:483) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:595)

    Pentaho BI Platform Tracking | 7 years ago | Gretchen Moran
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to perform query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException

      Failed to perform query

      at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData()
    2. org.pentaho.reporting
      PreviewHtmlAction$ExportTask.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:491)
      2. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)
      3. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)
      4. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)
      5. org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
      6. org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
      7. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:186)
      8. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279)
      9. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:390)
      10. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264)
      11. org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150)
      11 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame