Share via

Azure Data Factory : DF-Executor-UserError (Writing job aborted.)

Nowduru, Sreedhar 0 Reputation points
2024-04-04T04:54:22.1133333+00:00

I have created a pipeline in ADF based on Dataflow. The dataflow shows step by step update I want to make also reflected in the sink. When I earlier used to run pipeline it worked fine. Now it is throwing error. I am sharing the details of the same.
Error code : DFExecutorUserError

Failure type : User configuration issue

Details : Job failed due to reason: at Sink "{Sink_Name}": Writing job aborted.

Please let me know any possible solutions
Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee
    2024-04-04T06:13:21.8933333+00:00

    @Nowduru, Sreedhar - Thanks for the question and using MS Q&A platform.

    Based on the error message you provided, it seems like there is a user configuration issue. Specifically, the error message indicates that the writing job was aborted at the sink. This could be due to a number of reasons, such as incorrect credentials or insufficient permissions.

    Here are some steps you can take to troubleshoot this issue:

    • Check the credentials for the sink. Make sure that the credentials are correct and have sufficient permissions to write to the sink.

    Check the permissions for the sink. Make sure that the user or service principal running the pipeline has the necessary permissions to write to the sink.

    Check the connection between the source and sink. Make sure that the connection is established and working properly.

    Check the dataflow settings. Make sure that the dataflow settings are configured correctly and that there are no errors in the dataflow.

    If none of these steps resolve the issue, you may provide more details on sink type and the steps followed to run the pipeline for further assistance.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

  2. Pinaki Ghatak 2,400 Reputation points Microsoft Employee
    2024-05-10T20:46:39.2433333+00:00

    Hello @Nowduru, Sreedhar

    There could be multiple reasons for this error.

    One possible reason could be that the sink is not able to write data due to some permission issues. Another reason could be that the sink is not able to handle the volume of data being written to it.

    To troubleshoot this issue, you can try the following steps:

    1. Check if the sink is configured correctly and has the necessary permissions to write data.
    2. Check if the sink is able to handle the volume of data being written to it. You can try reducing the volume of data being written to see if it resolves the issue.
    3. Check if there are any issues with the network connectivity between the data flow and the sink. You can try running the pipeline again after some time to see if the issue resolves itself. If none of the above steps work, you can try looking at the detailed logs to get more information about the error.

    I hope this helps! Let me know if you have any further questions.

    I hope that this response has addressed your query and helped you overcome your challenges. If so, please mark this response as Answered. This will not only acknowledge our efforts, but also assist other community members who may be looking for similar solutions.

    0 comments