Announcement

Collapse
No announcement yet.

Active Sync Errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Hi,

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



    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

    Comment


    • #3
      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)?

      Comment


      • #4
        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.

        Comment


        • #5
          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

          Comment


          • #6
            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

            Comment

            Working...
            X