SAP Knowledge Base Article - Public

2760222 - Integrtaion Center User Import failed for the row with key: Reason: Property:[hireDate] parse failed:code=bad data type detail=Illegal date-value

Symptom

Using Integration Center to upsert User Records

Error:

User: UPSERT failed for the row with key: . Reason: Property:[hireDate] parse failed: code=bad data type detail=Illegal date-value :6/3/1990

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SuccessFactors

Reproducing the Issue

1. Use the value 06/03/1990 as the input value for hireDate in the file used for inbound integration

2. Run the integration Center interface

3. The integration center interface run fails

4. The error message received in the Execution Manager is as follows:

User: UPSERT failed for the row with key: . Reason: Property:[hireDate] parse failed: code=bad data type detail=Illegal date-value :6/3/1990

Cause

The format of the data which is used for hireDate in the file used for inbound integration is incorrect

Resolution

1. Go to ODATA API Data Dictionary > Navigate to User Entity > Search for the field hireDate and check its data type

2. The data type for hireDate is datetime

3. Correct the input value of the hireDate as 1990-03-06T00:00:00Z instead of 6/3/1990 in the file used for inbound integration

4. Re-run the integration center interface with the new set of value

5. The execution would be successfull now

Keywords

Integration Center, User ODATA,  Import failed for the rowwith key, Property:[hireDate] parse failed, code=bad data type detail=Illegal date-value, inbound integration , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Core 1811