RVR-MSS-708

Issue summary

• The error code RVR-MSS-708 is related to an external error during a merge operation with the Azure SQL data connector in Data Integration. This generally indicates issues with the configuration or execution of the merge operation.
• Initial diagnosis suggests checking for misconfigurations or issues within the merge statement or related configurations in the Azure SQL settings.

Action steps

To resolve the error, follow these steps:

1. Verify configuration: Ensure that the primary keys are correctly defined in your source tables, as a lack of primary keys can lead to failure in Merge operations.
2. Reinitialize tables: If there's a possibility of missing synchronization versions due to cleanup processes, it might be necessary to reinitialize the tables involved.
3. Check loading mode: Confirm that the 'Upsert-Merge' loading mode is set correctly, as this is essential for performing merge operations in Data Integration.
4. Analyze logs: Review MSSQL server logs for any messages related to change tracking or cleanup operations. This can provide insights into any underlying issues affecting the merge process.
5. Concurrency issues: Ensure that no multiple processes are trying to synchronize concurrently with change tracking, as this might lead to conflict issues.

External references

• For more detailed information on configuring Azure SQL as a data target, you can refer to Data Integration documentation on Azure SQL.
• For troubleshooting merge operations and related error messages, refer to the specific documentation on SQL Server.

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.