org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report

Pentaho BI Platform Tracking | Thomas Morgner | 6 years ago
  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 | 6 years ago | Thomas Morgner
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report
  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 | 6 years ago | Thomas Morgner
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report
  3. 0

    When previewing the attached report in HTML, Excel, Excel 2007 or CSV I get the error below, testing with 5.1 nightly 728. This does not happen in 5.0. org.pentaho.reporting.engine.classic.core.ReportProcessingException: Failed to process the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1765) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.UnsupportedOperationException: Inline-SubReports are not supported by this export type. at org.pentaho.reporting.engine.classic.core.modules.output.fast.FastExportOutputFunction.clearInlineSubreports(FastExportOutputFunction.java:163) at org.pentaho.reporting.engine.classic.core.states.process.InlineSubreportProcessor.processInline(InlineSubreportProcessor.java:64) at org.pentaho.reporting.engine.classic.core.states.process.ProcessDetailsHandler.advance(ProcessDetailsHandler.java:50) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.advance(ProcessState.java:1034) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:435) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.performStructuralPreprocessing(AbstractReportProcessor.java:621) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:509) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) ... 2 more

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Failed to process the report
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When previewing the attached report in HTML, Excel, Excel 2007 or CSV I get the error below, testing with 5.1 nightly 728. This does not happen in 5.0. org.pentaho.reporting.engine.classic.core.ReportProcessingException: Failed to process the report at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1765) at org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.UnsupportedOperationException: Inline-SubReports are not supported by this export type. at org.pentaho.reporting.engine.classic.core.modules.output.fast.FastExportOutputFunction.clearInlineSubreports(FastExportOutputFunction.java:163) at org.pentaho.reporting.engine.classic.core.states.process.InlineSubreportProcessor.processInline(InlineSubreportProcessor.java:64) at org.pentaho.reporting.engine.classic.core.states.process.ProcessDetailsHandler.advance(ProcessDetailsHandler.java:50) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.advance(ProcessState.java:1034) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processPrepareLevels(AbstractReportProcessor.java:435) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.performStructuralPreprocessing(AbstractReportProcessor.java:621) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:509) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) ... 2 more

    Pentaho BI Platform Tracking | 3 years ago | Matt Campbell
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Failed to process the report
  6. 0

    I get the following exception when I create a very simple report from the attached metadata model, after saving and reopening the file: 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:472) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:90) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:270) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:187) ParentException: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to open meta-data layer at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.open(PmdDataFactory.java:293) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.open(CompoundDataFactory.java:142) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.open(CachingDataFactory.java:113) at org.pentaho.reporting.engine.classic.core.parameters.DefaultParameterContext.open(DefaultParameterContext.java:69) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:172) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:387) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:90) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:270) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:187) ParentException: org.pentaho.reporting.libraries.resourceloader.UnrecognizedLoaderException: This bundle data does not point to readable content. at org.pentaho.reporting.libraries.docbundle.bundleloader.RepositoryResourceBundleData.<init>(RepositoryResourceBundleData.java:95) at org.pentaho.reporting.libraries.docbundle.bundleloader.RepositoryResourceBundleData.deriveData(RepositoryResourceBundleData.java:144) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.load(ResourceManager.java:284) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:388) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:353) at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.open(PmdDataFactory.java:241) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.open(CompoundDataFactory.java:142) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.open(CachingDataFactory.java:113) at org.pentaho.reporting.engine.classic.core.parameters.DefaultParameterContext.open(DefaultParameterContext.java:69) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:172) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:387) at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:90) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:270) at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:187)

    Pentaho BI Platform Tracking | 8 years ago | Will Gorman
    org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report

    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.ReportProcessingException

      Unable to initialize the report

      at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing()
    2. org.pentaho.reporting
      PreviewHtmlAction$ExportTask.run
      1. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:483)
      2. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1264)
      3. org.pentaho.reporting.designer.core.actions.report.preview.PreviewHtmlAction$ExportTask.run(PreviewHtmlAction.java:150)
      3 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame