Hitachi Vantara Pentaho Community Forums
Results 1 to 15 of 15

Thread: Send mail steps with problem

  1. #1

    Question Send mail steps with problem

    Dear everybody:
    I'm working in transformation steps, and i need send email in this steps. But, when configure the Mail Steps (Transformation --> Utility --> Mail) and put email address destination, name sender, email sender, autentification server and correctly SMTP Server & Port, Kettle give me this error msg
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We can not find destination field [dorellana@bbr.cl] in input stream!
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.processRow(Mail.java:139)
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/24 18:03:48 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source)



    Can u helpme to understand what am i doing wrong?

    I'll be gratefull for any help can you provide.

    regards!
    Delia

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You need to put the address (dorellana@bbr.cl) in a field and you need to specify this field as input.

  3. #3

    Default

    Hi Matt
    I folowed your tips:
    1. in Generate Row Steps, i generate Dest_Email field with my email address (and other fields neccesary to email steps transformation)
    2. in Mail Step Transformation, assign Dest_Email in Destination Frame
    but, i see the same error msg.... with my dest_email field


    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : We can not find destination field [Dest_Email] in input stream!
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.processRow(Mail.java:139)
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/25 18:40:24 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source)

    ...I don't understand nothing....

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    I would check that the Mail Step can find those input fields.
    Right click on the step and choose: "show input fields".

    Mick

  5. #5

    Default

    i did this (right click in mail step) and this field are in input stream.... any other quest?

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Mixing row layouts? Show us a screenshot of the transformation for more help.

  7. #7

    Default

    Ok, attach 4 screenshot, with transformation & step detail
    Attached Images Attached Images     

  8. #8
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Try: "Get File names" --> Add Constants (add the e-mail details) --> Mail

    Right now the "Get file names" step is eating the input.

  9. #9
    Join Date
    Nov 2008
    Posts
    777

    Default

    In your Get File Names step, is the option "Filename is defined in a field?" checked? If you hit the "Verify this transformation" icon, it will probably tell you the answer. That is the only way that this type of input step will pass data from a previous step.

    What you have done is put two input steps in series. The Generate Rows step, of course, generates rows but then the Get File Names step generates more rows for each row generated by the prior step. That's probably not what you want to do unless flooding the email system is your goal. Matt's suggestion above is, as usual, on the mark. The Add Constants step will add fields to every row generated by the Get File Names step. It won't add more rows.
    Last edited by darrell.nelson; 10-26-2011 at 09:43 AM.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  10. #10

    Default

    Yep, was checked this box option...
    Now, i have new wrong with Matt's options.... Pls see msg


    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Can not send mail!
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run (null:-1)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:40)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.processRow (Mail.java:392)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.sendMail (Mail.java:584)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at javax.mail.Service.connect (Service.java:306)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) :
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.processRow(Mail.java:407)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Caused by: javax.mail.AuthenticationFailedException
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at javax.mail.Service.connect(Service.java:306)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.sendMail(Mail.java:584)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.mail.Mail.processRow(Mail.java:392)
    2011/10/26 10:56:28 - Mail.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : ... 2 more


    I thought "may be neccesary auttentificate e-mail account, with uname & Password email.." but the wrong it's same...

    pls.. if somebody know how can i do it correctly? thanks
    Delia

  11. #11
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You're on your own from here with the security problem. Perhaps you can use a public email SMTP server like gmail.

  12. #12

    Default

    I tryed with hotmail... same problem...

  13. #13

    Default

    Important: I don't have problem in Mail Job... only Mail transformation step.... In other flow i have the same problem.... I don't understand nothing...

  14. #14

    Default

    Estimados:
    I did this transformation... The problem was only in UserName field. i add complete email dir to user name and email was sent. The problem is: In reality, my customer haven't email account with Uname & PW... is a non_reply account. Then, i'll not validate this account. Then, how can i send email wihtout authentication ?

    regards.
    Delia

  15. #15

    Default

    any comment about non autentication e-mail?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.