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 Data Integration. This could be caused by data type mismatches, issues with the loading mode, or network/connectivity issues between Data Integration 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 Data Integration 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 Data Integration platform and Azure Synapse that could affect data transmission.
   • Review Data Integration Logs: Examine the logs provided by Data Integration 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 Data Integration, refer to Data Integration 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 Data Integration support.