RVR-SYNP-320

1. Issue Summary

   • The error with code RVR-SYNP-320 occurs when attempting to create a master key in Azure Synapse during data source connections using Data Integration. This error is often related to the setup of the Azure Synapse Analytics environment or permissions needed for Data Integration to create and manage resources within Azure Synapse Analytics.

2. Action Steps:

   • Verify SQL Permissions:
     • Ensure the Data Integration service account has the necessary permissions to create a master key in Azure Synapse. This typically requires CONTROL permission on the database.
   • Check Synapse Setup:
     • Ensure that Azure Synapse Analytics is set up correctly and that all necessary prerequisites are met, including proper subscription and resource group configurations.
   • Whitelist IPs:
     • Confirm that Data Integration IP addresses have been whitelisted in your Azure Synapse configuration. This is crucial for establishing a connection.
   • Database Configuration:
     • Make sure the database in Azure Synapse is configured correctly to allow key creation. This might include checking the SQL Server's security policies and ensuring no restrictions are interfering with the key creation process.
   • Azure Portal Logs:
     • Consult Azure portal logs for any additional insights or error messages that may indicate what might be preventing the master key creation.

3. External References:

   • You can refer to Microsoft's Azure Synapse documentation for more details on configuring Azure Synapse securely and understanding its permission model.
   • For additional troubleshooting assistance related to Data Integration, see the Data Integration documentation on Azure Synapse for more specific setup instructions.

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