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.”.The above error message was coupled with a few instances where the following error message was received as well and may be related:
"Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.""
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:
The above article refers to this Microsoft documentation which mentions the exact error message.
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/api-limits#service-protection-api-limit-errors-returned
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+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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 ...Error Message: "Could not initialize component for use in the designer."
Action: While creating a new CRM destination, the following error is encountered. Error Message: TITLE: Microsoft Visual Studio ------------------------------ The component could not be added to the Data Flow task. Verify that this component is ...How to find which records contain errors in Dynamics CRM destination component.
The component's Error Output is used for providing both error information and the record identifier information for new records. Check the ErrorCode column: ErrorCode Description -1 Not an error record. >0 Error record. Check the ErrorDescription ...When I try to select entity in Dynamics CRM Source component I get error: "No connection could be made because the target machine actively refused it". Dynamics CRM Connection Manager 'Test Connection' command works fine.
If you have recently reinstalled your Dynamics CRM server and selected different access port, you have to make additional updates on your server. For more information review KB947423.Can I use Modern Authentication with the Dynamics CRM Adapters?
COZYROC Dynamics CRM Components do not support Modern Authentication. Our Dynamics CRM components use Microsoft Dynamics CRM WCF API, which is not compatible with Modern Authentication. If you prefer to use Modern Authentication to connect to ...