RVR-LTBQ-102

1. Issue Summary

   • The error code RVR-LTBQ-102, encountered when using the RDBMS data connector on Rivery, indicates that keys weren't selected in mapping for a merge operation. This problem arises because no key was designated to identify unique records for the upsert-merge process. The upsert-merge mode requires keys to match and decide whether to replace, keep, or add records【4:1†source】.
   • To perform an upsert-merge operation, it is essential to specify keys during column mapping to ensure that the system can identify matching records【4:7†source】.

2. Action Steps:

   • Go to the Column Mapping section of your River configuration.
   • Select the fields you wish to use as keys by clicking the key symbol next to the field names. Ensure that the selected fields make a unique combination for accurate upsert-merge operations【4:6†source】.
   • Save the mapping configuration once you have specified your key fields.
   • Test the River again to check if the issue is resolved.

3. External References:

   • For more information on configuring upsert-merge operations in Rivery, please visit Rivery Documentation.
   • For a detailed guide on handling data connector errors, see Data Connector Setup.

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