SAP Knowledge Base Article - Preview

2084914 - SMP Error message - SQL Anywhere Error -193: Primary key for table 'jms_dd' is not unique

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.