I have create a data flow in ADF and I am running it via a pipeline. The pipeline is validated and there are no errors. I am also able to preview all the data in the sink . But on executing the pipeline I am getting the following error :
Error code : DFExecutorUserError
Failure type : User configuration issue
Details:
{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'sink1': java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'employee_pk'. Cannot insert duplicate key in object 'dbo.employee'. The duplicate key value is (E04).","Details":"java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'employee_pk'. Cannot insert duplicate key in object 'dbo.employee'. The duplicate key value is (E04).\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$executeTableOpAndPostSQLAndDDL$1.apply$mcV$sp(JDBCStore.scala:485)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executeTableOpAndPostSQLAndDDL$1.apply(JDBCStore.scala:485)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter$$anonfun$executeTableOpAndPostSQLAndDDL$1.apply(JDBCStore.scala:485)\n\tat com.microsoft.dataflow.transformers.StoreContext$.timed(Store.scala:130)\n\tat com.microsoft.dataflow.transformers.store.JDBCWriter.executeTableOpAndPostSQLAndDDL(JDBCSto"}