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

Send Mail Job Entry Fails on Batch File Execution of Kitchen

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.0.0 GA, 4.0.1
    • Fix Version/s: 4.1.2
    • Component/s: Job Entry, Kitchen
    • 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.
    • Operating System/s:
      Windows XP

      Description

      I'm using a job to do backup of my project repository, and send me the backup file by email.

      When i execute the job via kettle GUI, i got no erros, but if i execute the job via Kitchen.bat, i got one error on the 'Mail' job entry, but that is just when i use secure authentication with SSL.
      But if i try the TLS encryption in the kettle GUI, kettle stops on the 'Mail' entry, and kettle stops running.

      So, When I run with SSL, with Kitchen.bat, i got this error:

      ..........INFO 06-07 12:55:17,931 - Send Email - Added file '///C:/Teste/ETL/PDI

      • Kettle/Kettle - Repositorios/Backup/Project/Kettle4.0.0-Project_B
        akup_2010-07-06.xml' to the mail message.
        ERROR 06-07 12:55:18,478 - Send Email - Problem while sending message: javax.mai
        l.MessagingException: Exception reading response;
        nested exception is:
        javax.net.ssl.SSLKeyException: RSA premaster secret error
        INFO 06-07 12:55:18,478 - MakeBackup-Project - Finished job entry [Send E
        mail] (result=[false])
        INFO 06-07 12:55:18,478 - MakeBackup-Project - Finished job entry [Export
        Repository - Kettle4.0.0 - Project - Desenvolvimento] (result=[false])
        INFO 06-07 12:55:18,478 - MakeBackup-Project- Job execution finished
        INFO 06-07 12:55:18,494 - Kitchen - Kitchen
        ERROR 06-07 12:55:18,494 - Kitchen - Kitchen
        INFO 06-07 12:55:18,494 - Kitchen - Kitchen
        INFO 06-07 12:55:18,494 - Kitchen - Kitchen
      1. MakeBackup-Project.bat.txt
        0.0 kB
        Eduardo Freitas de Melo
      2. MakeBackup-Project.kjb
        56 kB
        Eduardo Freitas de Melo
      3. validate.kjb
        59 kB
        Sean Flatley

        Issue Links

          Activity

          Hide
          jmelo Eduardo Freitas de Melo added a comment -

          I'm attaching the job (MakeBackup-Project.kjb) and the .bat file (MakeBackup-Project.bat.txt) for who want to execute.

          Obs: I'm using the gmail smtp server, with the port 465, and i omitted user and password to post the .ktr here

          Show
          jmelo Eduardo Freitas de Melo added a comment - I'm attaching the job (MakeBackup-Project.kjb) and the .bat file (MakeBackup-Project.bat.txt) for who want to execute. Obs: I'm using the gmail smtp server, with the port 465, and i omitted user and password to post the .ktr here
          Hide
          Former Triage User Old Triage User (Inactive) added a comment -

          If you are a Pentaho Subscription customer, you may contact support and request that this case be reviewed/re-prioritized.

          Show
          Former Triage User Old Triage User (Inactive) added a comment - If you are a Pentaho Subscription customer, you may contact support and request that this case be reviewed/re-prioritized.
          Hide
          vanna vanna added a comment -

          Problem could be with JAVA_EXT_DIRS in kitchen.bat
          Try set path to ext libraries (files: dnsns.jar, localedata.jar, sunjce_provider.jar, ...) - in my case (windows) it was necessery to add following line to kitchen.bat
          set JAVA_EXT_DIRS=%JAVA_EXT_DIRS%;%JAVA_HOME%jre\lib\ext\;

          Show
          vanna vanna added a comment - Problem could be with JAVA_EXT_DIRS in kitchen.bat Try set path to ext libraries (files: dnsns.jar, localedata.jar, sunjce_provider.jar, ...) - in my case (windows) it was necessery to add following line to kitchen.bat set JAVA_EXT_DIRS=%JAVA_EXT_DIRS%;%JAVA_HOME%jre\lib\ext\;
          Hide
          sflatley Sean Flatley (Inactive) added a comment -

          Use for validation.

          Show
          sflatley Sean Flatley (Inactive) added a comment - Use for validation.
          Hide
          sflatley Sean Flatley (Inactive) added a comment -

          No code changes were needed. Mat took care of this with PDI-4010.

          You can use the attached file, validation.kjb, which simply sends a test email.
          Use Spoon to specify the receiver's email.

          Note: It was said in the case that "Secure connection type" is set to "TLS" that there are problems.
          If TLS is chosen then the "Port" must be changed to "587".

          This issue will be filed as a separate Jira case.

          Show
          sflatley Sean Flatley (Inactive) added a comment - No code changes were needed. Mat took care of this with PDI-4010 . You can use the attached file, validation.kjb, which simply sends a test email. Use Spoon to specify the receiver's email. Note: It was said in the case that "Secure connection type" is set to "TLS" that there are problems. If TLS is chosen then the "Port" must be changed to "587". This issue will be filed as a separate Jira case.
          Hide
          gdavid Golda Thomas added a comment -

          Tested this issue using the PDI 4.1.2 GA nightly build and this issue is resolved.

          Show
          gdavid Golda Thomas added a comment - Tested this issue using the PDI 4.1.2 GA nightly build and this issue is resolved.
          Hide
          gdavid Golda Thomas added a comment -

          Tested this issue also using kitchen.bet and this issue is resolved.

          Show
          gdavid Golda Thomas added a comment - Tested this issue also using kitchen.bet and this issue is resolved.

            People

            • Assignee:
              gdavid Golda Thomas
              Reporter:
              jmelo Eduardo Freitas de Melo
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: