RVR-SAPC-509

1. Issue Summary

   • The error MISSING_KEYS_FOR_MERGE_LOADING with Error Code: RVR-SAPC-509 is encountered while using the SAP Concur data connector in Data Integration. This error typically indicates that there's a problem with the primary keys setup necessary for performing a merge operation during the data loading process. In essence, this error suggests that there are missing or incorrectly configured primary keys that are critical for the upsert-merge operation in your data loading configuration.

2. Action Steps:

   • Verify Primary Keys in Table: Ensure that the primary keys are properly defined in your source SAP Concur tables and mapped in Data Integration. For the upsert-merge loading mode to function correctly, the primary keys must not contain any null values and must be consistent across the dataset.
   • Check Loading Mode Settings: If the loading mode is set to upsert-merge, verify that you have correctly set the fields considered as unique keys in the target tables. Double-check the mapping configuration to ensure all necessary columns are included.
   • Examine Column Mapping: Review the column mapping settings in the Data Integration platform to ensure that all required fields for the merge operation are correctly mapped, especially those designated as unique keys.
   • Adjust SAP Concur Integration: For SAP Concur, consider reviewing and adjusting the extraction and integration settings to ensure compatibility with the target table's schema, especially the primary keys【4:0†source】.

3. External References:

   • Data Integration Documentation for SAP Concur Integration
   • General Data Integration Troubleshooting Guide

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