RVR-SYNP-200

Issue summary

The error code RVR-SYNP-200 with the message "Failed to get schema" for the azure_synapse data connector indicates a failure in retrieving the schema for a table or database. This error is due to misconfigured connection settings, permissions issues, or network-related problems that prevent schema retrieval from Azure Synapse.

Action steps

To resolve the error, follow these steps:

1. Verify connection: Ensure that the connection to Azure Synapse is properly configured with the correct server name, database name, authentication method, and credentials.
2. Check permissions: Ensure the user account has read and metadata discovery permissions on the database.
3. Review Network security: Check if there are any network restrictions that is preventing access. This includes firewalls or Azure network security groups blocking traffic to and from Azure Synapse.
4. Check for network restrictions: Find out if including firewalls or Azure network security groups that may block traffic to and from Azure Synapse.
5. Review logs from Data Integration: Check error messages or system logs for more details about the issue.

External references

• For more information, refer to the Azure Synapse Data connector topic.
• For more information on troubleshooting steps regarding connectivity and permissions, refer to Microsoft's documentation on managing Azure Synapse Analytics.

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.