Error code: DFExecutorUserError

Question

I am getting the below error when i debug my workfolw, it worked yesterday but today, when i just debug it , it throws the below error:

Error code
DFExecutorUserError

Failure type
User configuration issue
Details
{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'sink1': java.sql.BatchUpdateException: The DELETE statement conflicted with the REFERENCE constraint \"dept_fk\". The conflict occurred in database \"DBundernewRG\", table \"dbo.employee\", column 'dept_id'.","Details":"java.sql.BatchUpdateException: The DELETE statement conflicted with the REFERENCE constraint \"dept_fk\". The conflict occurred in database \"DBundernewRG\", table \"dbo.employee\", column 'dept_id'.\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1753)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executeBatchSQLs(JDBCStore.scala:457)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executeSQL(JDBCStore.scala:439)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executePreSQL$1.apply$mcV$sp(JDBCStore.scala:423)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executePreSQL$1.apply(JDBCStore.scala:423)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executePreSQL$1.apply(JDBCStore.scala:423)\n\tat com.microsoft.dataflow.transformers.StoreContext$.timed(Store.scala:130)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executePreSQL(JDBCStore.scala:422)\n\tat com.microsoft.dataflow.tra"}

Answer 1

Hey,
Based on the error message it seems that you are deleting the data from a primary table whose data is being referenced as a key in another table as Foreign key.
So this is not an ADF issue but a SQL issue.

You need to 1st delete data from secondary table and then the original table else you can drop the constraint