Symptom
An Integration Center Job is failing with the following error:
Failed due to - Invalid property names: XXXXXX/YYYYYY. 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.
Where XXXXXX marks the Entity and YYYYYY is the (navigated) Field.
Environment
SAP SuccessFactors HCM Core
- Integration Center
- OData API
Reproducing the Issue
Go to Integration Center and run the job. The error will be visible in the eventLogs csv file under Execution Manager.
Cause
There is a number of potential causes to the issue, including:
- Cache corrupted due to disruption on the Data Center
- Cache is outdated
- Field is disabled or not visible/editable either in Manage Business Configuration or Configure Object Definition.
Resolution
Part of the causes and solutions are already covered in KBA 3146917 - Failed due to - Invalid property names: abcde/vwxyz. 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
In case the issue pertains to an FO Object or custom MDF which has not been configured in BCUI (Manage Buisness Configuration), please refer to below steps.
Field Visibility must be set to either 'Read Only' (for outbound/export job) or 'Editable' (for inbound/upsert job), metadata refreshed so it would also come under the OData API Data Dictionary and Integration Center Configure Fields.
Steps to take:
- Go to 'Configure Object Definitions'
- Select 'Object Definition' in the first box
- Choose XXXXXX (Entity) from the second dropdown list
- Click 'Take Action' > 'Make Correction'
- Search YYYYYY (Field) under Fields and click 'Details'
- Select 'Editable' or 'Read Only' next to Visibility and click Done
- Save the changes at the bottom of the page
- Follow the instructions from KBA2171588 to refresh metadata
See Also
Keywords
Error code 500; Exception Odata; Invalid Property Name; OData API Data Dictionary; Metadata; , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-ODATA , OData API Framework , How To