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

          jmelo Eduardo Freitas de Melo created issue -
          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
          jmelo Eduardo Freitas de Melo made changes -
          Field Original Value New Value
          Attachment MakeBackup-Project.bat.txt [ 21696 ]
          Attachment MakeBackup-Project.kjb [ 21697 ]
          kcruzada Kurtis Cruzada made changes -
          Original Estimate 24h [ 86400 ]
          Remaining Estimate 24h [ 86400 ]
          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.
          kcruzada Kurtis Cruzada made changes -
          Assignee Triage [ project admin ] Unassigned User [ unassigned ]
          Severity Critical [ 2 ] Medium [ 6 ]
          Status Open [ 1 ] Open [ 1 ]
          Fix Version/s Future Release [ 10307 ]
          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\;
          bhagan Brian Hagan (Inactive) made changes -
          Customer Case 14215
          bhagan Brian Hagan (Inactive) made changes -
          Assignee Unassigned User [ unassigned ] Triage [ project admin ]
          kcruzada Kurtis Cruzada made changes -
          Status Open [ 1 ] Open [ 1 ]
          Severity Medium [ 6 ] Severe [ 3 ]
          Assignee Triage [ project admin ] Mat Lowery [ mlowery ]
          Fix Version/s 4.1.2 [ 11071 ]
          Fix Version/s Future Release [ 10307 ]
          sflatley Sean Flatley (Inactive) made changes -
          Assignee Mat Lowery [ mlowery ] Sean Flatley [ sflatley ]
          sflatley Sean Flatley (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          sflatley Sean Flatley (Inactive) added a comment -

          Use for validation.

          Show
          sflatley Sean Flatley (Inactive) added a comment - Use for validation.
          sflatley Sean Flatley (Inactive) made changes -
          Attachment validate.kjb [ 24251 ]
          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.
          sflatley Sean Flatley (Inactive) made changes -
          Status In Progress [ 3 ] Ready For Test [ 10004 ]
          CI Build CI: pdi-ee-6002, 4.1.2: ftp://ftpgolden.pentaho.com/PentahoStaging/GA-RELEASE/4.1.2/
          Assignee Sean Flatley [ sflatley ] Golda David [ gdavid ]
          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.
          gdavid Golda Thomas made changes -
          Status Ready For Test [ 10004 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          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.
          gdavid Golda Thomas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          QA Validation Status Not Yet Validated Validated by QA
          sflatley Sean Flatley (Inactive) made changes -
          Link This issue relates to PDI-5245 [ PDI-5245 ]
          mlowery Mat Lowery (Inactive) made changes -
          Link This issue relates to PDI-4010 [ PDI-4010 ]
          mbatchelor Marc Batchelor made changes -
          Workflow Pentaho Engineering 8.0 Workflow [ 543556 ] Pentaho Engineering 9.0 Workflow [ 574233 ]
          jiraservice Jira Service Acct made changes -
          Workflow Pentaho Engineering 9.0 Workflow [ 574233 ] Pentaho Bug 1.0 Workflow [ 635096 ]
          jiraservice Jira Service Acct made changes -
          Workflow Pentaho Bug 1.0 Workflow [ 635096 ] Pentaho Engineering 9.0 Workflow [ 657132 ]
          jiraservice Jira Service Acct made changes -
          Customer Case (new) 14215
          jiraservice Jira Service Acct made changes -
          Workflow Pentaho Engineering 9.0 Workflow [ 657132 ] Pentaho Engineering 9.1 Workflow [ 753551 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Open Open
          154d 21h 39m 2 Kurtis Cruzada 18/Jan/11 8:11 AM
          Open Open In Progress In Progress
          1d 1h 10m 1 Sean Flatley (Inactive) 19/Jan/11 9:21 AM
          In Progress In Progress Ready For Test Ready For Test
          1h 2m 1 Sean Flatley (Inactive) 19/Jan/11 10:23 AM
          Ready For Test Ready For Test Resolved Resolved
          2h 22m 1 Golda Thomas 19/Jan/11 12:46 PM
          Resolved Resolved Closed Closed
          3m 28s 1 Golda Thomas 19/Jan/11 12:49 PM

            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: