Pentaho

 View Only

 error read mail using Email messages input with Gmail address

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Fabrizio Agosti's profile image
Fabrizio Agosti posted 04-20-2018 07:56

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?


#PentahoDataIntegrationPDI
#Pentaho
#Kettle
Data Conversion's profile image
Data Conversion

Configuring Sbcglobal Email with Google Gmail

There Are many Gmail users who have a question about configuring Sbcglobal mail in Gmail? Well, to help you, here in this article, you share a simple solution. Using this very simple process, all your emails will be sent directly to your Gmail inbox.

Data Conversion's profile image
Data Conversion
Data Conversion's profile image
Data Conversion