Skip to main content
Feedback

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 Data Integration. 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 '`<Data_IntegrationUsername>`' IDENTIFIED BY '`<password>`';
      GRANT SELECT, SHOW DATABASES, SHOW VIEW, EXECUTE ON *.* TO '`<Data_IntegrationUsername>`';
    • Network Access: Ensure the Data Integration IPs are whitelisted in your database's network settings to allow incoming connections from Data Integration servers.
    • Test Connectivity: Use the "Test Connection" feature in Data Integration 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:

    • Data Integration 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 Data Integration support.