OData connector to hit an endpoint failing intermittently even for small dataset

Aniruddhya Dutta 0

I have a Linked Service that uses OData connector to hit an endpoint and receive response back.
The endpoints are always up and running (I verify always through postman) but the LS fails frequently with below error.Even if I try from data bricks its sucessful.

The data is only around 50 rows and its intermittent. Even subsequent retries is not helping.log at service side is not helping much.

Error message:

Operation on target Copy to STG failed: ErrorCode=ODataFailedClientCreation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to create odata connection to RequestUrl.,Source=Microsoft.DataTransfer.Runtime.ODataConnector,''Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,'

HimanshuSinha-msft 19,386 Reputation points Microsoft Employee

2023-05-11T21:26:45.0866667+00:00

Hello @Aniruddhya Dutta ,

Thanks for the question and using MS Q&A platform.

Let me start that since this is an intermittent issue, I will admit it will be difficult to pinpoint the exact cause.

I will start with asking the question if the ADF and the OData source are in the same or close by region?. For example if the ADF is running in SouthEast asia and the Odata is in US region .

Also does increasing the timeout help ?

If you do not have a resolution & you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.

Subscription ID:Subject : Attn Himanshu

Please let me know once you have done the same.

Thanks
Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.

Share via

OData connector to hit an endpoint failing intermittently even for small dataset