Error 2001: The length of execution output is over limit (around 4MB currently) executing a Stored Procedure

Question

We are trying to execute a Stored Procedure using this step in Azure Data Factory. However, recently we started getting this error even when in the official documentation it is associated with a Web Activity.

https://learn.microsoft.com/en-us/azure/data-factory/data-factory-troubleshoot-guide

Answer 1

Hi DB ,

Thanks for reaching out on Microsoft Q&A!

For executing the stored procedure actually a HTTP-call is performed in the backend. HTTP-calls are limited on responses smaller then 4MB.

It could be that the error didn’t occur before as the result set was never over 4MB, until now.

To overcome this issue you can make your stored procedure support pagination. An example can be found in the article below:

https://stackoverflow.com/questions/17803062/pagination-with-the-stored-procedure/43098020#43098020

Please click “accept answer” if my response was helpful. Fee free to drop additional queries in the comments.

Kind regards,

Sonny