Mail import error

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Mail import error

Post by MKochS » Mon Oct 24, 2016 12:33 pm

System: Debian Jessie, OKM 6.3.1 (upgraded from 6.3.0)

Mail retrieval still breaks when unexpected or malformed Mails occur; this is the latest error message I am getting

Code: Select all

2016-10-24 14:00:01,801 [Thread-57804] ERROR com.openkm.util.MailUtils- iso-8859-8-i
java.io.UnsupportedEncodingException: iso-8859-8-i
        at sun.nio.cs.StreamDecoder.forInputStreamReader(StreamDecoder.java:71)
        at java.io.InputStreamReader.<init>(InputStreamReader.java:100)
        at com.sun.mail.handlers.text_plain.getContent(text_plain.java:107)
        at javax.activation.DataSourceDataContentHandler.getContent(DataHandler.java:795)
        at javax.activation.DataHandler.getContent(DataHandler.java:542)
        at javax.mail.internet.MimeBodyPart.getContent(MimeBodyPart.java:637)
        at com.openkm.util.MailUtils.getText(MailUtils.java:908)
        at com.openkm.util.MailUtils.getText(MailUtils.java:952)
        at com.openkm.util.MailUtils.messageToMail(MailUtils.java:677)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:602)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Obviously, the problem pops up here:


2016-10-24 14:00:01,801 [Thread-57804] ERROR com.openkm.util.MailUtils- iso-8859-8-i
java.io.UnsupportedEncodingException: iso-8859-8-i



Consequently, retrieval of the mail in question and all following mails fails. The malformed email (typically spam) needs to be deleted from the mailbox manually.

Is there a way to work around this?

TIA
Matthias

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Wed Oct 26, 2016 6:10 pm

Althought we have released a new version 6.3.2 I think this bug is still not solved, must change the source code for it. Can you provide a mail ( eml or msg ) for testing purposes.

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Wed Oct 26, 2016 6:21 pm

I don't have that specific mail any more. I'll save one the next time this problem occurs (usually several times a month). As far as I can tell, the problem is caused with mails with exotic language formats and special characters in the header (i. e. non-7bit or non-UTF characters).

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Fri Oct 28, 2016 2:37 pm

We know where is the problem and how to solve it, but with some mail for testing, we can correct in a safe way. If someone goes in your hand again, please export as msg or eml and attach in this post.

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Mon Oct 31, 2016 11:42 am

Just received another one:

Code: Select all

2016-10-31 00:30:00,035 [Thread-64053] INFO  com.openkm.core.UserMailImporter- *** User mail importer activated ***
2016-10-31 00:30:00,386 [Thread-64053] INFO  com.openkm.util.MailUtils- ======= ======= 0 ======= =======
2016-10-31 00:30:00,403 [Thread-64053] INFO  com.openkm.util.MailUtils- Subject: Freie Stelle
2016-10-31 00:30:00,403 [Thread-64053] INFO  com.openkm.util.MailUtils- From: diane.b@yyyyy.yyy
2016-10-31 00:30:00,403 [Thread-64053] INFO  com.openkm.util.MailUtils- Received: Tue Oct 25 12:31:08 CEST 2016
2016-10-31 00:30:00,403 [Thread-64053] INFO  com.openkm.util.MailUtils- Sent: Tue Oct 25 17:43:58 CEST 2016
2016-10-31 00:30:00,420 [Thread-64053] ERROR com.openkm.util.MailUtils- cp-850
java.io.UnsupportedEncodingException: cp-850
        at sun.nio.cs.StreamDecoder.forInputStreamReader(StreamDecoder.java:71)
        at java.io.InputStreamReader.<init>(InputStreamReader.java:100)
        at com.sun.mail.handlers.text_plain.getContent(text_plain.java:107)
        at javax.activation.DataSourceDataContentHandler.getContent(DataHandler.java:795)
        at javax.activation.DataHandler.getContent(DataHandler.java:542)
        at javax.mail.internet.MimeBodyPart.getContent(MimeBodyPart.java:637)
        at com.openkm.util.MailUtils.getText(MailUtils.java:908)
        at com.openkm.util.MailUtils.getText(MailUtils.java:938)
        at com.openkm.util.MailUtils.messageToMail(MailUtils.java:677)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:602)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.GeneratedMethodAccessor30906.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
These lines might be of interest:

Code: Select all

2016-10-31 01:00:00,503 [Thread-64073] ERROR com.openkm.util.MailUtils- cp-850
java.io.UnsupportedEncodingException: cp-850
This is the mail in question:

Code: Select all

Received: from [80.67.18.3] (helo=mx03.ispgateway.de)
	by carta.ispgateway.de with esmtp (Exim 4.68)
	(envelope-from <diane.b@yyyyy.yyy>)
	id 1byz0e-0001LA-Ig; Tue, 25 Oct 2016 12:31:08 +0200
Return-path: <diane.b@yyyyy.yyy>
X-Envelope-To: myspace_m@xxxxx.xxx
Received: from [122.161.180.74] (helo=abts-north-dynamic-074.180.161.122.airtelbroadband.in)
	by mx03.ispgateway.de with esmtp (Exim 4.84)
	(envelope-from <diane.b@yyyyy.yyy>)
	id 1byz0X-0002U1-7D
	for myspace_m@xxxxx.xxx; Tue, 25 Oct 2016 12:31:05 +0200
Message-ID: <5939243339442E2E4E53444E33595939@X4SNL1Q>
From: <diane.b@yyyyy.yyy>
To: <myspace_m@xxxxx.xxx>
Subject: Freie Stelle
Date: 25 Oct 2016 19:43:58 +0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_002F_01D22ED8.07B4657F"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
	spamfilter18.ispgateway.de
X-Spam-Level: **********
X-Spam-Status: No, hits=10.0 required=9999.0 tests=BAYES_50,CMAE_1 autolearn=disabled
	version=3.3.1
X-Spam-CMAETAG: v=2.1 cv=YP8RyH2x c=1 sm=0 tr=0 p=ZVcQiTCKynb9iWN3vN4A:9
	a=tTgWrreNRqSrmWDDQMy1dQ==:17 a=CH0kA5CcgfcA:10 a=r77TgQKjGQsHNAKrUKIA:9
	a=tfwewdB7HFUA:10 a=WEb1MeeGBC8A:10 a=ZpigTsIhAAAA:8 a=_W_S_7VecoQA:10
	a=EOWYfShQHl2jtTy-lRlF:22 xcat=Undefined/Undefined
X-Spam-CMAECATEGORY: 0
X-Spam-CMAESUBCATEGORY: 0
X-Spam-CMAESCORE: 100

This is a multi-part message in MIME format.

------=_NextPart_000_002F_01D22ED8.07B4657F
Content-Type: text/plain;
	charset="cp-850"
Content-Transfer-Encoding: quoted-printable

Lieber myspace_m,

Wir suchen nach Mitarbeitern, die von zu Hause aus arbeiten wollen.
Mein Name ist Claire und ich bin der Personalleiter einer gro&#223;en, =
internationalen Firma.
Den gr&#246;&#223;ten Teil der Arbeit k&#246;nnen Sie von zu Hause, das =
hei&#223;t, egal wo erledigen.
Bezahlung ist 3000 &#8364;-6000 &#8364;

Falls Sie an diesem Angebot Interesse haben, besuchen=20
Sie bitte unsere Seite

Mit freundlichen Gr&#252;&#223;en!
Personalabteilung
------=_NextPart_000_002F_01D22ED8.07B4657F
Content-Type: text/html;
	charset="cp-850"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dcp-850">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
Lieber myspace_m,<br>
<br>
Wir suchen nach Mitarbeitern, die von zu Hause aus arbeiten wollen.<br>
Mein Name ist Claire und ich bin der Personalleiter einer gro&#223;en, =
internationalen Firma.<br>
Den gr&#246;&#223;ten Teil der Arbeit k&#246;nnen Sie von zu Hause, das =
hei&#223;t, egal wo erledigen.<br>
Bezahlung ist 3000 &#8364;-6000 &#8364;<br>
<br>
Falls Sie an diesem Angebot Interesse haben, besuchen <a =
href=3D"http://jelsinpiazza.it/administrator/components/com_akeeba/views/=
transfer/tmpl/"><b>Sie bitte unsere Seite</b></a><br>
<br>
Mit freundlichen Gr&#252;&#223;en!<br>
Personalabteilung</BODY></HTML>
------=_NextPart_000_002F_01D22ED8.07B4657F--
Edit: changed my domain to xxxxx.xxx and the sender's domain to yyyyy.yyy, as it might be a legitimate mailaddress abused by the spammer. I couldn't include the eml file because the file wasn't accepted, no matter what extension it had.

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Mon Oct 31, 2016 1:07 pm

And one more (just the headers):

Code: Select all

Received: from [80.67.18.103] (helo=mx06.ispgateway.de)
	by carta.ispgateway.de with esmtp (Exim 4.68)
	(envelope-from <invalid>)
	id 1bzjT9-0005Jm-Ib; Thu, 27 Oct 2016 14:07:39 +0200
Return-path: <invalid>
X-Envelope-To: invalid
Received: from [80.67.31.104] (helo=smtprelay06.ispgateway.de)
	by mx06.ispgateway.de with esmtps (TLSv1.2:DHE-RSA-AES256-GCM-SHA384:256)
	(Exim 4.84)
	(envelope-from <invalid>)
	id 1bzjT7-0005q8-T6
	for invalid; Thu, 27 Oct 2016 14:07:38 +0200
Received: from [83.137.71.108] (helo=[10.100.100.243])
	by smtprelay06.ispgateway.de with esmtpsa (TLSv1.2:DHE-RSA-AES256-SHA:256)
	(Exim 4.84)
	(envelope-from <invalid>)
	id 1bzjT4-0004Ea-LF
	for invalid; Thu, 27 Oct 2016 14:07:37 +0200
User-Agent: K-9 Mail for Android
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----WLZZQJLE3I2BJYG4RK31OFBTU9LYD2"
Content-Transfer-Encoding: 8bit
Subject: =?UTF-8?B?8J+Ygg==?=
From: X <invalid>
Date: Thu, 27 Oct 2016 14:07:30 +0200
To: X <invalid>
Message-ID: <4413AA2A-D7FC-47AE-A3B0-5CCAA9075559@invalid>
X-Df-Sender: OTkwODM1
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
	spamfilter21.ispgateway.de
X-Spam-Level: 
X-Spam-Status: No, hits=-6.6 required=9999.0 tests=BAYES_00 autolearn=disabled
	version=3.3.1
X-Spam-CMAETAG: v=2.1 cv=S/xXwecP c=1 sm=0 tr=0
	a=kBUKEotk1tHWKiDQYkb1GQ==:17 a=1oJP67jkp3AA:10 a=CH0kA5CcgfcA:10
	a=ZZnuYtJkoWoA:10 a=EACTImzLHNkVGc5is40A:9 a=xvwCMQOdp0bDE-bL:18
	a=KQqxNPgzF0kA:10 xcat=Undefined/Undefined
X-Spam-CMAECATEGORY: 0
X-Spam-CMAESUBCATEGORY: 0
X-Spam-CMAESCORE: 0
which results in this log entry:

Code: Select all

2016-10-31 13:00:41,709 [Thread-64542] INFO  com.openkm.util.MailUtils- ======= ======= 166 ======= =======
2016-10-31 13:00:41,728 [Thread-64542] INFO  com.openkm.util.MailUtils- Subject: <U+1F602>
2016-10-31 13:00:41,728 [Thread-64542] INFO  com.openkm.util.MailUtils- From: X <invalid>
2016-10-31 13:00:41,729 [Thread-64542] INFO  com.openkm.util.MailUtils- Received: Thu Oct 27 14:07:39 CEST 2016
2016-10-31 13:00:41,729 [Thread-64542] INFO  com.openkm.util.MailUtils- Sent: Thu Oct 27 14:07:30 CEST 2016
2016-10-31 13:00:41,758 [Thread-64542] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1366, SQLState: HY000
2016-10-31 13:00:41,758 [Thread-64542] ERROR org.hibernate.util.JDBCExceptionReporter- Incorrect string value: '\xF0\x9F\x98\x82' for column 'NBS_NAME' at row 1
2016-10-31 13:00:41,758 [Thread-64542] ERROR com.openkm.core.UserMailImporter- Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:106)
        at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:139)
        at com.openkm.module.db.DbMailModule.create(DbMailModule.java:123)
        at com.openkm.util.MailUtils.importMail(MailUtils.java:801)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:607)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.GeneratedMethodAccessor31988.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2420)
                at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:90)
        ... 21 more
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'NBS_NAME' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1454)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 36 more

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Tue Nov 01, 2016 9:00 am

Are similar errors caused by encoding but not exactly the same. Seems will be not possible to get the eml or msg ?

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Tue Nov 01, 2016 9:53 am

Seems will be not possible to get the eml or msg?
I can't upload the mail. Whatever extension I am choosing (or none at all), I always get "invalid file extension".
The complete source, however, is in my above post.

The second one has already been deleted, but I'll try and save them for future reference.

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Thu Nov 03, 2016 8:34 am

OK, we'll we waiting for it.

pavila
Moderator
Moderator
Posts: 3085
Joined: Tue Dec 11, 2007 6:02 pm
Location: Alicante, Spain
Contact:

Re: Mail import error

Post by pavila » Thu Nov 03, 2016 9:20 am

Can you reproduce this error in OpenKM 6.3.2 ?

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Fri Jun 07, 2019 7:58 am

This seems a bit outdated... I have moved up to 6.3.3 now and I'm still getting these errors. Apparently when there are "fancy" characters/symbols in the header lines. Here's another example:

Code: Select all

2019-06-07 09:00:00,109 [Thread-125] INFO  com.openkm.core.UserMailImporter- *** User mail importer activated ***
2019-06-07 09:00:01,509 [Thread-125] INFO  com.openkm.util.MailUtils- ======= ======= 0 ======= =======
2019-06-07 09:00:01,523 [Thread-125] INFO  com.openkm.util.MailUtils- Subject: 📷 John Doehat ein neues Foto gepostet
2019-06-07 09:00:01,523 [Thread-125] INFO  com.openkm.util.MailUtils- From: Facebook <notification@facebookmail.com>
2019-06-07 09:00:01,524 [Thread-125] INFO  com.openkm.util.MailUtils- Received: Thu Jun 06 14:12:36 CEST 2019
2019-06-07 09:00:01,525 [Thread-125] INFO  com.openkm.util.MailUtils- Sent: Thu Jun 06 14:12:34 CEST 2019
2019-06-07 09:00:01,606 [Thread-125] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1366, SQLState: 22001
2019-06-07 09:00:01,607 [Thread-125] ERROR org.hibernate.util.JDBCExceptionReporter- Data truncation: Incorrect string value: '\xF0\x9F\x93\xB7 S...' for column 'NBS_NAME' at row 1
2019-06-07 09:00:01,608 [Thread-125] ERROR com.openkm.core.UserMailImporter- Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:106)
        at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:139)
        at com.openkm.module.db.DbMailModule.create(DbMailModule.java:123)
        at com.openkm.util.MailUtils.importMail(MailUtils.java:801)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:607)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2420)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:90)
        ... 21 more
Caused by: java.sql.BatchUpdateException: Data truncation: Incorrect string value: '\xF0\x9F\x93\xB7 S...' for column 'NBS_NAME' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1454)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 36 more
Here are the full headers of the mail:

Code: Select all

Delivery-date: Thu, 06 Jun 2019 14:12:36 +0200
Received: from [80.67.29.41] (helo=mx08.ispgateway.de)
	by mailcluster2-2.ispgateway.de with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256)
	(Exim 4.90_1)
	(envelope-from <notification@facebookmail.com>)
	id 1hYrFz-0007FC-VZ; Thu, 06 Jun 2019 14:12:36 +0200
Return-path: <notification@facebookmail.com>
X-Envelope-to: xxxxx@xxxxx.de
Received: from [66.220.155.153] (helo=mx-out.facebook.com)
	by mx08.ispgateway.de with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128)
	(Exim 4.90_1)
	(envelope-from <notification@facebookmail.com>)
	id 1hYrFz-0005VY-G4
	for xxxxx@xxxxx.de; Thu, 06 Jun 2019 14:12:35 +0200
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=facebookmail.com;
	s=s1024-2013-q3; t=1559823154;
	bh=xp1wOjeUf58u+Mq2XT8YnU5nnZ0DgifZzPYt/2cg6Gg=;
	h=Date:To:Subject:From:MIME-Version:Content-Type;
	b=O1YUxEWXYJrFBvLcEsv+q037xIPjW6UaGZF/g474qDOj+oaJHkt7MnXujbVLqDl16
	 zZoqdNesboR5LtVog6qavAiV0dAKLhdviXmRHfUU1tqW3KGxDqViVU91adVyqcBnJf
	 Etbic/soQPxN7QyNGGXN2MfYwXM/DHPRNzIG9fTM=
Received: from facebook.com (0a9ruXikp55oPs9WZLgmeUjAMecx6h6ZBchuqucrZ9+t6kVTnijJXbT4Lm0CmNDJ 2401:db00:2120:80da:face:0000:0017:0000)
 by facebook.com with Thrift id 5da4d2f4885411e9b49dec0d9a7d2380-dabba6f0;
 Thu, 06 Jun 2019 05:12:34 -0700
X-Facebook: from 2401:db00:2111:50a9:face:0:3b:0 ([MTI3LjAuMC4x]) 
	by www.facebook.com with HTTPS (ZuckMail);
Date: Thu, 6 Jun 2019 05:12:34 -0700
To: xxxxx xxxxx <xxxxx@xxxxx.de>
Subject: =?UTF-8?B?8J+TtyBTdXNpIFNjaGlsbGVy?=
 =?UTF-8?B?IGhhdCBlaW4gbmV1ZXMg?=
 =?UTF-8?B?Rm90byBnZXBvc3RldA==?=
X-Priority: 3
X-Mailer: ZuckMail [version 1.00]
From: "Facebook" <notification@facebookmail.com>
Reply-to: noreply <noreply@facebookmail.com>
Errors-To: notification@facebookmail.com
X-Facebook-Notify: nf_photo_story; mailid=58aa657602f55G5af38caa53c5G58aa6a0f63227G314
List-Unsubscribe: <https://www.facebook.com/o.php?k=AS2nSB9h_e8KlREu&u=100002083525573&mid=58aa657602f55G5af38caa53c5G58aa6a0f63227G314>
Feedback-ID: 0:nf_photo_story:Facebook
X-FACEBOOK-PRIORITY: 1
X-Auto-Response-Suppress: All
Require-Recipient-Valid-Since: xxxxx@xxxxx.de; Friday, 25 Feb 2011 04:02:28 +0000
Message-ID: <f05c65cc664bb51eae5cb483d3bb2bdf@3e723b591bdb95ce8f5c9b7032dc572ca97351d0da5efc73459c1fbaf438e43b>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="b1_f05c65cc664bb51eae5cb483d3bb2bdf"
X-Received-SPF: pass ( mx08.ispgateway.de: domain of facebookmail.com designates 66.220.155.153 as permitted sender )
X-DKIM: DKIM passed: (address=notification@facebookmail.com domain=facebookmail.com), signature is good.
X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on
	spamfilter31.ispgateway.de
X-Spam-Level: 
X-Spam-Status: No, hits=0.0 required=9999.0 tests=BAYES_50 autolearn=disabled
	version=3.4.0
X-Spam-CMAETAG: v=2.2 cv=H4mr+6Qi c=1 sm=1 tr=0
	a=wUIxPB4I97G1iesS6UR+hA==:17 a=dq6fvYVFJ5YA:10 a=-uNXE31MpBQA:10
	a=MOEc7tJgzdcA:10 a=OjmdU3R2H1IA:10 a=3j4BkbkPAAAA:8
	a=qgC5keuF-7UQAerzn2oA:9 a=QEXdDO2ut3YA:10 a=ZMu417LsLRwA:10
	a=D0CCUJU_AAAA:8 a=OGlpBp79nHAFJ5IMmj0A:9 a=xCiESzJFRaD710Px:21
	a=_W_S_7VecoQA:10 a=80fGaXfG2B8A:10 a=Ze6sQigKyk0A:10 a=J3hYe6k_-aAA:10
X-Spam-CMAECATEGORY: 
X-Spam-CMAESUBCATEGORY: 
X-Spam-CMAESCORE: 


--b1_f05c65cc664bb51eae5cb483d3bb2bdf
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I shouldn't be surprised if it's the camera symbol in the Subject: line. This results in

Code: Select all

Subject: =?UTF-8?B?8J+TtyBTdXNpIFNjaGlsbGVy?=
 =?UTF-8?B?IGhhdCBlaW4gbmV1ZXMg?=
 =?UTF-8?B?Rm90byBnZXBvc3RldA==?=
which has been the pattern for import failures, as far as I can see.

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Fri Jun 07, 2019 6:35 pm

Upgrade to version 6.3.7, between 6.3.2 and latest 6.3.7 we have solved some issues with emails.

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Sun Jun 09, 2019 7:55 pm

I'm on 6.3.8 now, but the problem persists.

Code: Select all

2019-06-09 21:30:02,655 [Thread-54] INFO  com.openkm.util.MailUtils- ======= ======= 0 ======= =======
[b]2019-06-09 21:30:02,687 [Thread-54] INFO  com.openkm.util.MailUtils- Subject: 📷 Max Mustermann hat ein neues Foto gepostet[/b]
2019-06-09 21:30:02,688 [Thread-54] INFO  com.openkm.util.MailUtils- From: Facebook <notification@facebookmail.com>
2019-06-09 21:30:02,688 [Thread-54] INFO  com.openkm.util.MailUtils- Received: Fri Jun 07 15:16:29 CEST 2019
2019-06-09 21:30:02,688 [Thread-54] INFO  com.openkm.util.MailUtils- Sent: Fri Jun 07 15:16:27 CEST 2019
2019-06-09 21:30:02,870 [Thread-54] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1366, SQLState: 22001
[b]2019-06-09 21:30:02,870 [Thread-54] ERROR org.hibernate.util.JDBCExceptionReporter- Data truncation: Incorrect string value: '\xF0\x9F\x93\xB7 S...' for column 'NBS_NAME' at row 1[/b]
2019-06-09 21:30:02,872 [Thread-54] ERROR com.openkm.core.UserMailImporter- Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:106)
        at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:139)
        at com.openkm.module.db.DbMailModule.create(DbMailModule.java:123)
        at com.openkm.util.MailUtils.importMail(MailUtils.java:801)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:607)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2420)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:90)
        ... 21 more

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error

Post by jllort » Thu Jun 13, 2019 5:50 pm

Can you share with us a mail sample to reproduce the issue from our side?

MKochS
Senior Boarder
Senior Boarder
Posts: 59
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Re: Mail import error

Post by MKochS » Fri Jun 14, 2019 6:39 am

So here's one error message:

Code: Select all

2019-06-12 06:30:00,134 [Thread-27] INFO  com.openkm.core.UserMailImporter- *** User mail importer activated ***
2019-06-12 06:30:04,677 [Thread-27] INFO  com.openkm.util.MailUtils- ======= ======= 0 ======= =======
2019-06-12 06:30:04,695 [Thread-27] INFO  com.openkm.util.MailUtils- [b]Subject: 🔥 18 beliebte Pins für dich
2019-06-12 06:30:04,695 [Thread-27] INFO  com.openkm.util.MailUtils- From: =?utf-8?q?Pinterest?= <recommendations@explore.pinterest.com>[/b]
2019-06-12 06:30:04,696 [Thread-27] INFO  com.openkm.util.MailUtils- Received: Mon Jun 10 20:37:48 CEST 2019
2019-06-12 06:30:04,696 [Thread-27] INFO  com.openkm.util.MailUtils- Sent: Mon Jun 10 20:37:43 CEST 2019
2019-06-12 06:30:05,285 [Thread-27] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1366, SQLState: 22001
2019-06-12 06:30:05,285 [Thread-27] ERROR org.hibernate.util.JDBCExceptionReporter- Data truncation: Incorrect string value: '\xF0\x9F\x94\xA5 1...' for column 'NBS_NAME' at row 1
2019-06-12 06:30:05,287 [Thread-27] ERROR com.openkm.core.UserMailImporter- Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:106)
        at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:139)
        at com.openkm.module.db.DbMailModule.create(DbMailModule.java:123)
        at com.openkm.util.MailUtils.importMail(MailUtils.java:801)
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:607)
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2420)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2875)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
        at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:90)
        ... 22 more
Caused by: java.sql.BatchUpdateException: Data truncation: Incorrect string value: '\xF0\x9F\x94\xA5 1...' for column 'NBS_NAME' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1454)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 37 more
...and the corresponding mail cannot be uploaded here (the board apparently doesn't allow ascii files). These are the mail headers:

Code: Select all

Delivery-date: Mon, 10 Jun 2019 20:37:48 +0200
Received: from [80.67.29.52] (helo=mx02.ispgateway.de)
	by mailcluster2-2.ispgateway.de with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256)
	(Exim 4.90_1)
	(envelope-from <bounces-486388965914457474@explore.pinterest.com>)
	id 1haPAy-0005LH-3j; Mon, 10 Jun 2019 20:37:48 +0200
Return-path: <bounces-486388965914457474@explore.pinterest.com>
X-Envelope-to: XXXXX@XXXXX.de
Received: from [34.213.58.68] (helo=outbound-58-68.usw2.aws.post.pinterest.com)
	by mx02.ispgateway.de with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128)
	(Exim 4.92)
	(envelope-from <bounces-486388965914457474@explore.pinterest.com>)
	id 1haPAw-0005xl-Uy
	for XXXXX@XXXXX.de; Mon, 10 Jun 2019 20:37:47 +0200
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=explore.pinterest.com; s=s0315; t=1560191863;
	i=@explore.pinterest.com;
	bh=Dsu9TFzxkg/yDLVmFVLnD6o8hhnow4yGAQcZJj3UKZw=;
	h=To:Message-ID:Date:Content-Type:From:Subject;
	b=NWjlmGEVEl0S3dQMHlL0vo7dWCN409zGjoYZecTCyvadxh6biW4NaMRqUTEV5/3WU
	 Q2PdEsvZoRRhLv+1DRS0Hp/po02KtXwpd6KzcNvbxqCeEcNM8p4yuMj5/1VHTXwLua
	 oeJvXSZ8M99Gmj0S+37s9+eUmjfrc0uC7j4WxV1E=
X-MSFBL: ILlO3xpwsZQNXmOCZ5Re/TRhoXgiNEVTlTv2gS+TG+8=|eyJtZXNzYWdlX2lkIjo
	iMDAxYjc3YTNmZTVjM2E0ZTdjZWMiLCJjdXN0b21lcl9pZCI6IjEiLCJyIjoibWF
	0dGhpYXNAZmphbGFyLmRlIiwic3ViYWNjb3VudF9pZCI6IjAiLCJ0ZW5hbnRfaWQ
	iOiJwaW50ZXJlc3QifQ==
To: "XXXXX XXXXX" <XXXXX@XXXXX.de>
Message-ID: <C7.CE.20026.773AEFC5@aa.mta4vrest.cc.prd.sparkpost>
Date: Mon, 10 Jun 2019 18:37:43 +0000
Content-Type: multipart/alternative; boundary="_----t/pwD1HL08Lyhi//P3Qy6g===_67/CE-20026-773AEFC5"
MIME-Version: 1.0
Reply-To: recommendations@reply.pinterest.com
From: "=?utf-8?q?Pinterest?=" <recommendations@explore.pinterest.com>
Subject: =?utf-8?q?=F0=9F=94=A5_18_beliebte_Pins_f=C3=BCr_dich?=
Feedback-ID: POPULAR_PINS:explore:pinterest
List-Unsubscribe: <mailto:unsubscribe@post.pinterest.com?subject=unsubscribe:RqCntaYRepEA9R70ruOCQ4oMAa4eTFNALhw31Gai84w~|eyAicmNwdF90byI6ICJtYXR0aGlhc0BmamFsYXIuZGUiLCAidGVuYW50X2lkIjogInBpbnRlcmVzdCIsICJjdXN0b21lcl9pZCI6ICIxIiwgInN1YmFjY291bnRfaWQiOiAiMCIsICJtZXNzYWdlX2lkIjogIjAwMWI3N2EzZmU1YzNhNGU3Y2VjIiB9>
List-Id: <pinterest.1.0.sparkpostmail.com>
X-Received-SPF: pass ( mx02.ispgateway.de: domain of explore.pinterest.com designates 34.213.58.68 as permitted sender )
X-DKIM: DKIM passed: (address=bounces-486388965914457474@explore.pinterest.com domain=explore.pinterest.com), signature is good.
X-DKIM: DKIM passed: (address=bounces-486388965914457474@explore.pinterest.com domain=@explore.pinterest.com), signature is good.
X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on
	spamfilter12.ispgateway.de
X-Spam-Level: *
X-Spam-Status: No, hits=1.2 required=9999.0 tests=BAYES_50,HTML_IMAGE_RATIO_02 autolearn=disabled
	version=3.4.0
X-Spam-CMAETAG: v=2.2 cv=eeBNR/MH c=1 sm=1 tr=0
	a=E+tKVs2gyF2THkFW/nijYw==:17 a=dq6fvYVFJ5YA:10 a=-uNXE31MpBQA:10
	a=FWQvqW7FNGEA:10 a=OjmdU3R2H1IA:10 a=sS8pAsIuAAAA:8
	a=BD_VQn_PF3eLVwSIA6sA:9 a=QEXdDO2ut3YA:10 a=SSmOFEACAAAA:8
	a=PMt8YJBkAAAA:8 a=zubVtbFFvf4xVUubtfoA:9 a=lN3xYVrEKZj3TZzt:21
	a=_W_S_7VecoQA:10 a=frz4AuCg-hUA:10
X-Spam-CMAECATEGORY: 
X-Spam-CMAESUBCATEGORY: 
X-Spam-CMAESCORE: 
The .eml-File is available (note to self: "error" on my desktop).

I strongly suspect the "fancy character" in the Subject: line to be the culprit. All mails that ever through mail import errors had such a character in their subject.

Post Reply