RVR-SYNP-303

Issue summary

• The error code RVR-SYNP-303 with Azure Synapse in Data Integration 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.

Action steps

To resolve the error, follow these steps:

1. 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.
2. 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.
3. Reinitialize the table data if frequent deletions or updates are detected alongside the change tracking system, which may affect the table integrity.
4. Coordinate synchronization processes properly if there's possible concurrency with multiple processes interacting with change tracking data simultaneously.

External references

• For more information on handling SQL Server Change Tracking, refer to Data Integration- SQL server change tracking.
• For more information on Change Tracking and Change Data Capture, refer to Change Data Capture (CDC).
• Azure Synapse specific setup guidance is available in Azure Synapse Analytics.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.