RVR-SYNP-306

1. Issue Summary

   • The error encountered is "Failed uploading file into Azure Synapse instance. Error Code: RVR-SYNP-306." This specific error indicates a failure during file upload processes to an Azure Synapse instance. This problem often occurs due to connectivity or configuration issues, such as misconfigured IP whitelisting, incorrect credentials, or unsupported configurations when setting up the connection to Azure Synapse.

2. Action Steps:

   • Verify IP Whitelisting: Ensure that Data Integration IP addresses are whitelisted in your Azure Synapse configuration. You can find a guide on Data Integration documentation for how to whitelist IP addresses here.
   • Check Connection Settings: Double-check your connection settings in Data Integration to make sure the correct hostname, database, username, and password are all entered correctly. Additionally, test the connection through the Data Integration interface to confirm connectivity.
   • Review Account Permissions: Ensure that the user account used for the connection has the necessary permissions to read and write data into the Azure Synapse instance.
   • Custom File Zone: If you are using a Custom File Zone, validate its configuration and ensure it is set up correctly. Alternatively, you can use the default FileZone provided by Data Integration if no specific staging area is required.
   • Review Azure Synapse Setup: Follow the detailed setup instructions for Azure Synapse provided by Data Integration to ensure every step is configured correctly.

3. External References:

   • Data Integration Documentation on Azure Synapse Setup - This guide provides an in-depth walkthrough of setting up Azure Synapse with Data Integration.
   • Azure Synapse Analytics Documentation - Official Microsoft documentation for troubleshooting and general setup.

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