Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
Data Transfer (Data flow activity)
Rohit Kulkarni
441
Reputation points
Hello Team, I have Created a Dataflow using the select and sink Transformation and mapped it to Dataflow activity. While running the pipeline i am getting below error. Please advise. ![71329-image.png][1] {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'sink1': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: 111212;Operation cannot be performed within a transaction.","Details":"at Sink 'sink1': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: 111212;Operation cannot be performed within a transaction."} [1]: /api/attachments/71329-image.png?platform=QnA Thanks RK
Azure Data Factory
{count} votes
-
Nasreen Akter 10,811 Reputation points Volunteer Moderator2021-02-24T13:22:13.253+00:00 Hi @Rohit Kulkarni , would you please provide a screenshot of the SINK-->Setting tab. Thanks!
-
Rohit Kulkarni 441 Reputation points
2021-02-24T17:37:50.17+00:00 Hello Nasreen,
Please refer the screenshot below :
-
![](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(25.6, 5%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Muhammad Rahman 1 Reputation point2021-10-27T02:15:54.577+00:00 Hi There,
I've got the same error while I was debugging my Data Flow in the Azure Synapse Pipeline to load my Dimension Table in Dedicated SQL Pool. I was able to view the incoming records and I also mapped incoming columns with the sink accordingly.It would be appreciable if someone could help.
Thank you
-
![](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(275.2, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ramaswamy, Anitha (AllianzGI) 1 Reputation point2021-11-30T12:49:33.467+00:00 how did you resolve this issue? could you please share?
Sign in to comment
Sign in to answer