Connection failure ADF

Andres Esteban 156 Reputation points
2023-09-13T09:14:12.3233333+00:00

I am launching a data copy pipeline and I get the following error:

Operation on target Copy data1 failed: Failure happened on 'Source' side. 'Type=Npgsql.NpgsqlException,Message=Exception while reading from stream,Source=Npgsql,''Type=System.IO.IOException,Message=Unable to read data from the transport connection: 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,''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,'

It is strange because just yesterday I was doing the same process and it worked perfectly. Also, I do a connection test with postgreSQL and the connection test is correct.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,517 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 15,056 Reputation points
    2023-09-13T11:50:01.98+00:00

    The error you're encountering is a network-related or instance-specific error while Azure Data Factory is attempting to connect to your PostgreSQL database. To troubleshoot, first ensure no changes have been made to your network configurations, like modifications to Virtual Network or Network Security Group. Verify the firewall rules of your PostgreSQL instance to ensure Azure Data Factory has access. Check the PostgreSQL logs and connection string for potential issues. Consider adjusting connection timeout settings for slow networks and ensure the Npgsql library version in Azure Data Factory is compatible with your PostgreSQL version. Test the connection with tools like pgAdmin to check if the issue persists. If all else fails, consult Azure Support for deeper insights.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful