SAP Knowledge Base Article - Preview

2052443 - SQL Anywhere -193 Primary Key violation error during Delta sync

Symptom

  • The native application model has an MBO (Mobile Business Object) with an UPDATE operation defined.
  • A record on the client database is updated and the Delta is then synchronized.
  • The RBS delta synchronization fails and a stack trace with the following error is seen in the Server log

SQLException: SQL Anywhere Error -193: Primary key for table 'd1_application_name_1_1_3_mboname_25333' is not unique: Primary key value ('123456789')

  • The stack will also show the SQL exception happened because the UPDATE operation failed

DSException: Failed to execute operation d1_application_name_1_1_3_mboname_25333.OP_UPDATE (where OP_UPDATE is your update operation name)

  • The stack will also show the stored procedure that was called is the INSERT procedure

SPSQLException: "The statement [d1_application_name_1_1_3_mboname_25333_INSERT_WITH_FSK_UPDATE] failed to execute with parameters

...

Stored Procedure Name: d1_application_name_1_1_3_mboname_25333_INSERT_WITH_FSK_UPDATE

...

Method Name: d1_application_name_1_1_3_mboname_25333.deltaProcessor.insertWithFskUpdateCall


Read more...

Environment

  • Sybase Unwired Platform (SUP) 2.2.x
  • SAP Mobile Platform (SMP) 2.3.x

Product

SAP Mobile Platform 2.3 ; 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.