RVR-SFTPConn-100

1. Issue Summary

   • You are encountering a connection error with the code RVR-SFTPConn-100 while attempting to connect to an SFTP server using Data Integration. This error typically indicates that there are bad credentials or permissions issues involved in the connection process. This could be due to incorrect login details, such as the username, password, or key file, or missing permissions for SFTP access.

2. Action Steps

   • Check Whitelisting: Ensure that Data Integration IPs are whitelisted on your SFTP server. Without this, you might face connection issues related to network blocking.
   • Verify Credentials:
     • If using basic authentication, confirm that the username and password are correct. Ensure there are no spaces or unintentional characters in these fields.
     • If using a key file, ensure that the correct private key (.pem) and its password, if applicable, are used. This also involves generating a public key in Data Integration and adding it to the SFTP server's authorized_keys file.
   • Permissions: Make sure that the SFTP server permissions allow access from the provided credentials (username, key).
   • Test Connection: Use the "Test Connection" feature in Data Integration connection setup to verify that the settings are correct. This feature helps in diagnosing if credentials or network configurations are successful.
   • Configuration Review: Recheck all configuration fields like Host, Port, and Connection Name for any discrepancies.

3. External References

   • Detailed steps on connecting by SFTP in Data Integration: Data Integration SFTP Connection Documentation.
   • General SFTP setup and troubleshooting documentation: Data Integration Documentation for IP whitelisting and other connection setup references.

If the issue persists or you need further assistance, please open a ticket with Data Integration support.