Details

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

      We have a job that requires parameters to function correctly. For the most part, the parameters are working as expected. However, when we try to use these parameters in the 'Log' tab in the Job Properties dialog box, the parameters are not getting recognized the table name. However, when we use hard-coded values, the job works as expected. Please see the example below:

      Example: When we define a parameter for the log table and try to use it, the job gives errors.

      In the Job Properties > Parameters tab, the following parameter has been set.

      EDR_PDI_JOB_LOG_TABLE = md_pdi_job_log

      In the Job Properties > Log tab, the corresping 'Log Table' has been set with the parameter. Note: CTRL + SPACE was used to insert from available parameters.

      Log Table = ${EDR_PDI_JOB_LOG_TABLE}

      When we run the job with these settings, we get the following error. Please note that if the Log Table was hard-coded to md_pdi_job_log, we do not get any errors.

      ERROR:
      A serious error occurred during job execution:
      Unable to begin processing by logging start in logtable ${EDR_PDI_JOB_LOG_TABLE}
      Couldn't execute SQL: LOCK TABLE "${EDR_PDI_JOB_LOG_TABLE}" IN ACCESS EXCLUSIVE MODE
      ERROR: relation "${EDR_PDI_JOB_LOG_TABLE}" does not exist
      org.pentaho.di.core.exception.KettleJobException:
      Unable to begin processing by logging start in logtable ${EDR_PDI_JOB_LOG_TABLE}
      Couldn't execute SQL: LOCK TABLE "${EDR_PDI_JOB_LOG_TABLE}" IN ACCESS EXCLUSIVE MODE
      ERROR: relation "${EDR_PDI_JOB_LOG_TABLE}" does not exist
      org.pentaho.di.job.Job.beginProcessing(Job.java:869)
      org.pentaho.di.job.Job.execute(Job.java:335)
      org.pentaho.di.job.Job.run(Job.java:282)

      Please find the attachment of the screenshots.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sflatley Sean Flatley (Inactive)
                Reporter:
                vikramns Vikram NS
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: