Question: I am getting "Contradicting Values" error during ingest. Why?
Answer: The answer to your question is in the UI, perhaps not provided in a very readable way.
For example, when the system reports error:
{
"ErrorCode": "Contradicting Values",
"Entity": "SubFunds",
"KeyName": "val_is_swingpri",
"KeyDescription": "Swinging Single Pricing (SSP)",
"BusinessKey": "Capital Group Emerging Markets Debt Fund (Lux)",
"RelatedRecordId": "4D80C57A-7E83-EE11-8923-000D3AA93E23",
"DistinctValues": "Full swing NAV,Partial swing NAV"
},
I means that there is a problem with SubFund named "Capital Group Emerging Markets Debt Fund (Lux)"
The incoming file provides two values for field val_is_swingpri: "Full swing NAV", and "Partial swing NAV".
After inspection of the file, we can see:
1) ISIN: LU0533023353, SubFund: "Capital International Portfolios - Capital Group Emerging Markets Debt Fund (Lux)", Single Pricing Type: "partial swing NAV"
2) ISIN: ISIN: LU0533022207, SubFund: "Capital International Portfolios - Capital Group Emerging Markets Debt Fund (Lux)", Single Pricing Type: "full swing NAV"
The system is supposed to change value of val_is_swingpri for the subfund to the value present in the file. But which one? Records relating to the same SubFund provide different values. So the system reports "Contradicting Values" error.
This issue does not prevent entire file from being loaded, it doesn't even affect all fields from given record. Only the value of val_is_swingpri for this particular SubFund will be ignored.
Issue like this may be caused by:
1) Sometimes Kneip's Data Catalogue might have incorrect assumption that given field val_is_swingpri must have the same value for all share classes from the same subfund (i.e. the field level in Data Catalog is incorrect). This is however relatively rare.
2) Sometimes the external source has fund structure issues and says two share classes belong to the same subfund while in reality they belong to two different subfunds.
3) Sometimes the external source provides data for share classes which have been terminated, and subfund values are not being updated to most recent values.
Actions
You would need to analyse Contradicting values by inspecting the input file then ask the file provider (Asset Manager) to explain why records relating to the same subfund have contradicting values. If it is just a mistake the AM should fix the issue on their side. If there is a real need to have multiple values for the same Fund / SubFund we may change the level in Data Catalogue and then move the field to the new level.