Symptom
After importing picklist values for the same picklist through Import and Export Data tool, all records are rejected / failed even though not all the records are invalid /have the error below.
"Cannot find corresponding Picklist value by key: values.parentPickListValue.externalCode, value ___"
Environment
- SAP SuccessFactors HCM
- SAP SuccessFactors Metadata Framework (MDF)
Reproducing the Issue
Import Example for Parent x Child Picklist relationship:
- Create a parent picklist with externalcode "parent1","parent2","parent3"
- Create a child picklist with externalcode "child1","child2", "child3"
- In the import file template for "Import and Export Data", configure the parent x child relationship as "parent1" for "child1", "parent2" for "child2", "parent4" for "child3"
- Import the file through Import And Export Data > Import Data > Picklist-Values
- Download the job response from the import and the result is "1. Cannot find corresponding Picklist value by key: values.parentPickListValue.externalCode, value: parent4. " for the third record "child3"
- When you check the record for "child1" and "child2", you will find those two records are not associated with parent picklist even if the records in import file are correct for them
Import Example for Picklist with no Parent x Child relationship:
- Create a picklist with externalcode "value1","value2","value3"
- In the import file template for "Import and Export Data", add the externalcode values "value3","value3","value4"
- Import the file through Import And Export Data > Import Data > Picklist-Values
- Download the job response from the import and the result for the records with externalcode value "value3" is "1. Found different data value with same key." while externalcode "value4" has no error / is not invalid
- Notice that on Scheduled Job Manager the job result shows that all the records were Failed and the the"value4" is not available on the picklist
Cause
When the records (picklist values) belong to same picklist, MDF Import will handle them in one transaction. It means that ALL the records will be imported successfully or NONE of them will be imported if there is an error detected in any row.
This is how the system is designed and this is for data integrity concern.
Resolution
In order to correct the wrong record rows, see this KBA: 3251892 - Error 'Cannot find corresponding Picklist value by key' - SAP for Me.
Or exclude the wrong records / rows with an error from the file and import them again.
See Also
Keywords
MDF import, Import and export data, parent picklist, child picklist, cannot find corresponding Picklist value by key, Found different data value with same key, INC3887429 , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem