RVR-SYNP-307

1. Issue Summary

   • It seems you're encountering an error while attempting to load data into Azure Synapse using Rivery, with the error code RVR-SYNP-307. This error indicates a failure in the data loading process to Azure Synapse Analytics. Initial diagnosis suggests it could be related to connection issues, incorrect setup, or misconfigured settings required for loading data into Azure Synapse.
   • Possible causes of this error may include network issues, authentication or permissions problems, or configuration errors in the Rivery platform or Azure Synapse settings.

2. Action Steps:

   • Whitelist IP Addresses: Ensure that the IP addresses used by Rivery are whitelisted in your Azure Synapse setup to allow incoming connections from Rivery. You can find instructions on how to whitelist IP addresses here.
   • Check Connection Details: Verify that the Azure Synapse connection configuration in Rivery is correct, including the host, port, database, username, and password. Test the connection using the "Test Connection" feature in Rivery to confirm connectivity.
   • Permissions Review: Make sure that the Rivery user account has the necessary permissions in Azure Synapse to perform data operations. This includes CREATE, INSERT, and other essential permissions.
   • Connection Documentation: Follow the steps outlined in Rivery documentation for setting up Azure Synapse as a target, which includes configuring the connection properly.
   • Monitor Logs: Check logs in both Rivery and Azure for any specific error messages that could give more context to the error. This includes looking into potential transient errors or authentication issues.
   • Loading Modes: Ensure you are selecting the appropriate loading mode (e.g., Upsert-Merge, Append Only) for your data loading strategy as described in Rivery’s documentation.

3. External References:

   • For more detailed information on setting up Azure Synapse Analytics, please refer to the Rivery documentation on Azure Synapse.

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