IMAP Error 22003: The resulting value is outside the range for the data type INTEGER

[thomhoward]

I'm just trying Zimbra client for PC in the hopes I can get off Outlook. However, I can not get it to sync with my IMAP account. The message I get is below. The IMAP server is MailEnable 3.61

All help appreciated.

Thanks,

Thom

--------------------------------------------------------

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 'Spam' failed
ExceptionId:btpool0-11:1281471909890:1fbe129da933c748
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:298)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:221)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:193)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:152)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:157)
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:275)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
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-11:1281471909875:1fbe129da933c748
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:85)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:521)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:125)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:216)
... 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

[phoenix]

Originally Posted by thomhoward

I'm just trying Zimbra client for PC in the hopes I can get off Outlook. However, I can not get it to sync with my IMAP account. The message I get is below. The IMAP server is MailEnable 3.61

All help appreciated.

Which version of ZImbra Desktop is this? If it's not Zimbra Desktop 2 beta 4 then I'd suggest you install and try that, details are in the Zimbra Desktop forum announcement.

[thomhoward]

I can't see any obvious way of determining what version I've got from the desktop app, but I just downloaded it two days ago, so I would think it's the latest version.

Thanks again,

Thom

[phoenix]

Originally Posted by thomhoward

I can't see any obvious way of determining what version I've got from the desktop app,

Look at the name of the file you've downloaded or there's a 'gear wheel' in the bottom right of the GUI, click on that. If you have windows, click on teh systray icon.

Originally Posted by thomhoward

but I just downloaded it two days ago, so I would think it's the latest version.

Unless you've specifically downloaded the beta from the announcement p[age in these forums then I doubt you have the beta version.