I am looking into a migration to Zimbra, and have come across a problem accessing Exchange through Zimbra IMAP. It seems that one of the Exchange public folders has a very long name, and I get:

msg: system failure: Unable to store IMAP message data
code: service.FAILURE
method: ImportDataRequest
detail: soap:Receiver
trace:com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:183)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:108)
at com.zimbra.cs.datasource.ImapImport.importData(Ima pImport.java:263)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:149)
at com.zimbra.cs.service.mail.ImportData.handle(Impor tData.java:62)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:342)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:208)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:113)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:272)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:174)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1093)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: com.mysql.jdbc.exceptions.MySQLDataException: Data truncation: Out of range value adjusted for column 'uid_validity' at row 1

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[210] - INSERT INTO mboxgroup4.imap_folder (mailbox_id, item_id, data_source_id, local_path, remote_path, uid_validity)

I am pretty sure that it's either a strange character that someone named one of the folders or a folder name that's too long. I would appreciate any known work-arounds, from changing a zimbra/mysql setting, or at least a way to filter/ignore certain folders in IMAP.

Thank you in advance!

David Thomson