RVR-SFTPConn-104

Issue summary

The error Connection Error to SFTP: {host}. General Connection Problem. Error Code: RVR-SFTPConn-104 indicates a general connectivity issue when trying to establish a connection to an SFTP server from Data Integration. This typically involves network-level problems, incorrect credentials, or configuration issues in the Data Integration platform.

Initial Diagnosis:

• The error might arise from not having the necessary IP addresses allowlisted on the server firewall, incorrect host or port settings, wrong authentication details, or a temporary network problem.

Action steps

To resolve the error, follow these steps:
To resolve the connectivity issue with SFTP in Data Integration, follow these steps:

1. Review Server Allowlisting:

   • Ensure that Data Integration you have allowlisted the IP addresses on your SFTP server. Data Integration maintains a list of IP addresses that need to add to the allowlist based on the server location. Refer to the Data Integration IP address allowlisting documentation for detailed information.

2. Check Connection Settings:

   • Verify that the hostname and port number provided in the Data Integration connection settings match those required by the SFTP server.
   • Ensure to use correct username and password or key file for authentication.

3. Test the SFTP Connection:

   • Use the Test Connection feature within Data Integration to verify the connection settings and make sure all configurations are correctly set.

4. Network Issues:

   • Check network connectivity to the SFTP server from your location using tools like telnet or ping.
   • Consult with your network team to ensure there is no firewall or proxy blocking the connection.

5. Check Server Logs:

   • If access is available, review the SFTP server logs for any rejected connection attempts to understand if there is a specific error or reason for the failure.

External references

• You can find more detailed steps for setting up an SFTP connection in Data Integration from the official documentation: Data Integration SFTP Connection Setup.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.