2084914 - SMP Error message - SQL Anywhere Error -193: Primary key for table 'jms_dd' is not unique | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.