SAP Knowledge Base Article - Public

2931562 - Illegal instant due to time zone offset transition error in SuccessFactors OData API

Symptom

You are running queries or insert/upserts in SuccessFactors OData API entities and you got the following error in the response:

Illegal instant due to time zone offset transition

Environment

  • SuccessFactors HCM HXM Suite
    • OData API

Reproducing the Issue

Run a query or upsert in dates where the timezone what changes, like day light saving, samples below:

  • Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1989-04-16T00:00:00.000 (Asia/Shanghai)
  • Cannot parse "2020-03-29T02:00:10": Illegal instant due to time zone offset transition (CET)

Cause

OData API error code not being posible to handle these situations.

Resolution

This fix will be implemented in the b2011 release (internal incident code API-5459).

As workaround for now, please avoid these date/times that causes the issue, for example, you can query 1 day or 1 hour earlier:

Before:

odata/v2/FOCompany?$filter=lastModifiedDateTime+gt+datetime'2020-03-29T02:00:10Z'+or+createdDateTime+gt+datetime'2020-03-29T02:00:10Z'

After:

odata/v2/FOCompany?$filter=lastModifiedDateTime+gt+datetime'2020-03-28T02:00:10Z'+or+createdDateTime+gt+datetime'2020-03-28T02:00:10Z'

Keywords

Illegal instant due to time zone offset transition, OData API, SuccessFactors HXM Suite, Response, error, timezone, failure, integration, query, upsert, API-5459. , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-MDF , Metadata Framework API (MDF) , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem

Product

SAP SuccessFactors HXM Suite all versions