SAP Knowledge Base Article - Public

2760222 - "UPSERT failed for the row with key: Reason: <property> code=bad data type detail=Illegal date-value :<date>" error - Integration Center

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

  1. Create an inbound IC job;
  2. Run it;
  3. 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

  1. Go to OData Dictionary;
  2. Search for the <entity> you are trying to import data into;
  3. Search for the <property> field and check their date format (e.g. datetime);
  4. Correct the input value;
  5. Re-run the IC job;

OBS.: If the date format is "datetime" the correct format is "YYYY-MM-DDThh:mm:ssZ" (e.g. 2022-12-31T00:00:00Z).

See Also

Keywords

inbound, import, importing, input, date, format, error, issue, type, dateformat , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Core 1811