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

Error in database lookup with "enable cache" and "load all data from table" when using variables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.2.0 GA, 3.2.1, 3.2.2, 3.2.3, 4.0.0 GA
    • Fix Version/s: 3.2.3, 4.0.0 GA
    • Component/s: None
    • Labels:
      None
    • 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

      The following error appears when loading all data from table in the database lookup operator while using variables:

      Unexpected error :
      org.pentaho.di.core.exception.KettleException:
      org.pentaho.di.core.exception.KettleDatabaseException:
      An error occurred executing SQL:
      SELECT A, A FROM "${TEST_SCHEMA2}".TEST2
      DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: ${TEST_SCHEMA2}.TEST2

        Attachments

          Activity

            People

            • Assignee:
              gdavid Golda Thomas
              Reporter:
              hymmen Holger Hymmen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: