org.jfree.report.ReportProcessingException

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.

  • The topten.report has the following path for the mondrian schema: <property name="mondrianCubeDefinitionFile">/Users/kcruzada/Reports/steelwheels.mondrian.xml</property> it should be just steelwheels.mondrian.xml. This prevents the report from being able to be previewed properly. The exception is: org.jfree.report.ReportProcessingException: Unable to initialize the report at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:466) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: org.jfree.report.ReportDataFactoryException: Mondrian Error:Internal error: Virtual file is not readable: /C:/bin/pentaho/report-designer/samples/Users/kcruzada/Reports/steelwheels.mondrian.xml at org.pentaho.reportdesigner.crm.report.datasetplugin.MondrianDataFactory.queryData(MondrianDataFactory.java:77) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:110) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:85) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:382) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: /C:/bin/pentaho/report-designer/samples/Users/kcruzada/Reports/steelwheels.mondrian.xml at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1076) at mondrian.olap.Util.newError(Util.java:1091) at mondrian.rolap.RolapSchema.load(RolapSchema.java:277) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:213) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:76) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:837) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:659) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:148) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:79) at mondrian.olap.DriverManager.getConnection(DriverManager.java:122) at mondrian.olap.DriverManager.getConnection(DriverManager.java:87) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at org.pentaho.reportdesigner.crm.report.datasetplugin.multidataset.MondrianTableModel.<init>(MondrianTableModel.java:89) at org.pentaho.reportdesigner.crm.report.datasetplugin.MondrianDataFactory.queryData(MondrianDataFactory.java:75) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:110) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:85) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:382) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120)
    via by Daniel Einspanjer,
  • The topten.report has the following path for the mondrian schema: <property name="mondrianCubeDefinitionFile">/Users/kcruzada/Reports/steelwheels.mondrian.xml</property> it should be just steelwheels.mondrian.xml. This prevents the report from being able to be previewed properly. The exception is: org.jfree.report.ReportProcessingException: Unable to initialize the report at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:466) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: org.jfree.report.ReportDataFactoryException: Mondrian Error:Internal error: Virtual file is not readable: /C:/bin/pentaho/report-designer/samples/Users/kcruzada/Reports/steelwheels.mondrian.xml at org.pentaho.reportdesigner.crm.report.datasetplugin.MondrianDataFactory.queryData(MondrianDataFactory.java:77) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:110) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:85) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:382) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: /C:/bin/pentaho/report-designer/samples/Users/kcruzada/Reports/steelwheels.mondrian.xml at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:752) at mondrian.olap.Util.newInternal(Util.java:1076) at mondrian.olap.Util.newError(Util.java:1091) at mondrian.rolap.RolapSchema.load(RolapSchema.java:277) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:213) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:76) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:837) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:659) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:148) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:79) at mondrian.olap.DriverManager.getConnection(DriverManager.java:122) at mondrian.olap.DriverManager.getConnection(DriverManager.java:87) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at org.pentaho.reportdesigner.crm.report.datasetplugin.multidataset.MondrianTableModel.<init>(MondrianTableModel.java:89) at org.pentaho.reportdesigner.crm.report.datasetplugin.MondrianDataFactory.queryData(MondrianDataFactory.java:75) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:110) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:85) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:382) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120)
    via by Daniel Einspanjer,
  • Open the attached report. It used the SampleData JNDI connection. The cube file is also attached as well. Try running the report, the following error occurs: org.jfree.report.ReportProcessingException: Unable to initialize the report at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:465) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: org.jfree.report.ReportDataFactoryException: Failed at query: select NON EMPTY {[Measures].[Sales]} ON COLUMNS, NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] at org.jfree.report.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:215) at org.jfree.report.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory$1.queryData(MultiDataFactory.java:59) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:108) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:84) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:381) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120) ParentException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON COLUMNS, NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Meas' at line 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403) at org.jfree.report.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:210) at org.jfree.report.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory$1.queryData(MultiDataFactory.java:59) at org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:108) at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247) at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89) at org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176) at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:84) at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:381) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120)
    via by Kurtis Cruzada,
    • org.jfree.report.ReportProcessingException: Unable to initialize the report at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:466) at org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237) at org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120)
    No Bugmate found.