Hitachi Vantara Pentaho Community Forums
Results 1 to 12 of 12

Thread: STEP - Email messages input NOT Working

  1. #1

    Default STEP - Email messages input NOT Working

    Im trying to retrieve emails and the Step is working if I do a preview, if I try to run it and save the results to a table, the information I receive for each field is the number of the row.

    Can someone help me?
    Thanks a lot in advance

    PS. Im using Kettle - PDI 4.0.0 GA

  2. #2
    wvaibhav Guest

    Default

    Hi Aabadi,

    Have you resolved the problem ? could you please let me know the the details, I am facing same issue for email fetching.
    I am using Im using Kettle - PDI 4.0.1.

    Following is the error i receive.
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unexpected error :
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error adding values to row!
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : at java.lang.Thread.run (Thread.java:595)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:40)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : at org.pentaho.di.trans.steps.mailinput.MailInput.processRow (MailInput.java:62)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow (MailInput.java:259)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:301)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:62)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2010/09/21 12:45:18 - Email messages input.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Thread.java:595)

    Connection test is successful.

    Thanks
    Vaibhav
    Last edited by wvaibhav; 09-21-2010 at 03:19 AM.

  3. #3

    Unhappy

    No I havent solved this issue . I have also tried on 4.0.1 and is still having the same error.

    The strange thing is that on the "Preview this transformation" it works, I mean I receive the information correctly, but when run the Transformation, is sending all the information as 1. For example instead of saving on the table the sender of the email, I have a "1"

    Can someone help us ???!!!!
    Thanks in advance

  4. #4
    wvaibhav Guest

    Default

    Hi Abadi,

    I could retrieve mail using job. In Kettle, there is a job where you can retrieve complete mail along with an attachment. Just check it out, it might be helpful.

    Let me know in case if you have any questions.

    Thanks
    Vaibhav

  5. #5

    Default

    Hi wvaibhav!

    Thanks for the info!, it's true and Im using that one, but the problem is that in the case of the Job, I have to save the email as a file and if I want to know how has sent the message, or the time, or who are on copy, I need to analyse that file and Im having problems validating it, so when I saw in the Transformation side, that I can pull all this information directly, I was amazed, but it didnt worked for me
    Even though thanks for the comment.

  6. #6
    Join Date
    Mar 2011
    Posts
    11

    Default

    Is there a solution ?
    I have the same problem.

    Pentaho dont saves the correct Field description and he always takes the "message number " as output!

  7. #7

    Default

    Hi,

    please if you think it's a bug do no hesitate file a bug.
    We fill fix it ASAP.

    Thanks

    Samatar
    Samatar

  8. #8

    Default

    Can you please provide following infos:
    - Version
    - Repository?
    - a sample?

    Thanks
    Samatar

  9. #9

    Default

    I used to run all of my Jobs directly from the Repository, but I found that if I run this Transformation as a file (not from the Repository) then it works perfectly well!!!!

    So my solution was NOT to use the repository for that specific Transformation. To tell you the truth, I dont like this solution, but it works

    My feeling is that it is a bug!
    I hope this can solve your issue too.

    I am now using Kettle - PDI 4.1.3-r15048

  10. #10

    Default

    Ok Nice catch
    Created a bug
    The fix is available in :
    - PDI 4.0.3
    - PDI 4.1.4
    - PDI 4.2

    Thanks a lot for your support and enjoy PDI :-)

    Samatar
    Samatar

  11. #11
    Join Date
    Jun 2012
    Posts
    2

    Default

    Please remove the some of the fields from the Email Message Input. like I have removed the Received date and send date and mine is working.

    please try.

  12. #12
    Join Date
    Oct 2013
    Posts
    1

    Default STEP - Email messages input NOT Working

    How to configure email setting to recieve email messages with a pop count and put out in a table. Is not working the connecction that i 've. Help me.

    Bye
    Last edited by sevionline; 10-02-2013 at 04:42 PM.

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.