Connection failure ADF

Question

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.

Answer 1

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.