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
Error Code: RVR-MSS-50002Likely causes
- Change Tracking is not enabled, or cleanup removed change-tracking data.
- Connection setup or database configuration problems.
03How to fix it
- Enable Change Tracking for the database and tables.
- Check the SQL Server logs for change-tracking messages.
- If there are problems with
last_sync_version, re-initialize the table data. - Check whether cleanup settings remove change-tracking data.
- Allow Data Integration IP addresses on the Azure SQL server.
- Use Test Connection on the connection in Data Integration.
04Official documentation
→Related errors
- 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-MSSQL-RDBMS-202: failed to get last synchronization version for tableRVR-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.
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