SAP Knowledge Base Article - Public

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

Symptom

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
Code: COE_GENERAL_SERVER_FAILURE
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.

Environment

  • 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"

Cause

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).

Resolution

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

Keywords

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

Product

SAP SuccessFactors HCM Suite 2405