Symptom
- SUP 2.1.3 Log shows:
2014-05-28 09:40:32.469 ERROR MMS Thread-897 [com.sybase.djc.log.SystemExceptionLog]com.sybase.djc.transaction.TransactionRolledbackSystemException was thrown by transaction com.sybase.jms.server.MessageService.sendPersistent(java.lang.String, com.sybase.jms.client.MessageImpl)\ncom.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.jms.server.MessageQueue.ignoreDuplicate(com.sybase.jms.client.MessageImpl)
... 30 more
at com.sybase.djc.sql.PersistenceManager.executeInsert(PersistenceManager.java:2975)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table 'jms_dd' is not unique: Primary key value (''sup.mbs.15',11081221537793,'6214#4,601237'') - SMP 2.3.4 Log shows:
2014-10-20 09:26:30.972 ERROR MMS Thread-24584 [com.sybase.djc.log.SystemExceptionLog] [] [] com.sybase.djc.transaction.TransactionRolledbackSystemException was thrown by transaction com.sybase.jms.server.MessageService.sendPersistent(java.lang.String, com.sybase.jms.client.MessageImpl)\ncom.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.jms.server.MessageQueue.ignoreDuplicate(com.sybase.jms.client.MessageImpl)
at com.sybase.djc.transaction.TransactionManager.getRolledbackException(TransactionManager.java:1310)
at com.sybase.djc.transaction.TransactionManager.invokeInTransaction(TransactionManager.java:1254)
at com.sybase.djc.transaction.TransactionManager.invokeRequired(TransactionManager.java:1098)
at com.sybase.djc.transaction.TransactionManager.invokeMandatory(TransactionManager.java:1140)
at com.sybase.jms.server.MessageQueue_DJC.ignoreDuplicate(MessageQueue_DJC.java:2032)
at com.sybase.jms.server.MessageService.sendMessage(MessageService.java:1200)
at com.sybase.jms.server.MessageService_DJC.sendMessage(MessageService_DJC.java:3043)
at com.sybase.jms.server.MessageService.sendPersistent(MessageService.java:1167)
at com.sybase.jms.server.MessageService_DJC.access$1801(MessageService_DJC.java:4)
at com.sybase.jms.server.MessageService_DJC$12.invoke(MessageService_DJC.java:3092)
at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:857)
at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:759)
at com.sybase.djc.transaction.TransactionManager.invokeRequired(TransactionManager.java:1090)
at com.sybase.jms.server.MessageService_DJC.sendPersistent(MessageService_DJC.java:3096)
at com.sybase.jms.server.MessageService.send(MessageService.java:219)
at com.sybase.jms.server.MessageService_DJC.send(MessageService_DJC.java:2992)
at com.sybase.jms.server.NetProvider.send(NetProvider.java:127)
at com.sybase.jms.server.NetProvider_DJC.send(NetProvider_DJC.java:1013)
at com.sybase.jms.server.NetProvider_DJC.$invoke_0(NetProvider_DJC.java:227)
at com.sybase.jms.server.NetProvider_DJC.$invoke(NetProvider_DJC.java:139)
at com.sybase.djc.rmi.iiop.server.MessageHandler.processRequest(MessageHandler.java:794)
at com.sybase.djc.rmi.iiop.server.MessageHandler.run(MessageHandler.java:306)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:789)
Caused by: com.sybase.djc.DataStoreException: SQL Anywhere Error -193: Primary key for table 'jms_dd' is not unique: Primary key value (''sup.mbs.97',11017207939073,'296#1,900004'')
Read more...
Environment
- Sybase Unwired Platform (SUP) 2.X
- SAP Mobile Platform (SMP) 2.3.x
Product
SAP Mobile Platform 2.3 ; Sybase Unwired Platform 2.1 ; Sybase Unwired Platform 2.2
Keywords
KBA , MOB-SUP-RT , SUP Runtime , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.