OX 6.5 beta 7 funambol - Contacts sync problem

[svensen]

Hi there,

after upgrading from beta4 to beta7, I'm having trouble with the funambol ox-connector.
Contacts and Tasks still work very well, but calendar sync doesn't. All i get is an error message saying "the sync could not be performed" and this in /opt/Funambol/logs/ds-server/ds-server.log

[2008-07-11 23:27:13,505] [funambol.engine] [INFO] [81AAF692CEDADE99BA6737A543194F96] [fwm-006030037193F5173] [testuser] [] Starting synchronization ...
[2008-07-11 23:27:13,509] [funambol.engine.strategy] [INFO] [81AAF692CEDADE99BA6737A543194F96] [fwm-006030037193F5173] [testuser] [oxscal] Preparing slow synchronization
[2008-07-11 23:27:13,509] [funambol.engine.strategy] [INFO] [81AAF692CEDADE99BA6737A543194F96] [fwm-006030037193F5173] [testuser] [oxscal] Last call
[2008-07-11 23:27:13,513] [funambol.engine] [ERROR] [81AAF692CEDADE99BA6737A543194F96] [fwm-006030037193F5173] [testuser] [oxscal] Error preparing slow sync
com.funambol.framework.engine.source.SyncSourceException: Error retrieving all item keys. 
        at com.funambol.ox.engine.source.OXCalendarSyncSource.getAllSyncItemKeys(OXCalendarSyncSource.java:413)
        at com.funambol.server.engine.Sync4jStrategy.prepareSlowSync(Sync4jStrategy.java:268)
        at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:622)
        at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1667)
        at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1520)
        at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:961)
        at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:517)
        at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:514)
        at com.funambol.server.engine.SyncAdapter.processXMLMessage(SyncAdapter.java:243)
        at com.funambol.transport.http.server.LocalSyncHolder.processXMLMessage(LocalSyncHolder.java:97)
        at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:382)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:115)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.funambol.ox.exception.EntityException: Error handling date in the get all method.
        at com.funambol.ox.items.manager.OXCalendarManager.getAllItems(OXCalendarManager.java:480)
        at com.funambol.ox.engine.source.OXCalendarSyncSource.getAllSyncItemKeys(OXCalendarSyncSource.java:410)
        ... 29 more
Caused by: com.funambol.ox.exception.EntityException: Error while getting all items.
        at com.funambol.ox.items.manager.OXEntityManager.getAllItems(OXEntityManager.java:485)
        at com.funambol.ox.items.manager.OXCalendarManager.getAllItems(OXCalendarManager.java:478)
        ... 30 more
Caused by: com.funambol.ox.exception.OXAccessException: JSONArray[4] is not a number.
        at com.funambol.ox.items.dao.OXEntityDAO.getAllItems(OXEntityDAO.java:1266)
        at com.funambol.ox.items.manager.OXEntityManager.getAllItems(OXEntityManager.java:481)
        ... 31 more
Caused by: org.json.JSONException: JSONArray[4] is not a number.
        at org.json.JSONArray.getDouble(JSONArray.java:216)
        at org.json.JSONArray.getInt(JSONArray.java:233)
        at com.funambol.ox.items.dao.OXEntityDAO.getAllItems(OXEntityDAO.java:1190)
        ... 32 more
[2008-07-11 23:27:13,517] [funambol.engine] [INFO] [81AAF692CEDADE99BA6737A543194F96] [fwm-006030037193F5173] [testuser] [] fwm-006030037193F5173/testuser: synchronization completed

Calendar sync did work back in beta4. I have tested this with several test accounts and several devices. Even if there is no data at all to sync (both the ox-account and the device cleared), the error occurs.

Any ideas on hot to get it working again?

thanks in advance
sven

[svensen]

Got it working again

Got it working again - but for how long?

There was an appointment in one other user's calendar in 2020 that broke calendar sync for every user

I will continue on testing this sync thing and post my experiences later on.

Any of you using funambol? How does it work for you?

[Martin Heiland]

Hi Sven,

thank you very very much for reporting this. It seems that there is a little API change in Beta7
which causing problems with the Funambol connector. I already opened a bug for this one and
hope that there is fast response by the funambol guys.

Thanks!

[svensen]

Hi Martin,

that's both, good and bad news. I'll have to wait, then.

Regarding my last post, calendar sync is now broken again for me, seems the only reliable way at this stage is to sync empty calendars

All the best
Sven

[hendrikp]

Hi Guys,

anything new regarding this issue? Using Funambol 6.5 seems still to be broken while syncing calendars and 7.0 does not seem to work in general.

[svensen]

Hi hendrikp,

the latest Funambol 7 will work woth ox-connector 7.0.5. Setting it up is a PITA because virtually no documentation exists (manual is still v 6.5).