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 Rivery. This error is often related to the setup of the Azure Synapse Analytics environment or permissions needed for Rivery to create and manage resources within Azure Synapse Analytics.

2. Action Steps:

   • Verify SQL Permissions:
     • Ensure the Rivery 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 Rivery's 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 Rivery, see the Rivery documentation on Azure Synapse for more specific setup instructions.

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