Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-4860

Error when downloading PRPT report as PDF, data fields missing.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 5.0.1 GA
    • Fix Version/s: None
    • Component/s: Report Generation
    • Labels:
      None
    • Environment:
      Pentaho BA 5.0.1 / Chrome, IE, Firefox
      PRD 5.0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows 7

      Description

      Pentaho Product: BA Server
      Version: 5.0
      Operating System: Windows 7
      Memory Available/Used: 16BG/8GB
      Hardware:
      Clustered/No: No
      Virtualized?: No
      Database for repository: MySQL
      Database for data: MySQL
      Browser type and version (If Applicable): Firefox, IE and Chrome
      Did you attach logs? Yes
      Did you attach sample demonstrating the problem? Yes, see screencast + screenshots

      Problem:
      The attached PRPT report (NoteActivityReport_v2.prpt) works well when viewed in PRD by switching between the Design and Preview perspectives. When the report is "Run" (green play button) in PDF it crashes, the PDF viewer displays an error pop up and then as a result the report itself is displayed missing one of the total fields.

      The same behavior happens when publishing the report to the BA server, the publishing process happens w/o an issue, downloading the report as an Excel file shows all the data and doesn't display any errors. When downloading the report as PDF the same issue happens, error in Adobe is displayed and the PDF report is rendered with a missing field.

      The attached sample report is attached to the Foodmart database using one simple query
      "select * from product limit 10"

      To reproduce the issue:

      • download the PRPT and run it from PRD 5.0 as PDF ( displays error )
      • "preview" the same PRPT and notice all the fields are there and no error is displayed.
      • Publish the report to the BA server and download it as PDF, same error happens
      • Download it as excel file, the fields are there. no error.
      • Run it in PRD as excel file, no error happens.

      Please see screencast for details
      https://pentaho.viewscreencasts.com/embed/77f072c1297548c189c0b29ca260a623

        Attachments

        1. catalina.2013-11-26.log
          7 kB
        2. error.JPG
          error.JPG
          60 kB
        3. field.JPG
          field.JPG
          71 kB
        4. metadata.log
          0.3 kB
        5. missing_field.JPG
          missing_field.JPG
          62 kB
        6. mondrian.log
          47 kB
        7. no_missing.JPG
          no_missing.JPG
          66 kB
        8. NoteActivityReport_v2.pdf
          3 kB
        9. NoteActivityReport_v2.prpt
          6 kB
        10. NoteActivityReport_v2.xls
          7 kB
        11. pentaho.log
          48 kB
        12. prpt.log
          0.7 kB

          Activity

            People

            • Assignee:
              project admin Triage
              Reporter:
              ldaza Lucio Daza (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: