RVR-MSS-804

1. Issue Summary

   • The error code RVR-MSS-804 indicates that a merge step is attempted on your azure_sql data connector without selecting any keys. In Rivery, performing a merge operation requires specifying a key or a set of keys to determine how data from the source should be matched and updated in the target table. Without defining these keys, the platform cannot execute the merge correctly.

2. Action Steps:

   • Check the loading mode settings in your Rivery platform and confirm it is set to Upsert-Merge.
   • Navigate to the Column Mapping section within your River's configuration.
   • Ensure that you select one or more columns as keys for the merge operation. This involves marking the appropriate columns using the key icon next to them in the column mapping settings .
   • Ensure that the columns selected as keys do not contain NULL values in your source data, as primary keys should not have NULL values .

3. External References:

   • For further details on managing keys for merge operations in Rivery and troubleshooting merge issues, you can visit Rivery's official documentation here: Rivery Documentation on Loading Modes.

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