RVR-MSS-710

1. Issue Summary

   • The error code RVR-MSS-710 encountered using Azure SQL as a data connector indicates a failure in the Delete-Insert operation. This type of error could be caused by constraints in SQL Server during the deletion or insertion processes, possibly due to issues such as foreign key constraints, triggers, or lack of sufficient permissions.

2. Action Steps:

   • Ensure Permissions: Confirm that the user executing the Delete-Insert operation has adequate permissions on the Azure SQL database table involved. This includes permissions to delete, insert, and manage data on both the source and target tables.
   • Check Constraints: Review any foreign key constraints or triggers on the table. Constraints might prevent deletion or insertion if there are relevant dependencies not handled during the process.
   • Review Transaction Handling: Ensure that the transaction sequence (begin, delete, insert, commit) is correctly implemented and that no step is skipped or incorrectly executed, which can lead to partial completion and error.
   • Analyze Logs: Examine Azure SQL logs for additional error messages or specifics regarding the failed operation to identify any direct causes from the system side.
   • Reinitialize Table: As a troubleshooting step, consider reinitializing the target table if applicable. This can reset the schema in a way that resolves the conflict causing the failure.

3. External References:

   • Refer to Rivery’s official documentation for detailed guidelines on setting up connections and performing operations using Azure SQL.
   • Microsoft’s SQL Server documentation on Delete and Insert operations might provide further insights.

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