RVR-RDBMS-304

1. Issue Summary

   • The error code RVR-RDBMS-304 pertains to a problem retrieving data from an RDBMS data source. This issue often arises when there is a conflict or issue with data synchronization, possibly linked to change tracking or connectivity disruptions.

2. Action Steps:

   • Check Database Connection:

     • Ensure that the connection settings for your RDBMS data source in Rivery are correctly configured. This includes checking the hostname, port, username, password, and database name.

   • Verify Change Tracking:

     • If using SQL Server, verify that Change Tracking is enabled and configured correctly on your tables. Use SQL queries to confirm the status at both the database and table levels【4:5†source】.

   • Inspect Cleanup Processes:

     • Analyze any cleanup processes that could be affecting change tracking data. These processes might happen automatically and can sometimes prematurely delete necessary tracking data【4:2†source】.

   • Review Logs:

     • Check the server logs for any relevant error messages or issues during synchronization or data retrieval attempts. Logs can provide specific insights into what might be failing during the river run【4:2†source】.

   • Reinitialize Tables:

     • If persistent issues occur with synchronization versions or data retrieval, consider reinitializing the affected tables. This process can reset synchronization versions that might be corrupt or outdated, thus allowing the river to start afresh【4:2†source】.

3. External References:

   • For more detailed instructions and additional troubleshooting steps, consult the Rivery Documentation related to your specific data source and Rivery's RDBMS integrations.

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