RVR-LTBQ-102

Issue summary

• The error code RVR-LTBQ-102, encountered when using the RDBMS data connector on Data Integration, indicates that keys were not selected in mapping for a merge operation. This problem arises because no key was set as 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.
• To perform an upsert-merge operation, it is essential to specify keys during column mapping to ensure that the system can identify matching records.

Action steps

To resolve the error, follow these steps:

• Go to the Column Mapping section of your Data Flow 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 Data Flow again to check if you resolve the issue.

External references

• For more information on configuring upsert-merge operations in Data Integration, refer to Data Integration Getting Started topic.
• For a detailed guide on handling data connector errors, refer to Data Connector Setup topic.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.