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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Thomas Morgner,
  • 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)
    via by Thomas Morgner,
  • 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)
    via by Gretchen Moran,
    • 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)
    No Bugmate found.