STEP - Email messages input NOT Working

[aabadi]

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

[wvaibhav]

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

[aabadi]

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

[wvaibhav]

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

[aabadi]

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.

[blaue_Tomate]

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!

[shassan2]

Hi,

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

Thanks

Samatar

[shassan2]

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

Thanks

[aabadi]

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

[shassan2]

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