RVR-RDBMS-202

1. Issue Summary

   • The error "Failed to ssh server" with Error Code: RVR-RDBMS-202 in the Data Integration platform indicates a failure in establishing an SSH connection required for accessing an RDBMS. This issue can arise due to a variety of connectivity issues, such as incorrect SSH configurations, networking issues, or firewall restrictions that block SSH communication between Data Integration and the server.

2. Action Steps:

   • Verify SSH Configuration:
     • Ensure that your SSH server is configured to accept connections from Data Integration IPs.
     • Check that your SSH hostname, username, and private key path are correctly entered in the Data Integration SSH configuration settings.
   • Network and Firewall Settings:
     • Confirm that the firewall rules allow incoming and outgoing connections on the necessary SSH ports, typically port 22.
     • Whitelist Data Integration’s IP addresses on your firewall to ensure packets from Data Integration are not blocked.
   • SSH Keys and Authentication:
     • Ensure that the public SSH key used by Data Integration is correctly added to the authorized_keys file on your server。
     • Double-check the permissions of the authorized_keys file (should be readable and writable only by the user).
   • Test SSH Connection:
     • Use an external SSH client to test the connection from outside your network using the same credentials to confirm that the issue isn't specific to Data Integration.

3. External References:

   • For detailed guidance on setting up an SSH Tunnel using Data Integration, refer to the official documentation: Data Integration - SSH Tunnel Setup.
   • General SSH connection troubleshooting: OpenSSH Manual.

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