RVR-MSS-801

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

2. Action 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 whitelisted 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 Rivery and Azure SQL for more detailed error messages that might provide additional context about why the query execution is failing.

3. External References:

   • You can refer to the official Rivery documentation for more details on setting up the Azure SQL data connector to ensure all configurations are correct.
   • Azure SQL troubleshooting and best practices documentation: Azure SQL Troubleshooting Guide.

If the issue persists or you need further assistance, please open a ticket with Rivery support.