RVR-MSS-802

Issue summary

• You are encountering an error with code RVR-MSS-802 while using the azure_sql data connector on Data Integration, specifically related to a failure in executing a query. This error typically arises due to issues with the connection configuration, query syntax, or Azure SQL settings.

Action steps

To resolve the error, follow these steps:

• Verify Connection Settings: Ensure that all the connection settings for your Azure SQL database in Data Integration are correct. Check the server name, database name, and authentication details.
• Check Firewall and Network Settings: Make sure that the IP addresses used by Data Integration are allowlisted in your Azure SQL Server configuration. If not, connection attempts might fail, causing query execution errors.
• Validate Query Syntax: Double-check the query being executed for any syntax errors or unsupported functions/statements. Data Integration only supports SELECT statements in custom queries without additional SQL scripts.
• Review Azure SQL Logs: Inspect logs in Azure SQL for any specific errors or messages related to the failed query attempt. This might provide more detailed reasons for the failure.

External references

• Azure SQL Documentation
• Data Integration Documentation on Azure SQL

note

If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.