Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Data Flow - DFExecutorUserError failed while writing rows
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 17%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Charbel Daia Martins
61
Reputation points
Hi,
I'm trying to write a .csv file from a DataLake (DataLake1) of my subscription to another data Lake (DataLake2) in another subscription, I created a dataset with a Linked Service configured, I created a new pipeline and inside it I have a dataflow source (DataLake1 ) and the sink (DataLake2), it manages to create the directory starts recording the file and generates the following error message:
{"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: Task failed while writing rows.","Details":"Task failed while writing rows."}
Thanks
Charbel
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator2021-05-05T19:52:48.123+00:00 Hello @Charbel Daia Martins ,
The error message is not very helpful . As per your post its looks like there are two different subscription is in play .Can you please see if you are able to write the CSV in a different data Lake in the same subscription ( as tyeh source ) or you are hitting the same error .
Please do let me know how it goes .
Thanks
Himanshu -
Charbel Daia Martins 61 Reputation points
2021-05-05T22:44:21.42+00:00 Hi, Himanshu
Using the pipeline only with the copy/data component I can write from DataLake1 to DataLake2 without problems, but when I use the dataflow I have the problem described above.
Is There some difference in behavior between using copy/data for a dataflow with source/sink?Thanks
Charbel -
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
2021-05-11T18:37:15+00:00 Hello @Charbel Daia Martins ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.Thanks
Himanshu -
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
2021-05-12T18:26:04.38+00:00 Hello @Charbel Daia Martins , ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Sign in to comment
Sign in to answer