RVR-SYNP-303

1. Issue Summary

   • The error code RVR-SYNP-303 with Azure Synapse in Rivery indicates a failure in syncing the metadata for a table. This problem is commonly associated with issues such as missing synchronization versions or cleanup processes affecting change tracking data. This error requires checking configurations related to metadata synchronization and version handling.

2. Action Steps:

   • Verify the minimum valid version for synchronization is not zero and ensure the last_sync_version is correctly received. If it is zero or missing, you need to reinitialize the table by setting the "Initiate Migration" for all tables.
   • Investigate if automated cleanup processes might be disrupting your change tracking data. This can lead to losing synchronization information. Examination of SQL Server logs might help to identify issues during cleanup or tracking.
   • Reinitialize the table data if frequent deletions or updates are detected alongside the change tracking system, which may affect the table integrity.
   • Coordinate synchronization processes properly if there's possible concurrency with multiple processes interacting with change tracking data simultaneously.

3. External References:

   • Detailed documentation on handling SQL Server Change Tracking can be found here: Rivery Documentation.
   • Microsoft SQL Server official documentation on Change Tracking and Change Data Capture: SQL Server Change Data Capture (CDC).
   • Azure Synapse specific setup guidance can be found in Azure's documentation: Azure Synapse Documentation.

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