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