Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Getting error in pipeline with Dataflow activity
![](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(281.6, 38%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dharmendra Kumar
1
Reputation point
I am trying to run one simple pipeline with Data Flow activity.
About Data flow.
1- Source table in Azure Synapse (it's a view)
- Added derived columns one for constant value (which is for Source Type), another one is for Current date.
- Added Select Columns (Pulled above two cloumns and one more column from Source view)
- Added sink , done manual mapping.
See below:
Error :
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
-
![](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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,161 Reputation points2022-06-15T16:32:40.067+00:00 Hello @Dharmendra Kumar and welcome to Microsoft Q&A.
I see you would like help with this error message which arose after trying to run a pipeline (or debug pipeline) while Data Flow Debug is active.
By the looks of things, you have not done anything wrong in your data flow. This error is talking about a problem with the Integration Runtime. Is "AzureIR-8-CORE" an integration runtime you created, or is it just the debug?
I do have a couple things to try. Turn off the "Data Flow Debug". Maybe turn it on again.
If the IR is something you created, please check its status under monitoring.Beyond that, can you tell me:
Has this happened only 1 time, or does it happen again and again?
Does it happen after reloading the page?
Has the dataflow and pipeline been published since any changes were made?
What is the status of the integration runtime?
Is there private endpoint involved? -
MartinJaffer-MSFT 26,161 Reputation points
2022-06-20T16:53:49+00:00 Hello @Dharmendra Kumar ,
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
Martin
Sign in to comment
Sign in to answer