Hi,

Just recieving the following error from Zimbra client when connecting into mailenable mail server
Debug message: The resulting value is outside the range for the data type INTEGER.

Exception:

com.zimbra.common.service.ServiceException: system failure: Synchronization of folder 'INBOX' failed
ExceptionId:btpool0-2:1241455841296:3c0c6359414194f7
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:291)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:214)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:186)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:145)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:154)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:417)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:389)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:431)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:49)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:269)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:190)
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.handle(Se rvletHandler.java:362)
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:211)
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.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:btpool0-2:1241455841296:3c0c6359414194f7
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:111)
at com.zimbra.cs.account.DataSource.createImapFolder( DataSource.java:320)
at com.zimbra.cs.datasource.ImapSync.createFolderTrac ker(ImapSync.java:83)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:524)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:129)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:209)
... 34 more
Caused by: java.sql.SQLException: The resulting value is outside the range for the data type INTEGER.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateC hangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. setLong(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.setLong(DelegatingPreparedStatement.java:239)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:105)
... 39 more
Caused by: ERROR 22003: The resulting value is outside the range for the data type INTEGER.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.iapi.types.DataType.outOfRange(Un known Source)
at org.apache.derby.iapi.types.SQLInteger.setValue(Un known Source)
... 42 more

If issue persists please post description and debug information here.

Any Ideas?

J