Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-13914

Combination Lookup: Get Fields returns wrong Dimension Field name

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.4.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Story Points:
      0
    • PDI Sub-component:
    • 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

      When using the Combination Lookup/Update step, click the "Get Fields" button causes both the "Dimension field" and "Stream field" to be populated with the same values, even though there are not any fields in the target table with that name.

      This will cause issues for end-users, in that they'll get an error when they try to execute the transformation, and then have to manually update all of the field names to the appropriate values.

      2015/06/05 15:13:04 - Combination lookup/update.0 - ERROR (version 5.4.0.0-128, build 1 from 2015-06-03_13-41-59 by buildguy) : Because of an error, this step can't continue: 
      2015/06/05 15:13:04 - Combination lookup/update.0 - Error looking up row in database
      2015/06/05 15:13:04 - Combination lookup/update.0 - Unknown column 'Name' in 'where clause'
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            mtucker Matt Tucker
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: