Copying data from API to serverless pool not working while to Azure SQL Db works

Question

Hi,

I am copying data from REST API to azure sql db it working fine , but when i try to do the same with synapse serverless pool I am getting the below error:

Failure happened on 'Source' side. ErrorCode=UserErrorFailToReadFromRestResource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=An error occurred while sending the request.,Source=Microsoft.DataTransfer.ClientLibrary,''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 ,Source=System

Answer 1

Hello @Dubey Anshul (CI/XAI1),

Welcome to the MS Q&A platform.

The error message you are encountering indicates a failure on the source side while trying to read from the REST API. The error message also mentions an issue with connecting to the remote server.

It could be due to incorrect network configuration, firewall or private endpoint settings, or a lack of permission to access the data.

You can try to resolve the issue by checking the network configuration, firewall, or private endpoint settings and ensuring you have the necessary permissions to access the data.

The same error message has been discussed on this thread. on this thread, the issue was due to a firewall. Some blocking rules didn't allow to reach out the data source.

I hope this helps.

Please let us know if you have any further questions.