Skip to main content
Feedback

RVR-MSSQL-RDBMS-301

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 Data Integration cannot retrieve, 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, 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.

Action steps

To resolve the error, follow these steps:

  • Reinitialize the Table: You need to reinitialize the table data to ensure the synchronization version metadata is reset. Navigate to your Data Flow's schema settings in Data Integration, and select "Set initiate migration for all tables" from the options menu.
  • Verify Change Tracking/CDC Configuration:
    • ensure you enable Change Tracking for the database and tables.
    • Check that the SQL Server Agent is running, as it is mandatory 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.

External references

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

On this Page