Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: IMAP email message import - unicode-1-1-utf-7 problem

  1. #1
    Join Date
    Jul 2011
    Posts
    21

    Default IMAP email message import - unicode-1-1-utf-7 problem

    When i try to use the "Email messages input"-step, I get the following error:

    I use an IMAP-connection.

    Does anybody know how to fix this, or a workaround?

    Code:
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error adding values to row!
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : unicode-1-1-utf-7
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:326)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:69)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at java.lang.Thread.run(Unknown Source)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: java.io.UnsupportedEncodingException: unicode-1-1-utf-7
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at sun.nio.cs.StreamDecoder.forInputStreamReader(Unknown Source)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at java.io.InputStreamReader.<init>(Unknown Source)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at com.sun.mail.handlers.text_plain.getContent(text_plain.java:95)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at javax.activation.DataSourceDataContentHandler.getContent(Unknown Source)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at javax.activation.DataHandler.getContent(Unknown Source)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at javax.mail.internet.MimeBodyPart.getContent(MimeBodyPart.java:652)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.job.entries.getpop.MailConnection.getMessageBody(MailConnection.java:1001)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.job.entries.getpop.MailConnection.getMessageBody(MailConnection.java:1020)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.job.entries.getpop.MailConnection.getMessageBody(MailConnection.java:993)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:263)
    2012/09/02 12:12:46 - Email messages input.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :     ... 3 more
    2012/09/02 12:12:46 - test - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!
    2012/09/02 12:12:46 - test - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors detected!

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Apparently, UTF-7 is not a Java supported encoding: http://docs.oracle.com/javase/7/docs...oding.doc.html

    This might help: http://www.freeutils.net/source/jcharset/
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jul 2011
    Posts
    21

    Default

    Hi, thanks.

    In what folder should the .jar file be dropped?

    I already tried in C:\Pentaho\pdi-ce-4.3.0-stable\data-integration\libext but that didn't do the trick.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Why not drop it outside of the Pentaho installation folder and adjust the CLASSPATH?
    That way you don't loose the functionality with every PDI upgrade and your own Java development is able to benefit, too.
    So long, and thanks for all the fish.

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.