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

Pentaho BI Platform Tracking | Daniel Einspanjer | 9 years ago
  1. 0

    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)

    Pentaho BI Platform Tracking | 9 years ago | Daniel Einspanjer
    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
  2. 0

    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)

    Pentaho BI Platform Tracking | 9 years ago | Daniel Einspanjer
    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
  3. 0

    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)

    Pentaho BI Platform Tracking | 9 years ago | Kurtis Cruzada
    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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. org.pentaho.reportdesigner
      MultiDataFactory.queryData
      1. org.pentaho.reportdesigner.crm.report.datasetplugin.MondrianDataFactory.queryData(MondrianDataFactory.java:77)
      2. org.pentaho.reportdesigner.crm.report.datasetplugin.MultiDataFactory.queryData(MultiDataFactory.java:110)
      2 frames
    3. org.jfree.report
      PrintReportProcessor.getPageDrawable
      1. org.jfree.report.states.CachingDataFactory.queryData(CachingDataFactory.java:247)
      2. org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:89)
      3. org.jfree.report.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:176)
      4. org.jfree.report.states.process.ProcessState.<init>(ProcessState.java:85)
      5. org.jfree.report.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:382)
      6. org.jfree.report.modules.output.pageable.graphics.PrintReportProcessor.getPageDrawable(PrintReportProcessor.java:237)
      6 frames
    4. org.pentaho.reportdesigner
      ReportPane$3.run
      1. org.pentaho.reportdesigner.crm.report.preview.ReportPane$3.run(ReportPane.java:120)
      1 frame