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 Data Integration, 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 Data Integration 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 Data Integration and troubleshooting merge issues, you can visit Data Integration's official documentation here: Data Integration Documentation on Loading Modes.

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