Boomi · Data Integration: Microsoft SQL Server
RVR-MSSQL-RDBMS-202: failed to get last synchronization version for table
Short answer
RVR-MSSQL-RDBMS-202 means Data Integration could not get a table's last synchronization version through Change Tracking. Confirm Change Tracking is enabled for the database and table, then re-initialize the table if needed.
VerifiedLast verified
01Error text
Failed to get last synchronization version for table. Error Code: RVR-MSSQL-RDBMS-20202Likely causes
- A missing minimum valid version or last synchronization version, which can follow improper cleanup.
03How to fix it
- Confirm Change Tracking is enabled for both the database and the table.
- If the minimum valid version is wrong or
last_sync_versionis not received, re-initialize the table from Data Integration. - Review the SQL Server logs for change-tracking messages.
- Review the database cleanup schedule so it keeps the change-tracking data you need.
04Official documentation
→Related errors
- RVR-MSS-500: Azure SQL internal errorRVR-MSS-500 is an internal error in the Azure SQL connector that points to connection setup or database configuration, most often Change Tracking or cleanup. Verify Change Tracking and re-initialize affected tables.
- RVR-MSS-501: Azure SQL external general errorRVR-MSS-501 is an external general error from the Azure SQL connector, usually server settings or network connectivity. Check the Azure SQL firewall and the credentials' rights.
- RVR-MYSQL-RDBMS-302: cannot retrieve column descriptions (MySQL)RVR-MYSQL-RDBMS-302 means the connector could not retrieve column descriptions from MySQL. Check the user's access to INFORMATION_SCHEMA and look for unsupported table or column names.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Boomi work:Open Boomi jobsBoomi rates and salaries