• Mail import error

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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.
 #42458  by MKochS
 
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
 #42474  by jllort
 
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.
 #42476  by MKochS
 
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).
 #42489  by jllort
 
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.
 #42501  by MKochS
 
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.
 #42502  by MKochS
 
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
 #42508  by jllort
 
Are similar errors caused by encoding but not exactly the same. Seems will be not possible to get the eml or msg ?
 #42513  by MKochS
 
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.
 #42518  by jllort
 
OK, we'll we waiting for it.
 #42519  by pavila
 
Can you reproduce this error in OpenKM 6.3.2 ?
 #48127  by MKochS
 
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.
 #48138  by jllort
 
Upgrade to version 6.3.7, between 6.3.2 and latest 6.3.7 we have solved some issues with emails.
 #48157  by MKochS
 
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
 #48178  by jllort
 
Can you share with us a mail sample to reproduce the issue from our side?
 #48188  by MKochS
 
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.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.