RVR-CPA-204

Issue summary

This error code RVR-CPA-204 with message Key was not selected from mapping to merge." indicates that a key was not properly selected in the mapping settings for performing a merge operation in Data Integration. The mapping configuration must define proper keys to accurately match and merge data from Coupa into the specified target. Without selecting a key, Data Integration cannot determine which records to update or insert during the merge process.

Action steps

To resolve the error, follow these steps:

1. Verify Mapping Settings: Confirm the a primary key selection in the mapping configuration for the target table. This key is critical for identifying and merging records correctly.
2. Check Data Integration Merge Configuration: Navigate to the Columns Mapping or Schema tab in your Data Integration configuration and ensure to set the primary key. You can set the key by selecting the key icon next to the relevant field(s), turning it yellow, which designates it as a primary key.
3. Redefine or Adjust Merge Keys:
   • If a primary key was initially defined but the error persists, verify that the selected key accurately reflects the unique identifier for your data.
   • Consider adjusting or redefining the key(s) used for the merge operation. Sometimes, using a composite key by selecting more than one field can resolve the issue.
4. Check Source and Target Definitions: Double-check if the source and target tables or schemas defined are correct with regard to the expected input and output structures.

External references

For more information, refer to Data Integration data loading modes and schema mappings 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.