获取errorCode& quot; 2001& quot;：& quot;执行输出的长度超过限制& quot;通过Web活动处理数据。 [英] Getting errorCode "2001": "The length of execution output is over limit" while processing data through Web-activity.

问题描述

我在通过网络活动获取数据时，在Azure Data Factory v2中收到了上述错误代码。我的Web活动在for循环中运行，它从动态URL中获取数据，该URL会更改每次迭代，然后将其保存在SQL接收器中。是
是否可以增加执行输出的限制，或者是否有任何已知的解决方法来解决此问题？

I'm getting aforementioned error code in Azure Data Factory v2 while fetching data through Web-activity. My Web-activity functions within a for loop and it fetches data from a dynamic url which changes every iteration and then saves it in a SQL sink. Is it possible to increase this limit for execution output or is there any known wraparounds to solve this issue?

错误消息：

推荐答案

您好janneraa并感谢您的提问。

Hello janneraa and thank you for your question.

我在Stack Overflow上发现了类似的问题：

https：/ /stackoverflow.com/questions/52843154/web-activity-throws-overlimit-error-when-calling-rest-api

I found a similar issue on Stack Overflow:
https://stackoverflow.com/questions/52843154/web-activity-throws-overlimit-error-when-calling-rest-api

Stack Overflow问题引用了  数据工厂限制和阈值。

The Stack Overflow issue references the data factory limitations and thresholds.

我对超出哪个限制感到有点困惑。 要迭代的项目数，或指定时间范围内的查询数。

I am a little confused over which limitation is being exceeded.  The number of items to iterate over, or, the number of queries within a specified time frame.

如果是超出每分钟查询数阈值的情况，您可以尝试将一个"等待"在您的"网络"之前或之后的活动循环中的活动。

If it is the case of exceeding the queries-per-minute threshold, you could try putting a "wait" activity either before or after your "web" activity inside the loop.

如果要迭代的项目太多，您可以拆分流并使用两个"for-each"。活动。

If it is the case of too many items to iterate over, you could split the stream and use two "for-each" activities.

如果是超过每小时写入阈值的情况，您可以联系支持。

If it is the case of exceeding the writes-per-hour threshold, you can contact support.

这有什么帮助？

这篇关于获取errorCode& quot; 2001& quot;：& quot;执行输出的长度超过限制& quot;通过Web活动处理数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！