SAP Knowledge Base Article - Public

2984045 - Error when sending data from a DateTime type field to a DateTimeOffset type field - Integration Center

Symptom

You have created a Integration Center job that sends data from a SuccessFactors entity to another SuccessFactors entity. You have then mapped a DateTime type field from the source entity to a DateTimeOffset type field in the destination entity. When running the integration, you see the error below:

UPSERT failed for the row with key: . Reason: Property:[dueDate] parse failed: code=bad data type detail=Illegal DateTimeOffset-value :2000-10-10

If you copy the preview payload from Integration Center and send it via OData API, no issue occurs.

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

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Reproducing the Issue

  1. Mapping a DateTime type field (dateOfBirth from User, for example) into a DateTimeOffset field (dueDate from TodoEntryV2)



  2. The Preview shows a proper payload in the DateTimeOffset field:

    "dueDate": "/Date(433555200000+0000)/",

  3. The error occurs when you run the integration.

Resolution

This is known issue currently being verified by Integration Center engineering team. The fix for the issue is currently planned to be applied in 1H 2021 release.

See Also

More info about the SF Release and its dates can be checked in this page of the SF Community portal.

Keywords

integration center, date time offset, date time, odata api, upsert fail, failed, error, sf to sf, successfactors to successfactors, inbound, ic , KBA , LOD-SF-INT-INC , Integration Center , Known Error

Product

SAP SuccessFactors HXM Core all versions

Attachments

Pasted image.png