Skip to main content
Feedback

RVR-MSS-716

Issue summary

The error with code RVR-MSS-716 with the message "External Error - Failed to Overwrite" while using the Azure SQL data connector on Data Integration platform indicates an issue related to the overwrite operation. The overwrite method entirely replaces existing data in the target table with new data from the source. The initial diagnosis points towards a potential misconfiguration or permission issue during this operation.

Action steps

To resolve the error, follow these steps:

  1. Verify permissions: Ensure that the Azure SQL Server connection has the correct permissions to overwrite data. Check that the account used for the connection has the necessary privileges to perform DELETE and INSERT operations on the target table.
  2. Test the connection: Use Data Integration "Test Connection" feature to confirm the connection details are correct and that you can connect to Azure SQL. This helps you to verify that the authentication details are properly configured.
  3. Check loading mode: Confirm that the River is configured correctly to use the Overwrite mode. Set this mode if you intend to fully replace existing data.
  4. Review system logs: Examine the Azure SQL logs for any specific error messages or warnings that might provide more context on why the overwrite failed.
  5. Ensure data consistency: Before performing an overwrite, it is essential to back up existing data to prevent data loss, especially if there are inconsistencies in the incoming data that could cause the overwrite to fail.
  6. Re-attempt overwrite: If configuration and permissions are verified, try rerunning the River to confirm if the issue persists.

External references

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.

On this Page