RVR-SYNP-201

Issue summary

This error code RVR-SYNP-201 with the description Failed to get schema names. indicates an issue with retrieving schema information when establishing a connection or operating on the Azure Synapse data warehouse.

Possible causes and additional context:

• Permission issues: The user connecting to Azure Synapse does not have the necessary permissions to access information about the schemas.
• Network configuration: Firewall settings or IP allowlisting requirements that have not been correctly configured, preventing access to the Synapse server.
• Connection configuration: Incorrect connection string details or set up connection in Data Integration leads to this error.
• Azure Synapse service state: A temporary issue with the Azure Synapse service performance or status.

Action steps

1. Check user permissions: Ensure the user account in the connector has the required permissions for VIEW DEFINITION on the database.
2. Verify network settings: Ensure that Data Integration IP addresses are allowlisted on your Azure account's firewall settings .
3. Review connection details: Confirm that all connection details in Data Integration, such as the hostname, username, and password, are correct.
4. Test the connection: Use Test Connection in Data Integration to verify configuration and confirm Azure Synapse is running in the Azure portal.
5. Check Azure Synapse status: Confirm that Azure Synapse is running by checking its status in the Azure portal.
6. Review logs and alerts: Check for any logs or alerts in Data Integration that might provide more information about the issue.

External references

For more information, refer to the following topics:

• Configure Azure Synapse Analytics with Data Integration
• Allowlist Data Integration IPs on Azure

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.