AnsweredAssumed Answered

error read mail using Email messages input with Gmail address

Question asked by Fabrizio Agosti on Apr 20, 2018
Latest reply on Oct 24, 2018 by Alex Chris

Hi,

I'm using Pentaho Data Integration version 6.1.

 

I tring to use "Email messages input" for read email message from Gmail. The test of Connection configuration is Ok. The test of Input folder is ok,  but when execute the transformation I receive this error:

 

2018/04/20 07:31:54 - Spoon - Spoon

2018/04/20 07:50:00 - /test/test_mail_read_tr - Dispatching started for transformation [/test/test_mail_read_tr]

2018/04/20 07:50:03 - Email messages input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Error opening folder 1 [Gmail]: org.pentaho.di.core.exception.KettleException:

2018/04/20 07:50:03 - Email messages input.0 - Error! Can not open folder [[Gmail]]!

2018/04/20 07:50:03 - Email messages input.0 - folder cannot contain messages

2018/04/20 07:50:03 - Email messages input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleException:

2018/04/20 07:50:03 - Email messages input.0 - Error! Can not open folder [[Gmail]]!

2018/04/20 07:50:03 - Email messages input.0 - folder cannot contain messages

2018/04/20 07:50:03 - Email messages input.0 -

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.job.entries.getpop.MailConnection.openFolder(MailConnection.java:422)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.job.entries.getpop.MailConnection.openFolder(MailConnection.java:346)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.openNextFolder(MailInput.java:337)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:214)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:75)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2018/04/20 07:50:03 - Email messages input.0 - at java.lang.Thread.run(Unknown Source)

2018/04/20 07:50:03 - Email messages input.0 - Caused by: javax.mail.MessagingException: folder cannot contain messages

2018/04/20 07:50:03 - Email messages input.0 - at com.sun.mail.imap.IMAPFolder.open(IMAPFolder.java:937)

2018/04/20 07:50:03 - Email messages input.0 - at org.pentaho.di.job.entries.getpop.MailConnection.openFolder(MailConnection.java:406)

2018/04/20 07:50:03 - Email messages input.0 - ... 6 more

2018/04/20 07:50:03 - Email messages input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)

2018/04/20 07:50:03 - /test/test_mail_read_tr - Transformation detected one or more steps with errors.

2018/04/20 07:50:03 - /test/test_mail_read_tr - Transformation is killing the other steps!

 

What can I do to solve the problem?

Outcomes