Skip to main content
Feedback

RVR-MSS-801

Issue summary

  • The error code RVR-MSS-801 encountered when using the Azure SQL data connector indicates a failure to execute a query. Typically, this can be related to a variety of issues including incorrect connection configuration, network problems, or query syntax issues. Without specific details about the situation when the error occurred, it is difficult to pinpoint the exact cause.

Action steps

To resolve the error, follow these steps:

  • Verify Connection Settings: Ensure that all connection details (hostname, database name, credentials) are correctly configured. Incorrect credentials or metadata might lead to unsuccessful connection attempts.

  • Check Network and Firewall Settings: Verify network availability and ensure that firewall settings allow connections to Azure SQL. It might be necessary to check if the IP address from which the connection is being established is allowlisted in the Azure SQL server firewall settings.

  • Review Query Syntax: Ensure the query syntax is correct and that the user has the necessary permissions to execute the specified queries. It might be useful to manually run the same query directly in a SQL client against the Azure SQL database to check for syntax errors.

  • Review Logs and Error Messages: Check any logs within Data Integration and Azure SQL for more detailed error messages that might provide additional context about why the query execution is failing.

External references

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.

On this Page