RVR-MSS-804

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.

Action steps

To resolve the error, follow these 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 .

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.

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.