Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 6 of 6
  1. #1
    wjlabs Guest

    Default Active Sync Errors

    Hi,

    I'm having issues with Active Sync in a server running OX 6.16.1 rev8.
    I'm using AstraSync to simulate Active sync in a Blackberry 9000.
    When I try to sync folders I get an error in the device "error cr: error 11 syncing folders."

    On the server side, I see this error

    SQL error while retrieving persistent data from DB
    [...]
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: Unknown
    column 'id' in 'where clause'


    Entire log entry below

    SEVERE: null 1:4:user@domain:EAS:MlStAA98199C424CA188E5A8C505C9 23
    SQL error while retrieving persistent data from DB
    30000c: com.openexchange.usm.api.exceptions.USMSQLExceptio n:
    1:4:user@domain:EAS:MlStAA98199C424CA188E5A8C505C9 23 SQL error while
    retrieving persistent data from DB
    at
    com.openexchange.usm.session.impl.PersistentSessio nData.readPersistentData(PersistentSessionData.jav a:454)
    at
    com.openexchange.usm.session.impl.PersistentSessio nData.initialize(PersistentSessionData.java:365)
    at
    com.openexchange.usm.session.impl.SessionImpl.init ialize(SessionImpl.java:159)
    at
    com.openexchange.usm.session.impl.SessionManagerIm pl.getSession(SessionManagerImpl.java:258)
    at
    com.openexchange.usm.session.impl.SessionManagerSe rvice.getSession(SessionManagerService.java:76)
    at
    com.openexchange.usm.eas.servlet.EASServlet.handle Request(EASServlet.java:449)
    at
    com.openexchange.usm.eas.servlet.EASServlet.doPost (EASServlet.java:350)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at
    com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 504)
    at
    com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:129)
    at
    com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:31 6)
    at
    com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:207)
    at com.openexchange.ajp13.najp.AJPv13Task.call(AJPv13 Task.java:346)
    at
    java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:269)
    at java.util.concurrent.FutureTask.run(FutureTask.jav a:123)
    at
    com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:737)
    at
    com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:763)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: Unknown
    column 'id' in 'where clause'
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1026)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3491)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
    at
    com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
    at
    com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1885)
    at
    com.openexchange.database.internal.wrapping.Prepar edStatementWrapper.executeQuery(PreparedStatementW rapper.java:103)
    at
    com.openexchange.usm.session.impl.PersistentSessio nData.readPersistentData(PersistentSessionData.jav a:409)
    ... 18 more
    Aug 21, 2010 5:27:56 PM com.openexchange.usm.eas.servlet.EASServlet
    logResponse
    FINE: No session: FolderSync executed in 402 ms.

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi,

    it seems like the database has not been updated correctly. Prior to 6.16 some manual interaction was required:

    http://www.open-xchange.com/forum/sh...8193&post18193

    Has the system been set up recently or has it been updated? Please check if the open-xchange-usm and open-xchange-eas packages are installed.

    Greetings

  3. #3
    wjlabs Guest

    Default

    This system was updated from version 6.14 to 6.16.

    When we tried to run the commands that were recommended in that thread, here's what we received back:


    root@ox:~# /opt/open-xchange/sbin/forceupdatetask -t com.openexchange.usm.database.ox.USMTablesUpdateTa sk
    /opt/open-xchange ~
    Unexpected error: UPD-0015 Category=1 Message=Error loading update task "com.openexchange.usm.database.ox.USMTablesUpdateT ask". exceptionID=1211400587-1898

    root@ox:~# /opt/open-xchange/sbin/forceupdatetask -t com.openexchange.usm.database.ox.USMClearTablesUpd ateTask
    /opt/open-xchange ~
    Unexpected error: UPD-0015 Category=1 Message=Error loading update task "com.openexchange.usm.database.ox.USMClearTablesUp dateTask".
    exceptionID=1211400587-1899

    root@ox:~# /opt/open-xchange/sbin/forceupdatetask -t com.openexchange.usm.database.ox.USMUUIDTablesUpda teTask
    /opt/open-xchange ~
    Unexpected error: UPD-0015 Category=1 Message=Error loading update task "com.openexchange.usm.database.ox.USMUUIDTablesUpd ateTask".
    exceptionID=1211400587-1900

    root@ox:~# /opt/open-xchange/sbin/forceupdatetask -t com.openexchange.usm.database.ox.USMClearTablesUpd ateTask93
    /opt/open-xchange ~
    Unexpected error: UPD-0015 Category=1 Message=Error loading update task "com.openexchange.usm.database.ox.USMClearTablesUp dateTask93".
    exceptionID=1211400587-1901


    Is there any special step that we need to follow in order to update active sync and that might not be documented in the mobility installation guideline (http://oxpedia.org/index.php?title=O...lation_Guide)?

  4. #4
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Well, the update process should run smoothly after 6.16. Could it be that some packages have not been updated? Please post a list of all installed OX packages.

  5. #5
    wjlabs Guest

    Default

    root@ox:~# dpkg --list | grep open-x | awk '{print $2 "\t" $3}'
    open-xchange 6.16.1.0-8
    open-xchange-activation 1.1.1-26
    open-xchange-admin 6.16.1.0-4
    open-xchange-admin-client 6.16.1.0-4
    open-xchange-admin-doc 6.16.1.0-4
    open-xchange-admin-lib 6.16.1.0-4
    open-xchange-admin-plugin-contextrestore 6.16.1.0-4
    open-xchange-admin-plugin-hosting 6.16.1.0-4
    open-xchange-admin-plugin-hosting-client 6.16.1.0-4
    open-xchange-admin-plugin-hosting-doc 6.16.1.0-4
    open-xchange-admin-plugin-hosting-lib 6.16.1.0-4
    open-xchange-admin-soap 6.16.1.0-4
    open-xchange-authentication-imap 6.16.1.0-4
    open-xchange-axis2 6.16.1.0-4
    open-xchange-cache 6.16.1.0-4
    open-xchange-calendar 6.16.1.0-4
    open-xchange-charset 6.16.1.0-4
    open-xchange-common 6.16.1.0-4
    open-xchange-configjump-generic 6.16.1.0-4
    open-xchange-configread 6.16.1.0-4
    open-xchange-contactcollector 6.16.1.0-4
    open-xchange-control 6.16.1.0-4
    open-xchange-conversion 6.16.1.0-4
    open-xchange-conversion-engine 6.16.1.0-4
    open-xchange-conversion-servlet 6.16.1.0-4
    open-xchange-crypto 6.16.1.0-4
    open-xchange-data-conversion-ical4j 6.16.1.0-4
    open-xchange-dataretention 6.16.1.0-4
    open-xchange-dataretention-csv 6.16.1.0-4
    open-xchange-eas 6.16.1.0-2
    open-xchange-easylogin 6.16.1.0-6
    open-xchange-genconf 6.16.1.0-4
    open-xchange-genconf-mysql 6.16.1.0-4
    open-xchange-global 6.16.1.0-4
    open-xchange-group-managerequest 6.16.1.0-4
    open-xchange-gui 6.16.1.0-4
    open-xchange-gui-mobile 1.0.0-28
    open-xchange-gui-themes-default 6.16.1.0-4
    open-xchange-help-usm-eas 6.16.0.0-6
    open-xchange-i18n 6.16.1.0-4
    open-xchange-imap 6.16.1.0-4
    open-xchange-jcharset 1.3.0-64
    open-xchange-lang-es-es 6.16.1.0-4
    open-xchange-log4j 6.16.1.0-4
    open-xchange-mailfilter 6.16.1.0-5
    open-xchange-management 6.16.1.0-4
    open-xchange-messaging 6.16.1.0-4
    open-xchange-meta-mobility 6.16.1.0-6
    open-xchange-monitoring 6.16.1.0-4
    open-xchange-online-help-de 6.16.1.0-4
    open-xchange-online-help-en 6.16.1.0-4
    open-xchange-online-help-fr 6.16.1.0-4
    open-xchange-passwordchange-database 6.16.1.0-4
    open-xchange-passwordchange-script 6.16.1.0-4
    open-xchange-passwordchange-servlet 6.16.1.0-4
    open-xchange-pop3 6.16.1.0-4
    open-xchange-publish 6.16.1.0-4
    open-xchange-publish-basic 6.16.1.0-4
    open-xchange-publish-infostore-online 6.16.1.0-4
    open-xchange-publish-json 6.16.1.0-4
    open-xchange-publish-microformats 6.16.1.0-4
    open-xchange-push 6.16.1.0-4
    open-xchange-push-udp 6.16.1.0-4
    open-xchange-report-client 6.16.1.0-4
    open-xchange-resource-managerequest 6.16.1.0-4
    open-xchange-server 6.16.1.0-8
    open-xchange-sessiond 6.16.1.0-6
    open-xchange-settings-extensions 6.16.1.0-4
    open-xchange-smtp 6.16.1.0-4
    open-xchange-spamhandler-default 6.16.1.0-4
    open-xchange-sql 6.16.1.0-4
    open-xchange-subscribe 6.16.1.0-4
    open-xchange-subscribe-crawler 6.16.1.0-5
    open-xchange-subscribe-json 6.16.1.0-4
    open-xchange-subscribe-microformats 6.16.1.0-4
    open-xchange-templating 6.16.1.0-4
    open-xchange-themes-default 6.16.1.0-4
    open-xchange-threadpool 6.16.1.0-4
    open-xchange-unifiedinbox 6.16.1.0-4
    open-xchange-upsell-generic 6.16.1.0-4
    open-xchange-user-json 6.16.1.0-4
    open-xchange-usm 6.16.1.0-1
    open-xchange-xerces-sun 6.16.1.0-4
    open-xchange-xml 6.16.1.0-4

  6. #6
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    Hi,

    please check if there are any Server/Sync updates available, latest versions are
    EAS: 6.16.1.0-5
    USM: 6.16.1.0-4

    If that does not help, please contact the support to dig deeper at the issue.

    Greetings

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •