Error code: DFExecutorUserError

Manisha Kottary 61 Reputation points
2021-06-29T05:14:14.123+00:00

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"}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,726 questions
No comments
{count} votes

Accepted answer
  1. Nandan Hegde 22,236 Reputation points
    2021-06-29T06:45:30.57+00:00

    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

0 additional answers

Sort by: Most helpful