RVR-RDBMS-402

1. Issue Summary

The error message "Failed to connect to RDBMS" with Error Code: RVR-RDBMS-402 indicates a failure in establishing a connection to a relational database management system (RDBMS) using Data Integration. This could be due to incorrect connection details, network issues, or database server unavailability. The issue typically involves connectivity parameters such as server address, port, database name, username, or password being incorrect, or related permission settings.

2. Action Steps

1. Check Connection Details:

   • Verify the server address and port number. Ensure they match the settings required to access your RDBMS server.
   • Double-check the database name, username, and password. Ensure there are no typographical errors.

2. Network Configuration:

   • Ensure that the client machine or service using Data Integration has network access to the database server. This may involve whitelisting IP addresses or checking firewall settings.

3. Permission and Credentials:

   • Ensure that the database user has the necessary permissions to connect and perform operations on the target database.

4. Database Server Status:

   • Verify that the RDBMS server is running and accessible. Check for any downtime or maintenance activities.

5. SSL/TLS Configuration:

   • If your database requires SSL/TLS encryption, ensure that the necessary certificates are configured in the Data Integration connection settings.

6. Review Logs:

   • Check any logs available for the database server and Data Integration for additional error messages that can provide more detail on the failure.

3. External References

• Data Integration RDBMS Connection Documentation
• General Database Connection Troubleshooting (Refer to the specific RDBMS being used, such as PostgreSQL, MySQL, etc., for further guidance)

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