Skip to main content
Feedback

RVR-MSSQL-RDBMS-207

Issue summary

  • The error "Failed because of mismatch between versions" with Error Code: RVR-MSSQL-RDBMS-207 relates to a synchronization issue between Data Integration and the MSSQL server due to version mismatches. This commonly occurs when the change tracking or change data capture setup on SQL Server does not align with what Data Integration expects, leading to data extraction failures.

Action steps

To resolve the error, follow these steps:

  • Verify Minimum Valid Version: Check if the issue occurs because of min_valid_version being zero or if last_sync_version is missing. Without these, the change tracking data cannot retrieve properly, and you might need to reinitialize the table.
  • Investigate Cleanup Processes: Automated cleanup processes might remove required change tracking data. Review the MSSQL server's logs for any cleanup process that might affect synchronization.
  • Examine SQL Server Agent: Ensure the SQL Server Agent is running if your server is on an Azure SQL Server Virtual Machine. This may require starting the service manually.
  • Reinitialize the Table: If synchronization versions are missing or mismatched, reinitialize the table from within Data Integration. Navigate to your River's Schema and choose "Set initiate migration for all tables".
  • Review Table Activities: Check for frequent updates/deletions in the table without corresponding inserts, which might manage how change tracking Data Integration stores data and could lead to malfunctions.
  • Check for Concurrency Issues: Ensure that there’s no concurrent process trying to use the same change tracking information, as this could lead to conflicts.

External references

  • For more detailed guidance, visit Data Integration official documentation on SQL Server Connection, particularly the sections dealing with Change Tracking and troubleshooting Data Integration MSSQL integrations.
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.

On this Page