RVR-SF-RDBMS-317

1. Issue Summary:

   • The error message "Failed to establish a connection to the RDBMS with specific details. Error Code: RVR-SF-RDBMS-317" indicates that there was a failure in setting up a connection to the Relational Database Management System (RDBMS) through Rivery. This error is usually related to configuration or network issues preventing successful communication with the database.

2. Action Steps:

   • Check Credentials and Connection Details:
     Ensure that all required credentials (username, password) and connection parameters (host, port, database name) are correct.

     CREATE USER '<RiveryUsername>' IDENTIFIED BY '<password>';
     GRANT SELECT, SHOW DATABASES, SHOW VIEW, EXECUTE ON *.* TO '<RiveryUsername>';
     

   • Network Access:
     Ensure the Rivery IPs are whitelisted in your database's network settings to allow incoming connections from Rivery's servers.
   • Test Connectivity:
     Use the "Test Connection" feature in Rivery to verify if the setup is correct and the database is reachable.
   • Firewall and Security Groups:
     Check your organization's firewall settings and ensure that the necessary ports for database communication are open.

3. External References:

   • Rivery Documentation for IP whitelisting and further troubleshooting steps.
   • Relevant database documentation specific to the type of RDBMS you are connecting to.

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