Error Message:Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds.

Error Message:Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds.



Action:
We started having random failures with an SSIS package that loads data from SQL Server to Dynamics (and back).
Error Message:
Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds. 
   Decrease number of concurrent requests or reduce the duration of requests and try again later.”.
Solution:

The following feedback from Microsoft was shared by a COZYROC customer after they contacted Microsoft about the error message:

"We opened a ticket with MicroSoft and received guidance on how to update the SSIS package to address the issue. Apparently, they recently made a change:

…Impact – New limit of 200 API requests per second is very generous limit and is hardly achievable keeping execute multiple will be counted as one…

 

They advised us to reduce the batch size in the Dynamics destination component. I did that and was able to successfully run the package in our test environment."
The following article also discusses the error message and refers to Microsoft documentation about the error message:

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.