RVR-MSSQL-RDBMS-205

1. Issue Summary

   • The error code RVR-MSSQL-RDBMS-205 indicates a problem in retrieving the minimum valid version for a table in a Microsoft SQL Server data connector setup within Rivery. This issue typically arises when there is no minimum valid version available, or if it is set to zero, which means the system cannot retrieve change tracking data necessary for synchronization processes【4:0†source】.

2. Action Steps:

   • Check Change Tracking Versions:

     • Verify if the min_valid_version is zero or missing the last_sync_version. If so, this indicates that you need to reinitialize the table【4:1†source】.

   • Investigate Cleanup Process:

     • Review the cleanup processes on the MSSQL server as frequent automatic cleanup can remove necessary change tracking data【4:1†source】.

   • Examine Office Logs:

     • Check server logs for related messages or patterns that depict issues in the cleanup process or synchronization.
     • Reinitialize the table, run the process again, and monitor the logs for further insights【4:2†source】.

   • Reinitialize the Table:

     • If the problem persists, manually reinitialize the table to ensure that all necessary synchronization data is present【4:3†source】.

   • Review Concurrency and Update Patterns:

     • Ensure there are no concurrency issues. Multiple processes synchronized simultaneously can cause conflicts. Adjust the processes to avoid these issues【4:2†source】.
     • Review the frequency of updates or deletions in the table. Excessive update/delete operations without corresponding inserts may lead to these problems【4:3†source】.

3. External References:

   • For troubleshooting SQL Server connections and setup in Rivery, visit the Rivery official documentation at Rivery MSSQL Connection Guide.

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