SAP Knowledge Base Article - Public

3372631 - Error in EmpCostAssignmentItem: [COE0019]Failed to retrieve result with given criteria


When performing an OData API query on EmpCostAssignmentItem entity, the error below occurs:

"[COE0019]Failed to retrieve result with given criteria"

This error also occurs in Integration Center, the error is this one below:

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

The issue also occurs when the query is performed in EmpCostAssignment with an expand to EmpCostAssignmentItem, for example:

GET odata/v2/EmpCostAssignment?$expand=items


  • SAP SuccessFactors HXM Suite
    • OData API
    • Integration Center


This issue was already identified as a defect.

The current plan is to fix it through a patch which will occur on these dates:

  • Preview deployment is 18-Sep-23
  • Production deployment is 21-Sep-23

Workaround: perform the query with the parameter "$tempTableSize=1". For example:

GET odata/v2/EmpCostAssignment?$expand=items&$tempTableSize=1

This workaround is not valid for Integration Center. On Integration Center scenario there isn't a workaround available.


expand, items, EmpCostAssignment, 500, criteria, employee, cost, assignment, MDF-83915 , KBA , LOD-SF-INT-MDF , Metadata Framework API (MDF) , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem


SAP SuccessFactors HXM Suite all versions