ErrorCode=ODataFailedClientCreation

Question

we would like transfer data about odata to sql. Our linked service is working. Only the ADF pipeline doesn't work with folling error...

ErrorCode=ODataFailedClientCreation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to create odata connection to RequestUrl.,Source=Microsoft.DataTransfer.Runtime.ODataConnector,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=Unable to connect to the remote server,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xxx.xxx.xxx.xxx:443,Source=System,'

Answer 1

@T1 ADM Sven ***

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

The error message you’re seeing indicates that the Azure Data Factory (ADF) pipeline is unable to establish a connection to the OData service. This could be due to a variety of reasons. Here are a few things you could check:

1. Network Connectivity: The error message suggests a network connectivity issue. Ensure that the ADF can reach the OData service over the network. Check if there are any firewalls, Network Security Groups (NSGs), or Virtual Networks (VNETs) that might be blocking the connection.
2. Service Availability: Check if the OData service is up and running. You can do this by trying to access the service URL from a web browser or using a tool like Postman.
3. Correct URL: Make sure that the URL you’re using to connect to the OData service is correct. The error message indicates a failure in creating an OData connection to the RequestUrl.
4. Authentication: If the OData service requires authentication, ensure that the correct credentials are being used
5. Timeout Settings: The error message suggests that the connection attempt failed because the connected party did not properly respond after a period of time. You might want to check the timeout settings and consider increasing them if they’re too low.

Hope this helps. Do let us know if you any further queries.