Boomi · Data Integration: Azure SQL

RVR-MSS-500: Azure SQL internal error

Short answer

RVR-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.

VerifiedLast verified

01Error text

Boomi error
Error Code: RVR-MSS-500

02Likely causes

  • Change Tracking is not enabled, or cleanup removed change-tracking data.
  • Connection setup or database configuration problems.

03How to fix it

  1. Enable Change Tracking for the database and tables.
  2. Check the SQL Server logs for change-tracking messages.
  3. If there are problems with last_sync_version, re-initialize the table data.
  4. Check whether cleanup settings remove change-tracking data.
  5. Allow Data Integration IP addresses on the Azure SQL server.
  6. Use Test Connection on the connection in Data Integration.

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.