Hi Sir,

  I am attaching my application.json file for you reference. Anything wrong with that?

Thanks in advance.

Have you tried manually locking the record before updating it?  

Herebelow is the code manually lock a record [ code generated by Bing Chat GPT-4.  Regular warnings apply ]

****************************************

To manually lock a record in SQL Server, you can use the WITH clause with the XLOCK and ROWLOCK hints to lock and update a specific record ¹. Here is an example of how to lock a row:

BEGIN TRANSACTION;
SELECT * FROM table_name WITH (XLOCK, ROWLOCK) WHERE record_id = 123;

To unlock the record, you can use the COMMIT TRANSACTION command ². Here is an example of how to unlock a row:

COMMIT TRANSACTION;

I hope this helps! Let me know if you have any other questions.

*******************************************

If not tried, can try this one.

Happiness Always
BKR Sivaprakash

Hi Sim;

  There could be many reasons for this. We would need a lot more details about your App's processing profile, DBMS settings, environment, Transaction characteristics, etc in order to even "try" to answer what could be the issue (IMHO).

Regards ... Chris