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

Job entry: Evaluate rows number in a table: PDI Server logs with error from Quartz even though the job finishes successfully.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release) , 4.4.1
    • Fix Version/s: 5.1.0 GA
    • Component/s: Job Entry
    • Labels:
      None
    • Story Points:
      1
    • PDI Sub-component:
    • 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.
    • Sprint Team:
      Pervach

      Description

      Scenario : Simple job which has to process the flow based on the condition specified in 'Evaluate rows number in a table'.
      If the condition fails then it has to create one file in a specified path.If condition is success then do nothing.
      Attached the sample job to this jira.

      Test Results :

      1) Configure "Evaluate rows number in a table" step to meet success condition : Schedule the job.
      Now PDI will execute dummy step as it meets success criteria in "Evaluate rows number in a table". See the attached slave_server_log_when_condotion_success.png
      and pentaho.log_when_condition_success.txt
      Note : No quartz errors are thrown

      2) Configure "Evaluate rows number in a table" step to meet failure condition : Schedule the job.
      Now PDI will execute create fil step as it meets failure criteria in "Evaluate rows number in a table".Now file will be created at specified location. See the attached slave_server_log_when_condotion_fail.png
      and pentaho.log_when_condition_fail.txt
      Note : Even though job finished successfully which can seen in slave server log,but quartz error is thrown in pentaho.log file.

      This happens only when the job is scheduled. You can not see error in DI server web page it shows in pentaho.log file.

      Attached log files,screenshots and job.

        Attachments

        1. CE PDI V 5_1 fix.log
          4 kB
        2. NPAC.kjb
          19 kB
        3. pentaho.log_when_condition_fails
          3 kB
        4. pentaho.log_when_condition_success
          2 kB
        5. slave_server_log_when_condition_fail.png
          slave_server_log_when_condition_fail.png
          112 kB
        6. slave_server_log_when_condotion_success.png
          slave_server_log_when_condotion_success.png
          117 kB
        7. tst.zip
          2 kB

          Issue Links

            Activity

              People

              Assignee:
              jdorlus John Dorlus (Inactive)
              Reporter:
              mounika mounika chintalapati (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: