KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException in update entity Product

(0) Share

Report

Posted on by Francesco.999

I am trying to update the data in the Product entity via SSIS and kingswaysoft.

I often get the following error:

KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest, Detailed Message: {"error":{"code":"0x80044339","message":"Cannot obtain lock on resource:'Product_1e14a42e-41f9-ed11-8849-0022489fda17', mode:Update - stored procedure sp_getapplock because the SQL command timeout expired before the lock could be acquired."}}) (SSIS Integration Toolkit for Microsoft Dynamics 365, v23.1.0.7601 - DtsDebugHost, v13.0.4474.0)System.Net.WebException

(Status Reason: BadRequest): The remote server returned an error: (400) Bad Request.

I disabled multithreaded writing; the situation has improved but not resolved completely.

Is there a solution or workaround to avoid this behavior?

All responses (4)

Answers (0)

Francesco.999 5 on at

Like (0)

Report

RE: KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException in update entity Product

I've configured all the packages as you said and they work fine, but only when I try to massively update the Product entity, the results often end with timeouts.
Francesco.999 5 on at

Like (0)

Report

RE: KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException in update entity Product

Yes, I did, I improved the processing result, but i still get timeouts.
Suggested answer

ankit_singhal 560 on at

Like (0)

Report

RE: KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException in update entity Product

Reduce batch size and enable multi threading. try with batch size 20 and multi threading 10 once. we are using some and working fine for us on large data also
Suggested answer

XM-22040801-0 11 on at

Like (0)

Report

RE: KingswaySoft.IntegrationToolkit.DynamicsCrm.WebAPI.WebApiServiceException in update entity Product

Hi,

Can you try with a lower Batch size ?