Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: 4.0.0 GA
    • Component/s: None
    • Labels:
      None
    • Customer Case:
    • 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.
    • QA Validation Status:
      Not Yet Validated

      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.

        Issue Links

          Activity

          Hide
          Sean Flatley added a comment -

          Duplicate of PDi-4799 which is almost ready to be checked in.

          Show
          Sean Flatley added a comment - Duplicate of PDi-4799 which is almost ready to be checked in.
          Hide
          Jens Bleuel added a comment -

          Bulk close of resolved 4.1 cases.

          Show
          Jens Bleuel added a comment - Bulk close of resolved 4.1 cases.

            People

            • Assignee:
              Sean Flatley
              Reporter:
              Vikram NS
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: