RVR-SYNP-315

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.

Action steps

To resolve the error, follow these 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 Data Integration 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.

External references

• Data Integration Documentation on Azure Synapse
• Azure Synapse Documentation

note

If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.