RVR-MSS-710

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 error occurs when SQL Server encounters constraints during insert or delete operations, such as foreign key constraints, triggers, or insufficient permissions.

Action steps

To resolve the error, follow these steps:

1. Check 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.
2. Check constraints: Review any foreign key constraints or triggers on the table. Constraints might prevent deletion or insertion if relevant dependencies are not handled during the process.
3. 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 errors.
4. 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.
5. Reinitialize table: Reinitialize the target table if applicable. This can reset the schema to resolve the conflict causing the failure.

External references

• Refer to Data Integration’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 for further insights.

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.