RVR-MSS-714

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 synchronization issues, particularly those related to change tracking in Microsoft SQL Server. Issues like missing the last_sync_version or excessive cleanup processes that remove necessary tracking data can trigger such errors.

Action steps

To resolve the error, follow these steps:

1. Verify change tracking status: Check if change tracking is enabled for the relevant database and its tables by executing SQL queries to verify change tracking at both the database and table levels.
2. 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 removing tracking data excessively.
3. Analyze Update/Delete frequency: If the table experiences frequent updates or deletions without corresponding inserts, this can disrupt change tracking. Adjust the frequency of these operations or reinitialize the table data.
4. 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.
5. Reinitialize tables: If the change tracking tables need to be reset due to missing synchronization versions, reinitialize them to restore proper tracking and synchronization.

External references

• For further details on managing Azure SQL connectivity and permissions, refer to Azure SQL Database documentation.
• For more information on Data Integration handling of Azure SQL connections, refer to Azure connection topic.

note

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