Question

3
Replies
774
Views
PIRASHATH88 Member since 2012 4 posts
Virtusa
Posted: February 2, 2018
Last activity: March 22, 2018
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
Share this page LinkedIn