RVR-MSSQL-RDBMS-301

1. Issue Summary

   • Error Code: RVR-MSSQL-RDBMS-301
   • Error Description: Failed to get last synchronization version for table using the MSSQL data connector. This indicates an issue where the last synchronization version for the table cannot be retrieved, which is essential for tracking changes within the database using mechanisms like Change Data Capture (CDC) or Change Tracking.

   Initial Diagnosis: The error typically arises due to missing synchronization metadata, which could be caused by several factors, such as cleanup processes that remove older change tracking data, high frequency of updates/deletions in the table, or concurrency issues with multiple processes attempting to access the change tracking data simultaneously.

2. Action Steps:

   • Reinitialize the Table: You need to reinitialize the table data to ensure the synchronization version metadata is reset. Navigate to your river's schema settings in Rivery, and select "Set initiate migration for all tables" from the options menu.
   • Verify Change Tracking/CDC Configuration:
     • Ensure Change Tracking is enabled for the database and tables.
     • Check that the SQL Server Agent is running, as it is required for CDC operations.
   • Investigate Cleanup Processes: Review your database's cleanup processes, which might be removing needed tracking data too frequently.
   • Review Logs: Examine MSSQL server logs for any messages related to synchronization issues or cleanup activities.
   • Frequency of Data Modifications: Assess if the table undergoes frequent updates/deletions and adjust the cleanup interval accordingly.

3. External References:

   • Rivery's SQL Server Change Tracking Documentation: For detailed instructions on managing change tracking settings.
   • Microsoft SQL Server Change Tracking Documentation: General overview and settings for Change Tracking in MSSQL.
   • MSSQL Synchronization and Cleaning Processes: Detailed instructions on managing SQL Server Agent and CDC/CT settings.

Please try these steps, and if the issue persists or you need further assistance, please open a ticket with Rivery support.