RVR-MSS-714

1. Issue Summary

   • The error code "RVR-MSS-714" indicates a failure in retrieving schemas from an Azure SQL data connector. This issue may be linked to problems with synchronization, particularly related to change tracking features in Microsoft SQL Server. Problems like missing the last_sync_version or excessive cleanup processes that remove necessary tracking data can trigger such errors.

2. Action Steps:

   • Verify Change Tracking Status: Check if change tracking is enabled for the relevant database and its tables. This can be done by executing SQL queries to verify change tracking at both database and table levels.
   • Review and Adjust Cleanup Processes: Excessive cleanup processes can remove necessary tracking data. Review the cleanup configuration on your SQL Server to ensure it is not excessively removing tracking data.
   • Analyze Update/Delete Frequency: If the table experiences frequent updates or deletions without corresponding inserts, this can disrupt change tracking. Consider adjusting the frequency of these operations or reinitializing the table data.
   • Check Concurrency Issues: Ensure that there are no concurrency issues, such as multiple processes attempting to synchronize with change tracking simultaneously. Proper coordination is necessary to prevent such conflicts.
   • Reinitialize Tables if Necessary: If the change tracking tables need to be reset due to missing synchronization versions, reinitialize them to restore proper tracking and synchronization.

3. External References:

   • For further details on managing Azure SQL connectivity and permissions, refer to Azure SQL Database Documentation.
   • More information on Rivery's handling of Azure SQL connections can be found in their connection guide.

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