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

Specification of transformation log table with ${KETTLE_TRANS_LOG_TABLE}, ${KETTLE_TRANS_LOG_DB} and jobs does not work as expected

    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

      Implemented by PDI-2378 the following issues arise and how to reproduce:

      1) Set the following variables in the kettle.properties file:

      KETTLE_JOB_LOG_DB=operations_db
      KETTLE_JOB_LOG_SCHEMA=
      KETTLE_JOB_LOG_TABLE=op_log_job

      KETTLE_TRANS_LOG_DB=operations_db
      KETTLE_TRANS_LOG_SCHEMA=
      KETTLE_TRANS_LOG_TABLE=op_log_trans

      2) Restart a fresh PDI, create a simple job, let it start, close, reopen, start etc.
      --> no log entries appear in the op_log_job table

      3) Restart a fresh PDI, create a simple transformation, let it start, you will get an exception and the transformation does not start:

      2010/09/01 16:47:42 - Spoon - Launching transformation [test_trans_log2]...
      2010/09/01 16:47:42 - Spoon - Started the transformation execution.
      2010/09/01 16:47:43 - test_trans_log2 - Dispatching started for transformation [test_trans_log2]
      2010/09/01 16:47:43 - Transformation metadata - Natural sort of steps executed in 0ms (2 time previous steps calculated)
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : test_trans_log2: preparing transformation execution failed
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : org.pentaho.di.core.exception.KettleTransException:
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : There was an error calculating the change data capture date range, it probably involved log table null.
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) :
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : No log table has been defined for the transformation.
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) :
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : org.pentaho.di.trans.Trans.calculateBatchIdAndDateRange(Trans.java:1560)
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : org.pentaho.di.trans.Trans.prepareExecution(Trans.java:596)
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3517)
      2010/09/01 16:47:43 - Spoon - ERROR (version 4.0.1-GA, build 13696 from 2010-07-30 11.43.59 by buildguy) : java.lang.Thread.run(Unknown Source)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jbleuel Jens Bleuel
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: