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.
SAP Knowledge Base Article - Preview