Boomi · Data Integration: Azure SQL
RVR-MSS-501: Azure SQL external general error
Short answer
RVR-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.
VerifiedLast verified
01Error text
Error Code: RVR-MSS-50102Likely causes
- Connectivity or configuration problems, often Azure SQL server settings or network connectivity.
03How to fix it
- Check the Azure SQL firewall settings for IP address restrictions.
- Confirm the credentials have the needed rights on the databases and tables.
- Test the connection outside Data Integration with a SQL tool such as Azure Data Studio.
- Review the logs in Azure SQL and in Data Integration.
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-IPAL-001: IP address allowlist check failedRVR-IPAL-001 means the connecting IP addresses are not in the allowlist of the service you are connecting to. Add the Data Integration IP addresses to that service's inbound rules.
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