Skip to Content
0
Former Member
Sep 29, 2005 at 02:55 PM

DB2E Problem

12 Views

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