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

Error Processing Cascading Parameter if first parameter contains null values

    XMLWordPrintable

    Details

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

      Description

      Please see attached screenshot; in there you can see the Customer Number Parameter shows an error stating Error Processing Component (17522-36306)

      In order to reproduce this error please create a new report that uses SampleData (Hypersonic) with the following queries:

      Query Name: Territory
      SELECT DISTINCT
           "CUSTOMER_W_TER"."TERRITORY"
      FROM
           "CUSTOMER_W_TER"
      
      Query Name: Customer:
      SELECT DISTINCT
           "CUSTOMER_W_TER"."CUSTOMERNUMBER"
      FROM
           "CUSTOMER_W_TER"
      WHERE
           "CUSTOMER_W_TER"."TERRITORY" = ${territory}
      	 
      Query Name: CustomerDetails
      SELECT
           "CUSTOMER_W_TER"."CUSTOMERNUMBER",
           "CUSTOMER_W_TER"."CUSTOMERNAME",
           "CUSTOMER_W_TER"."TERRITORY"
      FROM
           "CUSTOMER_W_TER"
      WHERE
      "CUSTOMER_W_TER"."CUSTOMERNUMBER" = ${customernumber}
      
      Right click on query CustomerDetails and click on SELECT 
      Drag the resulting 3 fields to the Details section of the report
      
      Create the following two parameters:
      territory - based on the query Territory
      customernumber - based on the query Customer
      

      Please see attached screenshots for details on each parameter

      Preview the report in PRD and notice it works
      Publish the report to BA Server and notice the error as shown on the screenshot error.png

      Pentaho log captures this error:

      2015-04-15 18:19:36,961 ERROR [org.pentaho.reporting.engine.classic.core.states.datarow.ExpressionEventHelper] Failed to fire report-done event: java.lang.NullPointerException

        Attachments

        1. error shown in PUC.png
          error shown in PUC.png
          45 kB
        2. PRD-5439_CustomerParameter.PNG
          PRD-5439_CustomerParameter.PNG
          41 kB
        3. PRD-5439_TerritoryParameter.PNG
          PRD-5439_TerritoryParameter.PNG
          42 kB
        4. PRD-5439-ConsoleStackTrace.png
          PRD-5439-ConsoleStackTrace.png
          193 kB
        5. PRD-5439-ConsoleStackTrace-6.1.png
          PRD-5439-ConsoleStackTrace-6.1.png
          209 kB
        6. PRD-5439-ConsoleStackTrace-6.1-NewIssue.png
          PRD-5439-ConsoleStackTrace-6.1-NewIssue.png
          223 kB
        7. prd-5439-works.png
          prd-5439-works.png
          50 kB
        8. prd-5439-works-with-null.png
          prd-5439-works-with-null.png
          97 kB
        9. SampleReport.prpt
          5 kB

          Activity

            People

            Assignee:
            elopes Eduardo Lopes (Inactive)
            Reporter:
            clopez Carlos Lopez
            Votes:
            1 Vote for this issue
            Watchers:
            11 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: