SAP Knowledge Base Article - Public

3094104 - Error "Failed to retrieve result with given criteria" when using FOLocation > FOCorporateAddressDEFLT navigation

Symptom

You are performing an OData API query which has a FOLocation > FOCorporateAddressDEFLT navigation (locationNav/addressNavDEFLT or just addressNavDEFLT when querying FOLocation directly) and it fails with the error below:

"Failed to retrieve result with given criteria"

Environment

  • SAP SuccessFactors HXM Suite
    • OData API

Cause

An internal mismatch occurs in the API internal logic when processing the query, causing the issue.

Resolution

This is a known issue which is planned to be fixed in 2H 2021 release.

As a workaround, please add in the $select statement the field 'addressNavDEFLT/startDate'. This will manually fix the internal issue that is occurring.

Keywords

COE_GENERAL_SERVER_FAILURE, COE0019, 500, http, failure, addressNavDEFLT, startDate, addressNavDEFLT/startDate, sf, successfactors , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Known Error

Product

SAP SuccessFactors HXM Suite all versions