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

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 Sir,

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

Thanks in advance.