Question
3
Replies
964
Views

Virtusa
LK
Posted: February 2, 2018
Last activity: March 22, 2018
Last activity: 22 Mar 2018 5:25 EDT
Closed
Foreign key constraint violation from the database and thus failing to commit the transaction
We did below changes to disable merge or batch processing and restart the server.
<env name="classmap/usemergestatement" value ="false" />
<env name="database/batchupdates" value="-1" />
But when analyze the tracer still "Add Batch" Queries executed and geting the error message.
The MERGE statement conflicted with the FOREIGN KEY constraint "FK02_.........". The conflict occurred in database "<<Database>>", table "<<tablename>>".
Can anyone give a solution to the issue?