RVR-SAPC-509
- 1 Minute to read
- Print
- DarkLight
- PDF
RVR-SAPC-509
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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.
- The error
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】.
External References:
If the issue persists or you need further assistance, please open a ticket with Rivery support.
Was this article helpful?