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

Boomi error
Failed to get last synchronization version for table. Error Code: RVR-MSSQL-RDBMS-202

02Likely causes

  • A missing minimum valid version or last synchronization version, which can follow improper cleanup.

03How to fix it

  1. Confirm Change Tracking is enabled for both the database and the table.
  2. If the minimum valid version is wrong or last_sync_version is not received, re-initialize the table from Data Integration.
  3. Review the SQL Server logs for change-tracking messages.
  4. Review the database cleanup schedule so it keeps the change-tracking data you need.

04Official documentation

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.