Microsoft Dynamics 365 | Integration, Dataverse...

Error 2147015903 thread and not exceed/running more than 2 thread ever as I know limitation of 2 API call restrictions

(0) Share

Report

Posted on by Pradeepkumar_cs

Hi,

I'm loading the data from SQL server to CRM using SSIS & Kingwaysoft with Batch size 100 and using single instance/thread. I have encountered below error message from today and it was working fine till yesterday. I don't know why it occurring as I'm using only 1 thread and not exceed/running more than 2 thread ever as I know limitation of 2 API call restrictions. I'm not sure what to be done next and how to check if any of thread running on my name at background and causing this issue. I have closed all the window/instance & reopened by restarting system but no luck.

Error Message -
CRM service call returned an error: 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.
(Error Code: -2147015903, Detail 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.)

Your suggestion will be highly appreciated.

Thanks,
Pradeep

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello Pradeep,

You just hit API limits - docs.microsoft.com/.../api-limits

What you can do is to get in touch with Microsoft and ask if they can increase that limit.

Was this reply helpful? Yes No
Pradeepkumar_cs 5 on at

Like (0)

Report

Hi Andrew,

Thank you for response. Sure I will go back to Microsoft and ask for lifting limit.

However My one more question, till yesterday I didn't face any error. I'm running same job whichever I ran earlier with same number of records and same data. how come today I exceeded the limit . I want to trace it and provide justification to my next level before I request Microsoft to lift limit.

Also I'm sure Microsoft would take some time to lift limit upon request, however I just want to keep continue my data load so any suggestion how can I delay incoming request so that I don't exceed 1200000 milliseconds limit over 300 seconds.

Thanks,

Pradeep

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Pradeep,

I'm afraid I don't have a good answer for you - I'm not a god and don't have superpowers so I can't answer why yesterday you had no issues and today you hit limits. May be you were not running a lot of operations or you changed some settings from yesterday.

Regarding suggestions - increase the number of records per batch, decrease the number of threads. I'm afraid you will have to looks for settings that fit your scenario.

Was this reply helpful? Yes No
Pradeepkumar_cs 5 on at

Like (0)

Report

Hi Andrew,

Thank you again for response. Yes, I know you that we all are not god & nor have super power :).

I wanted to know suggestion/assumption if anything i'm missing between yesterday & today based on your experience or past observation. that's absolutely fine. and thank you very much for you 2nd suggestion and I will definitely try that until Microsoft lift limit.

However If I find any solution/observe gap between yesterday & today changes then will include here for future use.

Thanks,

Pradeep

Was this reply helpful? Yes No