RVR-SYNP-315

1. Issue Summary

   • The error code RVR-SYNP-315 when using the Azure Synapse data connector indicates a failure in inserting options. This error typically arises due to configuration issues or discrepancies in the expected setup.
   • Initial diagnosis points to potential problems with the data load settings or target table configuration in Azure Synapse.

2. Action Steps:

   • Verify Connection Settings: Ensure that the Azure Synapse connection settings, including authentication method and any custom configurations, are properly set up.
   • Check Table Configuration: Double-check the table into which you're attempting to load data for any mismatches in schema definitions or constraints that could prevent data insertion.
   • Review and Adjust Loading Modes: Ensure that the loading mode set in Rivery matches the capabilities and configurations of your target Azure Synapse table.
   • Consult SQL Execution: Use SQL Server Management Studio to verify that SQL instructions are properly formatted and executed in Azure Synapse. Testing against a smaller dataset can help isolate the issue.
   • Review Server Logs: Inspect logs for any errors related to the failure, which could provide more specific guidance on the inserted options' failure.

3. External References:

   • Rivery Documentation on Azure Synapse
   • Azure Synapse Documentation

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