This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(48, 97%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Hi, my azure data flow activity gets stuck (run id aea495f9-5a19-4f38-96f3-f6f79831ada5) from time to time and I don't really know how to debug this.
When I inspect the progress of the activity I can see the activity status as "Running" but the final sub-activity marked as completed (green tick). The final subactivity is the sink to an Azure SQL database.
Could you please provide me with some guidance on how to debug this?
Also would like to know how can I get a warning or something when an activity/pipeline run takes more than certain time to complete or similar warning.
thanks
An Azure relational database service.
An Azure service for ingesting, preparing, and transforming data at scale.
If you have an Azure SQL DB Sink transformation and it's showing as completed in the monitoring view but the data flow activity is still "Running", that means ADF is waiting on the driver to return a complete status and the database row serialization has not yet completed. You can check the status of the job in your SQL DB and make sure that you have enough resources available on your SQL DB at the time of the pipeline run so that your process can complete in a timely manner.
![](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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi @javier ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Please suggest checking status in SQL DB helped in understanding the issue. Also, I have reached out our internal teams with run id to investigate further. I will let you know once I hear back from them.
Hi @javier ,
We have not received a response from you. Are you still facing the issue? If you found a solution or approach from Mark helped in identifying the issue, would you please share it here with the community? Otherwise, I have reached out to product team with the run id and they requested more run id's to debug it further as this run id does not have detailed logs which can help to investigate.
Please let us know if they can be shared to continue with deeper investigation. Thanks!
HI thanks for the responses @HarithaMaddi-MSFT and @MarkKromer-8019 . However I don't see anything wrong in my DB status.
Btw, I'm using a serverless instance. Because of that and the datafile size (less than 100MB of data). At first it seems to me that the resources should be enough to handle this. Am I wrong?
Thanks @javier for sharing the details. As suggested by our product team, can you share any other pipeline run ids that shows this issue which helps us to investigate further on the same.
Looking forward for your response!
Hi @javier ,
We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Couldn't find what the issue was, so what i did is to insert the records I needed (5 columns) in a separate table using data flow and performing a join query when I need to get the data... not great but, seems to work for the moment...
thanks guys
Hi @javier ,
Thanks for sharing the update. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
--
Hi @javier ,
We have not received a response from you. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Hi @javier ,
We still have not heard back from you. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.