RVR-MSS-715

Issue summary

The error code RVR-MSS-715 indicates a failure to retrieve table names from an Azure SQL data connector. This error is linked to issues with access permissions, change tracking, or server availability.

Initial Diagnosis: The error may be due to missing permissions, server connectivity issues, or issues with change tracking settings in the Azure SQL instance.

Action steps

To resolve the error, follow these steps:

1. Check permissions: Ensure that the user account used by Data Integration 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.
2. Server connectivity: Verify that the Azure SQL server is up and running. Ensure that no network issues are preventing Data Integration from connecting to the database. Also, ensure that the required IP addresses are allowlisted.
3. 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.
4. Review logs: Examnine server logs for any messages related to access permissions or change tracking. This provides information on whether the Data Integration service can connect and query the database properly.

External references

For more information, refer to the following topics:

• Data Integration Azure SQL as a Target
• Azure SQL Database Change Tracking

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.