RVR-MSS-715

1. Issue Summary

   • Error Code: RVR-MSS-715 indicates a failure to retrieve table names from an Azure SQL data connector. This error is often linked to issues with access permissions, change tracking, or server availability.
   • Initial Diagnosis: The error might be caused by missing permissions, server connectivity issues, or problems with change tracking settings in the Azure SQL instance.

2. Action Steps:

   • Check Permissions: Ensure that the user account used by Rivery has the necessary permissions to access and list the tables in the Azure SQL database. Verify that the permissions include "SELECT" on the schema and tables.
   • Server Connectivity: Verify that the Azure SQL server is up and running. Ensure that there are no network issues preventing Rivery from connecting to the database. Also, ensure that required IP addresses are whitelisted.
   • Change Tracking: Confirm that Change Tracking is enabled for the database and the specific tables you are trying to access. You can run SQL queries to check the status of Change Tracking.
   • Review Logs: Examine server logs for any messages related to access permissions or change tracking. This can provide clues on whether the Rivery service is able to connect and query the database properly.

3. External References:

   • Rivery Azure SQL as a Target Documentation
   • Azure SQL Database Change Tracking

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