RVR-SYNP-313

1. Issue Summary

   • Error Code: RVR-SYNP-313
   • Data Connector: azure_synapse
   • Error Description: "Failed loading data into table"
   • Initial Diagnosis: The error RVR-SYNP-313 generally indicates a failure when attempting to load data into an Azure Synapse table using Rivery. This could be caused by data type mismatches, issues with the loading mode, or network/connectivity issues between Rivery and Azure Synapse.

2. Action Steps:

   • Check Data Mapping: Ensure that the data types in the source match those in the Azure Synapse target. Verify that there are no conflicts, especially with numeric and string types. Data type mismatches often cause loading errors.
   • Inspect Loading Mode: Verify the loading mode set in your Rivery configuration. Ensure that it aligns with your requirements (e.g., Upsert-Merge, Append Only). Adjust settings if needed to ensure compatibility.
   • Network Connectivity: Confirm that there are no interruptions in the network connectivity between the Rivery platform and Azure Synapse that could affect data transmission.
   • Review Rivery Logs: Examine the logs provided by Rivery to uncover any additional error messages or warnings that might provide more context or specifics related to the failure.
   • Reinitialize Tables: If issues persist, consider reinitializing the affected table in Azure Synapse. Make sure to back up any data as necessary before proceeding with this action.

3. External References:

   • For more details on supported data types and required configurations for Azure Synapse using Rivery, refer to Rivery's official documentation.
   • For understanding Azure Synapse loading enhancements, review Azure Synapse Analytics documentation.

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