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

PRPT with PDI KTR datasource where Table Input step takes parameters throws error in PRD

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 6.0.1 GA
    • Fix Version/s: 8.0.0 GA
    • Component/s: Data Source
    • Labels:
    • Environment:
      Datasource: Hypersonic - sampledata
    • Story Points:
      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.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      1) Create new PRD report with "table input with params.ktr" as datasource
      2) Right click on PDI source "Query 1" and click "Select Query"

      Follow above steps with "table input NO params.ktr" as datasource. PRD can use this KTR as a datasource, no error is thrown

      Show
      1) Create new PRD report with "table input with params.ktr" as datasource 2) Right click on PDI source "Query 1" and click "Select Query" Follow above steps with "table input NO params.ktr" as datasource. PRD can use this KTR as a datasource, no error is thrown

      Description

      If you have a transformation with a Table Input step which takes parameters (in my attached example, default values are set for both parameters in the query) and use this as a datasource in a PRPT report, PRD will throw an error when you try to use it.

        Attachments

        1. customer - prd.log
          2.56 MB
        2. ss of prd error.png
          ss of prd error.png
          106 kB
        3. table input.prpt
          5 kB
        4. table input NO params.ktr
          22 kB
        5. table input with params.ktr
          22 kB

          Activity

            People

            Assignee:
            spreztak Scott Preztak
            Reporter:
            gspikes Galen Spikes (Inactive)
            Votes:
            4 Vote for this issue
            Watchers:
            15 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: