ADF长期运行 [英] ADF Long Running Activitiy

问题描述

我在ADF V1中具有长期运行的活动，该活动在Azure SQL DB中运行存储过程以将数据从一个表复制到另一个表.

该活动运行9个小时，失败并重试.这是不断发生的.发生故障时，它将记录以下问题:

存储过程活动执行中发生错误.诊断详细信息:复制活动在xxxxxxxxxxx.westeurope1-a.worker.database.windows.net，11072处遇到用户错误 方面:ErrorCode = FailedDbOperation，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message =数据库操作失败，并出现以下错误:'当前命令发生了严重错误.结果(如果有的话)应该被丢弃.一个 当前命令发生严重错误.结果(如果有的话)应该被丢弃

An error occurred in Stored Procedure Activity execution. Diagnostic details: Copy activity encountered a user error at xxxxxxxxxxx.westeurope1-a.worker.database.windows.net,11072 side: ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded

对此有任何投入吗?

推荐答案

嗨Kishore，

Hi Kishore,

该问题看起来像数据库问题.这可能是由于多种原因.这是一个类似的线程:

The issue looks like a DB problem. It could be because of multiple reasons. Here's a similar thread :

https://stackoverflow.com/questions/1175244/sql-server-error-on-update-command-a-severe-error-occurred-on-the-current-com

https://stackoverflow.com/questions/1175244/sql-server-error-on-update-command-a-severe-error-occurred-on-the-current-com

此处的答案也可能有助于诊断您的问题.

The answers here might be useful to diagnose your issue as well.

让我们知道这是否有帮助.否则，我们可以继续进行进一步的研究.

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

这篇关于ADF长期运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！