Question

3
Replies
810
Views
Jeyapirashath Sakthithasan (PIRASHATH88)
Virtusa

Virtusa
LK
PIRASHATH88 Member since 2012 4 posts
Virtusa
Posted: February 2, 2018
Last activity: March 22, 2018
Posted: 2 Feb 2018 2:26 EST
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?

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.