ADF复制活动期间的过早超时 [英] Premature timeout during ADF Copy activity

问题描述

我有一个做foreach的管道 - >数据复制以同时将数据从一个Azure SQL数据库复制到另一个Azure SQL数据库。

I have a pipeline that does a foreach -> Data Copy to concurrently copy data from one Azure SQL Database to another another.

源是从存储过程聚合的数据，接收器是一个调用合并到本地的存储过程表。

The source is data aggregated from a stored procedure, and the sink is a stored procedure that calls a merge onto the local table.

管道中所有活动的超时时间默认为7天，但对于1或2个表，复制活动在15或20分钟后超时。

The timeout for all activities in the pipeline remains the default 7 days, but for 1 or 2 tables, the copy activity times out after 15 or 20 minutes.

是否存在特定活动不遵守活动超时的情况？

Is there a scenario where the activity timeout would not be respected for the specific activity?

理想情况下，我不想切换到按顺序复制这些数据表。

Ideally, I would not want to switch to copying these data tables sequentially.

推荐答案

Hi Matt，

Hi Matt,

此处报告了一个非常类似的问题：

There's a very similar issue reported here :

https://social.msdn.microsoft.com/Forums / en-US / 251345ed-ed1a-4537-994c-9d8b9182c5e5 / azure-data-factory-pipeline-hangstimeouts？forum = AzureDataFactory

https://social.msdn.microsoft.com/Forums/en-US/251345ed-ed1a-4537-994c-9d8b9182c5e5/azure-data-factory-pipeline-hangstimeouts?forum=AzureDataFactory

在这里查看建议的答案以解决问题问题。缩小到可以帮助我们解决问题的确切问题可能会有所帮助。

Have a look at the proposed answer here to troubleshoot the issue. It might be helpful to narrow down to the exact issue which will help us resolve it.

如果有帮助，请告诉我们。另外，我们可以继续进一步探讨。

Let us know if it helps. Else, we can continue to probe in further.

这篇关于ADF复制活动期间的过早超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！