Symptom
An inbound (import) Integration Center job is failing with the error below:
"<entity>: UPSERT failed for the row with key: Reason: <property> code=bad data type detail=Illegal date-value :<date>. The row will not be processed for subsequent entities"
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create an inbound IC job;
- Run it;
- See the error message in Execution Manager;
Cause
You are trying to import the <date> in the <property> field, but the date format is incorrect.
Resolution
- Go to OData Dictionary;
- Search for the <entity> you are trying to import data into;
- Search for the <property> field and check their date format (e.g. datetime);
- Correct the input value;
- Re-run the IC job;
OBS.: If the date format is "datetime" the correct format must be "yyyy-MM-dd'T'HH:mm:ss'Z' (e.g. 2022-12-31T00:00:00Z).
See Also
- Using the Integration Center (IC guide)
- Using the DateTimeOffset Format (OData guide)
- Using the DateTime Format (OData guide)
Keywords
inbound, import, importing, input, date, format, error, issue, type, dateformat , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem