Online demo
Download
Contact

Because information matters

  • 6.2.2 CE Mailimport dont work

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
It is currently Mon Apr 20, 2026 12:11 am

6.2.2 CE Mailimport dont work

OpenKM has many interesting features, but requires some configuration process to show its full potential.
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.
 Reply

6.2.2 CE Mailimport dont work

 #21206  by wolfgang5505
 
Hello
I am testing OpenKM 6.2.2 CE for our Company and all is working only mailimport from sereral providers don't work.
I get only some emails and catalina.out reports errors.

here are some errors:
Code: Select all
2013-01-31 21:00:00,678 [Thread-14] INFO  com.openkm.util.MailUtils - 0: Nadia Pereda <kay0112simser@yahoo.com> Good day, I'm Nadia! text/plain; charset=utf-8
2013-01-31 21:00:00,678 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:00:00,679 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Fri Nov 09 17:21:43 CET 2012
2013-01-31 21:00:01,292 [Thread-14] INFO  com.openkm.module.db.stuff.SetFieldBridge - Added field 'to' with value '"warcraft88@wp.pl" <warcraft88@wp.pl>'
2013-01-31 21:00:01,440 [Thread-14] INFO  com.openkm.util.MailUtils - 1: "onlyparty.de" <mailreply@onlyparty.de> onlyparty_27067 hat heute Geburtstag! multipart/alternative;
	boundary="b1_b3645dc9f5ff13da82700b4423689f75"
2013-01-31 21:00:01,440 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:00:01,441 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 02:47:36 CET 2012
2013-01-31 21:00:01,681 [Thread-14] INFO  com.openkm.module.db.stuff.SetFieldBridge - Added field 'to' with value 'onlyparty_15701 <jonas.bucher@netland-mn.de>'
2013-01-31 21:00:01,818 [Thread-14] INFO  com.openkm.util.MailUtils - 2: Geldsparer <geldsparer@webincentives.de> Ihre Goldkarte mit vielen Vorzügen - ganz ohne Jahresgebühr! multipart/alternative;
  boundary="--1211101056222S.01250.Texte--"
2013-01-31 21:00:01,819 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:00:01,819 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 10:56:22 CET 2012
2013-01-31 21:00:02,023 [Thread-14] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1406, SQLState: 22001
2013-01-31 21:00:02,023 [Thread-14] ERROR org.hibernate.util.JDBCExceptionReporter - Data truncation: Data too long for column 'NML_CONTENT' at row 1
2013-01-31 21:00:02,024 [Thread-14] ERROR com.openkm.core.UserMailImporter - could not insert: [com.openkm.dao.bean.NodeMail]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.NodeMail]
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:97)
	at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:107)
	at com.openkm.module.db.DbMailModule.create(DbMailModule.java:104)
	at com.openkm.util.MailUtils.importMail(MailUtils.java:649)
	at com.openkm.util.MailUtils.importMessages(MailUtils.java:572)
	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:601)
	at bsh.Reflect.invokeOnMethod(Unknown Source)
	at bsh.Reflect.invokeObjectMethod(Unknown Source)
	at bsh.BSHPrimarySuffix.doName(Unknown Source)
	at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
	at bsh.BSHPrimaryExpression.eval(Unknown Source)
	at bsh.BSHPrimaryExpression.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	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:722)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.NodeMail]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2455)
	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:317)
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:81)
	... 22 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'NML_CONTENT' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3560)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2438)
	... 34 more
2013-01-31 21:04:47,184 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.core.UserMailImporter - *** User mail importer activated ***
2013-01-31 21:04:47,196 [http-bio-0.0.0.0-8080-exec-9] ERROR com.openkm.util.MailUtils - Verbindungsaufbau abgelehnt
javax.mail.MessagingException: Verbindungsaufbau abgelehnt;
  nested exception is:
	java.net.ConnectException: Verbindungsaufbau abgelehnt
	at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:665)
	at javax.mail.Service.connect(Service.java:295)
	at javax.mail.Service.connect(Service.java:176)
	at com.openkm.util.MailUtils.importMessages(MailUtils.java:509)
	at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
	at com.openkm.servlet.admin.MailAccountServlet.doPost(MailAccountServlet.java:134)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:722)
Caused by: java.net.ConnectException: Verbindungsaufbau abgelehnt
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:288)
	at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:231)
	at com.sun.mail.iap.Protocol.<init>(Protocol.java:113)
	at com.sun.mail.imap.protocol.IMAPProtocol.<init>(IMAPProtocol.java:110)
	at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:632)
	... 46 more
2013-01-31 21:04:47,634 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - 0: Nadia Pereda <kay0112simser@yahoo.com> Good day, I'm Nadia! text/plain; charset=utf-8
2013-01-31 21:04:47,634 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:04:47,635 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Sent: Fri Nov 09 17:21:43 CET 2012
2013-01-31 21:04:47,906 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - 1: "onlyparty.de" <mailreply@onlyparty.de> onlyparty_27067 hat heute Geburtstag! multipart/alternative;
	boundary="b1_b3645dc9f5ff13da82700b4423689f75"
2013-01-31 21:04:47,906 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:04:47,906 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 02:47:36 CET 2012
2013-01-31 21:04:48,140 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - 2: Geldsparer <geldsparer@webincentives.de> Ihre Goldkarte mit vielen Vorzügen - ganz ohne Jahresgebühr! multipart/alternative;
  boundary="--1211101056222S.01250.Texte--"
2013-01-31 21:04:48,141 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:04:48,141 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 10:56:22 CET 2012
2013-01-31 21:04:48,406 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - 3: "Karsten H." <donotreply@itkm.ru> Aktuelle Gewinner im SP Casino   text/plain; charset=iso-8859-1
2013-01-31 21:04:48,406 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:04:48,407 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 17:40:59 CET 2012
2013-01-31 21:04:48,575 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.module.db.stuff.SetFieldBridge - Added field 'to' with value 'jonas.bucher@netland-mn.de'
2013-01-31 21:04:48,576 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.module.db.stuff.SetFieldBridge - Added field 'cc' with value 'wolfgang.bucher@netland-mn.de'
2013-01-31 21:04:48,697 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - 4: Maxim EE-Mail <maxim-eemail-notifier@blast.maximintegrated.com> Maxim EE-Mail #12.45 - November 10, 2012 text/html; charset="utf-8"
2013-01-31 21:04:48,697 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Received: null
2013-01-31 21:04:48,697 [http-bio-0.0.0.0-8080-exec-9] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 20:12:07 CET 2012
2013-01-31 21:04:48,896 [http-bio-0.0.0.0-8080-exec-9] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 1406, SQLState: 22001
2013-01-31 21:04:48,896 [http-bio-0.0.0.0-8080-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - Data truncation: Data too long for column 'NML_CONTENT' at row 1
2013-01-31 21:04:48,898 [http-bio-0.0.0.0-8080-exec-9] ERROR com.openkm.core.UserMailImporter - could not insert: [com.openkm.dao.bean.NodeMail]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.NodeMail]
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:97)
	at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:107)
	at com.openkm.module.db.DbMailModule.create(DbMailModule.java:104)
	at com.openkm.util.MailUtils.importMail(MailUtils.java:649)
	at com.openkm.util.MailUtils.importMessages(MailUtils.java:572)
	at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
	at com.openkm.servlet.admin.MailAccountServlet.doPost(MailAccountServlet.java:134)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:722)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.NodeMail]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2455)
	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:317)
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:81)
	... 47 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'NML_CONTENT' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3560)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
Thank You

PS: very good software !!!!!!

Re: 6.2.2 CE Mailimport dont work

 #21226  by jllort
 
I think could be some bug in 6.2.2, can you try latest nightly build at integration.openkm.com ( I'm not sure but some database problems like similar than this are already solved there ).

Re: 6.2.2 CE Mailimport dont work

 #21237  by wolfgang5505
 
Hello
I have done a fresh install with openkvm 6.2.3-dev but i seems to be the same error again:
Code: Select all
2013-02-03 16:27:32,203 [http-bio-0.0.0.0-8080-exec-2] INFO  com.openkm.util.MailUtils - 2: Geldsparer <geldsparer@webincentives.de> Ihre Goldkarte mit vielen Vorzügen - ganz ohne Jahresgebühr! multipart/alternative;
  boundary="--1211101056222S.01250.Texte--"
2013-02-03 16:27:32,203 [http-bio-0.0.0.0-8080-exec-2] INFO  com.openkm.util.MailUtils - Received: null
2013-02-03 16:27:32,204 [http-bio-0.0.0.0-8080-exec-2] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 10:56:22 CET 2012
2013-02-03 16:27:32,386 [http-bio-0.0.0.0-8080-exec-2] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: -3401, SQLState: 22001
2013-02-03 16:27:32,386 [http-bio-0.0.0.0-8080-exec-2] ERROR org.hibernate.util.JDBCExceptionReporter - data exception: string data, right truncation
2013-02-03 16:27:32,387 [http-bio-0.0.0.0-8080-exec-2] ERROR com.openkm.core.UserMailImporter - could not insert: [com.openkm.dao.bean.NodeMail]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.NodeMail]
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:97)
	at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:107)
	at com.openkm.module.db.DbMailModule.create(DbMailModule.java:104)
	at com.openkm.util.MailUtils.importMail(MailUtils.java:649)
	at com.openkm.util.MailUtils.importMessages(MailUtils.java:572)
	at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:95)
	at com.openkm.servlet.admin.MailAccountServlet.doPost(MailAccountServlet.java:134)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:722)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.NodeMail]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2455)
	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:317)
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:81)
	... 47 more
Caused by: java.sql.SQLDataException: data exception: string data, right truncation
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2438)
	... 59 more
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)
	at org.hsqldb.types.CharacterType.convertToType(Unknown Source)
	at org.hsqldb.StatementDML.getInsertData(Unknown Source)
	at org.hsqldb.StatementInsert.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 64 more
2013-02-03 16:30:00,099 [Thread-14] INFO  com.openkm.core.UserMailImporter - *** User mail importer activated ***
2013-02-03 16:30:00,675 [Thread-14] INFO  com.openkm.util.MailUtils - 0: Nadia Pereda <kay0112simser@yahoo.com> Good day, I'm Nadia! text/plain; charset=utf-8
2013-02-03 16:30:00,676 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-02-03 16:30:00,678 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Fri Nov 09 17:21:43 CET 2012
2013-02-03 16:30:01,021 [Thread-14] INFO  com.openkm.util.MailUtils - 1: "onlyparty.de" <mailreply@onlyparty.de> onlyparty_27067 hat heute Geburtstag! multipart/alternative;
	boundary="b1_b3645dc9f5ff13da82700b4423689f75"
2013-02-03 16:30:01,021 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-02-03 16:30:01,022 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 02:47:36 CET 2012
2013-02-03 16:30:01,300 [Thread-14] INFO  com.openkm.util.MailUtils - 2: Geldsparer <geldsparer@webincentives.de> Ihre Goldkarte mit vielen Vorzügen - ganz ohne Jahresgebühr! multipart/alternative;
  boundary="--1211101056222S.01250.Texte--"
2013-02-03 16:30:01,301 [Thread-14] INFO  com.openkm.util.MailUtils - Received: null
2013-02-03 16:30:01,301 [Thread-14] INFO  com.openkm.util.MailUtils - Sent: Sat Nov 10 10:56:22 CET 2012
2013-02-03 16:30:01,472 [Thread-14] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: -3401, SQLState: 22001
2013-02-03 16:30:01,473 [Thread-14] ERROR org.hibernate.util.JDBCExceptionReporter - data exception: string data, right truncation
2013-02-03 16:30:01,473 [Thread-14] ERROR com.openkm.core.UserMailImporter - could not insert: [com.openkm.dao.bean.NodeMail]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.NodeMail]
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:97)
	at com.openkm.module.db.base.BaseMailModule.create(BaseMailModule.java:107)
	at com.openkm.module.db.DbMailModule.create(DbMailModule.java:104)
	at com.openkm.util.MailUtils.importMail(MailUtils.java:649)
	at com.openkm.util.MailUtils.importMessages(MailUtils.java:572)
	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:601)
	at bsh.Reflect.invokeOnMethod(Unknown Source)
	at bsh.Reflect.invokeObjectMethod(Unknown Source)
	at bsh.BSHPrimarySuffix.doName(Unknown Source)
	at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
	at bsh.BSHPrimaryExpression.eval(Unknown Source)
	at bsh.BSHPrimaryExpression.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	at bsh.Interpreter.eval(Unknown Source)
	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:722)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.NodeMail]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2455)
	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:317)
	at com.openkm.dao.NodeMailDAO.create(NodeMailDAO.java:81)
	... 22 more
Caused by: java.sql.SQLDataException: data exception: string data, right truncation
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2438)
	... 34 more
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)
	at org.hsqldb.types.CharacterType.convertToType(Unknown Source)
	at org.hsqldb.StatementDML.getInsertData(Unknown Source)
	at org.hsqldb.StatementInsert.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 39 more
Greetings
Wolfgang

Re: 6.2.2 CE Mailimport dont work

 #21246  by jllort
 
Ok seems in community this problem is still not solved:
Code: Select all
com.openkm.util.MailUtils - Received: null
Basically some mail server ( is a microsoft exchange server ? ) allows some null mail fields ( that should not be, like from etc... ) and in community is still not yet applied the patch to solve it. I fyou take a look on the mail you'r trying to import you'll observate some parameter is null ( could from, to, creation date, subject some of these ) and that causes the error.

Re: 6.2.2 CE Mailimport dont work

 #21304  by pavila
 
I see the error is related to "data exception: string data, right truncation".

I have fixed it in OpenKM Community and should be available in the next night build. Also updated the Migration Guide, to take a look because have info related to this fix (the alter table stuff)

Re: 6.2.2 CE Mailimport dont work

 #21618  by wolfgang5505
 
Hello
sorry for my late reply but i was out of office.
Mailimport now works fine thank you.
But now there is another problem searching in email. If i search for one word i get for example 7 results on the right window, but the lower window is empty.
In the professional trial all works fine.
Tested with the latest nighly.
Greetings
Wolfgang

Re: 6.2.2 CE Mailimport dont work

 #21636  by jllort
 
Please post the problem in other post, do not merge several question on same post because that generate confusion to other readers, thanks.
 Reply
 Return to “Configuration”

Favorites

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.

Powered By phpBB -
 ©OpenKM 2021
 - All times are UTC -