RVR-SAPC-509
  • 1 Minute to read
  • Dark
    Light
  • PDF

RVR-SAPC-509

  • Dark
    Light
  • PDF

Article summary

  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 Rivery. 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 Rivery. 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 Rivery 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:

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


Was this article helpful?

What's Next