Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2007-04-30T15:41:43Z by Stan
SystemAdmin
SystemAdmin
1525 Posts
ACCEPTED ANSWER

Pinned topic Derby synch with DB2 Everyplace - DSYC613E error

‏2007-04-28T18:03:32Z |
We have a derby database embedded in our application. We are trying to replicate the database with a network db2 database. So, I set up a DB2 8.2 and DB2 Everyplace 8.2 server on my machine. I set up a simple database, with one table, to test it with. I set up a mirror database. In DB2 Everyplace, I set up the subscription set and mapped the table to replicate. The data in the table replicates fine between the back-end database and the mirror database.

When I call the synch method in the code, I get the following error:
DSYC613E: Exception server error.
That's a pretty vague exception and I didn't find anything on the web to help me get any more detail. There were a couple problem reports on the error code, but they were for a previous release.

Here's more detail on from the print statements:
2007-04-27 19:31:33.156 0% DSYC1008I: Synchronizing subscription : test1
2007-04-27 19:31:33.156 0% DSYC1002I: Preparing message
2007-04-27 19:31:33.171 0% DSYC1003I: Sending message
2007-04-27 19:31:33.281 0% DSYC1002I: Preparing message
2007-04-27 19:31:33.281 0% DSYC1003I: Sending message
2007-04-27 19:10:36.625 0% DSYC613E: Exception server error.
2007-04-27 19:10:36.625 0% DSYC418E: Error server exception!!
2007-04-27 19:10:36.64 0% DSYC1013I: Synchronization failed
2007-04-27 19:10:36.64 0% DSYC5002Q: Inquery if user wants to continue with the synchronization or cancel
com.ibm.mobileservices.isync.ISyncException: 613
at com.ibm.mobileservices.isync.JavaCommonISync.syncRequest(JavaCommonISync.java:3595)
at com.ibm.mobileservices.isync.JavaCommonISync.syncSubscriptions(JavaCommonISync.java:2848)
at com.ibm.mobileservices.isync.JavaCommonISync.resume(JavaCommonISync.java:1810)
at com.ibm.mobileservices.isync.JavaCommonISync.sync(JavaCommonISync.java:1543)
...

And, the log has this:
java.lang.NullPointerException
at com.ibm.db2ess.engines.mdsp.ReqInfo.setInfoFromNonContent(ReqInfo.java:167)
at com.ibm.db2ess.engines.mdsp.ReqInfo.<init>(ReqInfo.java:102)
at com.ibm.db2ess.engines.mdsp.MdspEngine.process(MdspEngine.java:227)
at com.ibm.db2ess.transports.http.DB2eSyncServlet.doPost(DB2eSyncServlet.java:204)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
...

What I find expecially intersting about this is that I have deleted the subscription it is trying to synch (test1) because I messed it up the first time. It should not be trying to synch that subscription. I think the error is that it's trying to synch a subscription that doesn't exist anymore. I tried unconfiguring the Everyplace server and reconfiguring it, but that didn't work. I even uninstalled Everyplace and dropped the Everyplace databases from the DB2 server. But, after reinstalling it I still get this error.

I would really appreciate any suggestions you may have.
Updated on 2007-04-30T15:41:43Z at 2007-04-30T15:41:43Z by Stan
  • Stan
    Stan
    267 Posts
    ACCEPTED ANSWER

    Re: Derby synch with DB2 Everyplace - DSYC613E error

    ‏2007-04-30T15:41:43Z  in response to SystemAdmin
    Hi Steve -
    I see you have posted this issue on the DB2e forum http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=492&message=13947316&thread=161136&cat=19

    The error is from the sync server layer and best addressed by those folks - I don't see any Derby error codes (SQL Exceptions).