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

Generation of log table DDL fails when using substitution variables specified in kettle.properties.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • 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

      This bug was found in the debugging of PDI-4544.

      Reproduction - this path uses a MySQL database. Ensure that a schema (dartabase) named operations_db is present.

      1. Ensure that the following variables are set in kettle.properties

      KETTLE_JOB_LOG_DB=operations_db
      KETTLE_JOB_LOG_TABLE=op_log_job
      KETTLE_JOB_LOG_SCHEMA=

      KETTLE_TRANS_LOG_DB=operations_db
      KETTLE_TRANS_LOG_TABLE=op_log_trans
      KETTLE_TRANS_LOG_SCHEMA=

      2. Open spoon and create a new job.

      3. Create a new database connection. The one used in the reproduction path was a MySQL database.

      Important: set the "Database name" in the "Database Connection" dialog to ${KETTLE_JOB_LOG_DB}

      4. Save and share the database connection.

      5. Click Edit and the Settings to open "Job properties" dialog and click on the "log" tab.

      6. Enter the following:

      "Log Connection" - enter the name of the connection you created in step 3 and 4.
      "Log schema" - DO NOT ENTER ANYTHING*
      "Log table" - "${KETTLE_JOB_LOG_TABLE}"

      7. Click on the "SQL" button.

      The generated DDL does not substitute "op_log_job" for the variable KETTLE_JOB_LOG_TABLE.

      This reproduction path can also be followed to duplicate the same error for transformation logging using the KETTLE_TRANS.. variables.

      • Specifying KETTLE_JOB_LOG_SCHEMA in the database connection will result in the table name in the DDL to be prepended by "null.". This bug will be filed under a separate case.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gdavid Golda Thomas
                Reporter:
                sflatley Sean Flatley (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: