SAP Knowledge Base Article - Public

3460719 - Error "[COE0019]Failed to retrieve result with given criteria" when querying EmpPayCompRecurring - OData API


Integration Center failing with the error below if the integration has starting entity EmpPayCompRecurring and filters navigating to EmpJob:

[COE0019]Failed to retrieve result with given criteria
Status: Internal Server Error
Status code: 500

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


  • SuccessFactors b2405 instances

Reproducing the Issue

  1. Steps to reproduce in Integration center:
    1. Go to integration center and open the integration with the error
    2. Error 500 will pop up right away
    3. Then go to advanced filter and remove any filter accessing empJob entity
    4. The error will disappear
    5. Then add any other filter which is NOT navigating to empjob and notice the error won't show
    6. Finally add any filter from empJob and notice the issue comes bacj
  2. Steps to reproduce via API
    1. Same issue is reproduced via API, just query on EmpPayCompRecurring and use a filter that navigates to EmpJob
    2. API call with fail with error "Failed to retrieve results with given criteria"


This is a regression issue which was introduced with 2405.

The expected (and intended) behavior for MCPD (multiple changes per day) entities as-of-date queries is that it only returns the one with max sequence number on an active date (internally, this means the API it needs an extra SQL snippet to restrict the condition).

Before the above change was introduced, all MCPD entities had the same snippet, meaning that for API calls such as EmpPayCompRecurring $filter=employmentNav/jobInfoNav/businessUnit eq 'xxx', the SQL snippet needed to be appended twice: one for EmpPayCompRecurring and one for EmpJob.The idea behind our internal fix, was to make a more specific part for EmpPayCompRecurring, however as a side-effect we found out that this method is always passing the EmpPayCompRecurring as the target entity (instead, it should pass EmpPayCompRecurring the first time and EmpJob the second time, thus the reported issue arises).


The root cause of this issue has already been found and the correction will come on Patch P2 on May 2nd


release, defect, known issue, KI2405, integration centre, api, ECT-227589, ECT-234994 , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Known Error


SAP SuccessFactors HCM Suite 2405