RVR-SAPC-509

Issue summary

The error MISSING_KEYS_FOR_MERGE_LOADING with Error Code: RVR-SAPC-509 occurs while using the SAP Concur data connector in Data Integration. This error typically indicates that there is 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.

Action steps

To resolve the error, follow these 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 you set the loading mode 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 appear.
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.

External references

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.