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 Data Integration 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 Data Integration 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 Data Integration has the necessary read permissions on the target database tables.
   • Network Configuration: Confirm that any firewalls or network devices allow traffic between Data Integration and the database server. This includes IP whitelisting if applicable.
   • Test Connection: Try running the connection test from the Data Integration 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 Data Integration to reset any synchronization issues.

3. External References:

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

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