cancel
Showing results for 
Search instead for 
Did you mean: 

DB2E Problem

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Bart,

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

-wael

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Bart,

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

-wael