RVR-RDBMS-303

1. Issue Summary

   • The error "Failed to fetch data from RDBMS. Error Code: RVR-RDBMS-303" indicates a failure in fetching data from the RDBMS data connector. This error is often associated with underlying issues related to connectivity, permissions, or misconfiguration in the database or network settings.
   • Initial diagnosis suggests checking database connectivity and user permissions on the database tables, ensuring that the connection settings in Rivery are correctly configured.

2. Action Steps:

   • Verify Connection Settings: Ensure that the database credentials and connection details, such as host, port, username, and password, are correct in the Rivery platform.
   • Check Database Logs: Examine the database logs for any specific error messages that could provide more insight into why the data fetch operation failed.
   • Review Permissions: Make sure the user account used in Rivery has the necessary read permissions on the target database tables.
   • Network Configuration: Confirm that any firewalls or network devices allow traffic between Rivery and the database server. This includes IP whitelisting if applicable.
   • Test Connection: Try running the connection test from the Rivery connection settings to see if it succeeds without errors.
   • Reinitialize Table Data: If applicable, and you suspect issues with data synchronization, consider reinitializing the table data in Rivery to reset any synchronization issues.

3. External References:

   • For more detailed steps on setting up and troubleshooting Rivery database connections, refer to the Rivery SQL Server Connection documentation.

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