Symptom
You have an OData API call, or Integration Center Job failing with the following error:
Failed due to - Invalid property names: xxxxx/xxxxx. Please check the property name in Admin Center > OData API Data Dictionary or entity metadata. Ensure there were no data model changes that removed this field, and please execute a refresh metadata to ensure the cache is not corrupted.
(xxxxx/xxxxx relates to Entity/Field)
Environment
- SAP SuccessFactors HXM Suite
- OData API
- Integration Center
Cause
This error message may have different root causes however we are going do address some of the most common here
- There may have been a recent disruption on one of the Data Centers which may have caused a Cache corruption issue.
- The cache may be outdated (the cache gets automatically refreshed throughout the day, but when an API call is made at a time when the cache is outdated, the error can appear)
- The field causing the error have been disabled in manage business configuration
- The field causing the error was previously set to editable and now it was changed to View
Resolution
- For possible causes 1 and 2: the most common way to fix this is simply by running the OData API Metadata Refresh, for that follow the steps below:
- Go to Admin Center;
- Search by OData API Metadata Refresh And Export
- Click in Refresh
- For possible causes 3 and 4: this happens when the field properties are changed such as disabling a field or changing that to only view mode, to fix that please check the steps below:
- Go to Admin Center;
- Search by Manage Business Configuration;
- Find the field you need to fix and update these three properties: Enabled, Visibility, Allow Import
NOTE: When changing these properties please consider the explanation below- If you want this field to be manually populated only during import and or integrations then set the following values for the field:
- Enabled = Yes
- Visibility = View
- Allow Import = Yes
- If you want this field to be manually populated always including integrations and imports then set the following values for the field:
- Enabled = Yes
- Visibility = Edit
- Allow Import = No
- If you want this field to be manually populated only during import and or integrations then set the following values for the field:
- If even after the following all the steps above the issue persists, then please follow the steps on the KBA 2883171 - COE_PROPERTY_NOT_FOUND: [COE0021]Invalid property names: EmpJob/emplStatus. - OData API
See Also
Keywords
Failed due to - Invalid property names, Please check the property name in Admin Center > OData API Data Dictionary or entity metadata. Ensure there were no data model changes that removed this field, and please execute a refresh metadata to ensure the cache is not corrupted, Metadata Refresh , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , How To