Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

6.2.2 CE Mailimport dont work

https://forum.openkm.com/viewtopic.php?t=9229

Page 1 of 1

6.2.2 CE Mailimport dont work

PostPosted:Thu Jan 31, 2013 8:17 pm
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

PostPosted:Sat Feb 02, 2013 6:45 pm
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

PostPosted:Sun Feb 03, 2013 9:52 am
by wolfgang5505
Thank you for your quick answer,
I will try the nightly next week.

Greetings
Wolfgang

Re: 6.2.2 CE Mailimport dont work

PostPosted:Sun Feb 03, 2013 3:38 pm
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

PostPosted:Mon Feb 04, 2013 7:06 pm
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

PostPosted:Sat Feb 09, 2013 11:52 am
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

PostPosted:Wed Mar 06, 2013 6:03 pm
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

PostPosted:Fri Mar 08, 2013 5:53 pm
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.

Re: 6.2.2 CE Mailimport dont work

PostPosted:Tue Jun 18, 2013 5:04 am
by piotrzurek
Hello, I had the same bug in my repository. This fixed this and I just wanted to say You guys ROCK! :D

Re: 6.2.2 CE Mailimport dont work

PostPosted:Tue Jun 18, 2013 8:36 am
by pavila
8)
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited