Skip to Content
author's profile photo
Former Member

DB2E Problem

Hi All,

Has anyone had a problem with DB2E and Smart Sync, here is my Trace file.

<b>[20050929 14:50:54:953] I [MI/API/Logging ] ***** LOG / TRACE SWITCHED ON

[20050929 14:50:54:953] I [MI/API/Logging ] ***** Mobile Engine version: MI 25 SP 13 Patch 00 Build 200507282032

[20050929 14:50:54:953] I [MI/API/Logging ] ***** Current timezone: America/New_York

[20050929 14:50:58:839] E [MI/Persistence ] java.sql.SQLException: [SQLState:23505, error code:-803]

java.sql.SQLException: [SQLState:23505, error code:-803]

at com.ibm.db2e.jdbc.DB2eError.(DB2eError.java:76)

at com.ibm.db2e.jdbc.DB2eStatement.executeSql(DB2eStatement.java:221)

at com.ibm.db2e.jdbc.DB2eStatement.executeUpdate(DB2eStatement.java:259)

at com.sap.ip.me.persist.jdbc.IPersistenceWriterImpl.execute(IPersistenceWriterImpl.java:228)

at com.sap.ip.me.persist.jdbc.IPersistenceWriterImpl.end(IPersistenceWriterImpl.java:119)

at com.sap.ip.me.smartsync.syncIn.processors.ProcessorChildAdd.finishWithWriter(ProcessorChildAdd.java:134)

at com.sap.ip.me.smartsync.syncIn.processors.RowProcessorManager$RowProcessorDispatcher.finish(RowProcessorManager.java:517)

at com.sap.ip.me.smartsync.syncIn.SaxSyncInProcessor$5.endElement(SaxSyncInProcessor.java:624)

at com.sap.ip.me.xmlParser.MIXMLEventHandlerManager.endElement(MIXMLEventHandlerManager.java:95)

at com.sap.ip.me.xmlParser.MIXMLParser$ElementParser.parse(MIXMLParser.java:525)

at com.sap.ip.me.xmlParser.MIXMLParser.parse(MIXMLParser.java:164)

at com.sap.ip.me.smartsync.syncIn.SaxSyncInProcessor.processSyncInMessage(SaxSyncInProcessor.java:87)

at com.sap.ip.me.smartsync.syncIn.SyncInRuntimeImpl.processSyncInMessage(SyncInRuntimeImpl.java:250)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:344)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

[20050929 14:50:58:839] E [MI/Persistence ] char processor: - error code: -803 SQL state: 23505 Message: [SQLState:23505, error code:-803]

[20050929 14:50:58:839] E [MI/Smartsync ] Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.persist.jdbc.IPersistenceWriterImpl.execute(IPersistenceWriterImpl.java:242)

at com.sap.ip.me.persist.jdbc.IPersistenceWriterImpl.end(IPersistenceWriterImpl.java:119)

at com.sap.ip.me.smartsync.syncIn.processors.ProcessorChildAdd.finishWithWriter(ProcessorChildAdd.java:134)

at com.sap.ip.me.smartsync.syncIn.processors.RowProcessorManager$RowProcessorDispatcher.finish(RowProcessorManager.java:517)

at com.sap.ip.me.smartsync.syncIn.SaxSyncInProcessor$5.endElement(SaxSyncInProcessor.java:624)

at com.sap.ip.me.xmlParser.MIXMLEventHandlerManager.endElement(MIXMLEventHandlerManager.java:95)

at com.sap.ip.me.xmlParser.MIXMLParser$ElementParser.parse(MIXMLParser.java:525)

at com.sap.ip.me.xmlParser.MIXMLParser.parse(MIXMLParser.java:164)

at com.sap.ip.me.smartsync.syncIn.SaxSyncInProcessor.processSyncInMessage(SaxSyncInProcessor.java:87)

at com.sap.ip.me.smartsync.syncIn.SyncInRuntimeImpl.processSyncInMessage(SyncInRuntimeImpl.java:250)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:344)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

Caused by: java.sql.SQLException: [SQLState:23505, error code:-803]

at com.ibm.db2e.jdbc.DB2eError.(DB2eError.java:76)

at com.ibm.db2e.jdbc.DB2eStatement.executeSql(DB2eStatement.java:221)

at com.ibm.db2e.jdbc.DB2eStatement.executeUpdate(DB2eStatement.java:259)

at com.sap.ip.me.persist.jdbc.IPersistenceWriterImpl.execute(IPersistenceWriterImpl.java:228)

... 22 more

[20050929 14:50:58:839] E [MI/Smartsync ] java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.smartsync.syncIn.SyncInRuntimeImpl.processSyncInMessage(SyncInRuntimeImpl.java:279)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:344)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

[20050929 14:50:58:849] E [MI/Smartsync ] Error while Smart Sync inbound processing: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505. Reset Smart Sync data on device to ensure consitency with middleware.

java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:351)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

[20050929 14:50:58:849] E [AppLog/MI/Smartsync ] Error while Smart Sync inbound processing: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505. Reset Smart Sync data on device to ensure consitency with middleware.

java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:351)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

[20050929 14:50:58:849] W [AppLog/MI/Sync ] Exception while proccessing method SMARTSYNC

java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:368)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534)

[20050929 14:50:58:849] E [AppLog/MI/Sync ] Exception while processing inbound container 4313A23E1388004A02000000C0708E2E

java.lang.RuntimeException: Error while Smart Sync inbound processing: com.sap.ip.me.spi.persist.IPersistenceException: char processor: SQL Error 23505

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeImpl.process(SmartSyncRuntimeImpl.java:368)

at com.sap.ip.me.smartsync.core.SmartSyncRuntimeManager.process(SmartSyncRuntimeManager.java:214)

at com.sap.ip.me.smartsync.core.SyncAdapter.process(SyncAdapter.java:56)

at com.sap.ip.me.sync.SyncManagerImpl.processSingleContainer(SyncManagerImpl.java:160)

at com.sap.ip.me.sync.SyncManagerMerger.processInboundContainers(SyncManagerMerger.java:166)

at com.sap.ip.me.sync.SyncManagerImpl.processSyncCycle(SyncManagerImpl.java:709)

at com.sap.ip.me.sync.SyncManagerImpl.syncForUser(SyncManagerImpl.java:1142)

at com.sap.ip.me.sync.SyncManagerImpl.processSynchronization(SyncManagerImpl.java:774)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:402)

at com.sap.ip.me.sync.SyncManagerImpl.synchronizeWithBackend(SyncManagerImpl.java:285)

at com.sap.ip.me.api.sync.SyncManager.synchronizeWithBackend(SyncManager.java:79)

at com.sap.ip.me.apps.jsp.Home$SyncRunnable.run(Home.java:447)

at java.lang.Thread.run(Thread.java:534) </b>

Any help would be great,

Thanks,

Wael

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Oct 05, 2005 at 10:27 AM

    Hello,

    There is an SQL error 23505 in the trace, this usually is a UNIQUE VIOLATION or Duplicate key error.

    Hope this helps.

    Good luck !

    Bart

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bart,

      thanks for your response but I was hoping for something a little more specific, we already assumed the same thing.

      -wael

  • author's profile photo
    Former Member
    Oct 05, 2005 at 03:12 PM

    Hi Wael,

    What version of the DB2e are you using, I heard about some strange issues with the earlier versions. I would try version DB2e V8.2.1.

    Hope this helps.

    Bart

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bart,

      I'm using the version that SAP provides, I just downloaded it last month so I assume its the latest version.

      -wael

  • author's profile photo
    Former Member
    Oct 07, 2005 at 07:31 AM

    Hi Wael,

    I've checked and indeed version 8.2 is the latest, but if you search google for DB2E 8.2.1 you might be able to download it. But it indeed is not released by SAP yet.

    Cheers,

    -Bart

    Add comment
    10|10000 characters needed characters exceeded