RVR-MSS-716

1. Issue Summary

   • You have encountered an error with code RVR-MSS-716 while using the Azure SQL data connector on Rivery's platform. The message "External Error - Failed to Overwrite" 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.

2. Action Steps:

   • 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.
   • Test Connection: Use Rivery's "Test Connection" feature to confirm the connection details are correct and that you can connect to Azure SQL. This helps to verify that the authentication details are properly set up.
   • Check Loading Mode: Confirm that the River is configured correctly to use the Overwrite mode. This mode should be set if you intend to fully replace existing data.
   • 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.
   • Ensure Data Consistency: Before performing an overwrite, it's important 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.
   • Re-attempt Overwrite: If configuration and permissions are verified, try running the River again to see if the issue persists.

3. External References:

   • For further troubleshooting, refer to the Rivery Loading Modes Documentation which details how to configure and troubleshoot loading modes for Azure SQL.
   • It's also advised to review Azure's official documentation on SQL Database Permissions.

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