Symptom
- Failed to get candidate information via OData API.
- Error in Response: "[COE0019]Failed to retrieve result with given criteria".
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Recruiting Management
Cause
This is a generic error and here are some possible causes identified so far:
- The field id "name" is defined as a Standard field in Candidate Profile template. (For Support only: see internal memo)
<field-definition id="name" type="text" required="false" custom="false" anonymize="false" sensitive="false"> - Data type mismatch caused due to a field type change. For example, a Text type field has been changed to Number type or Picklist type.
- The custom picklist field used as a filter is not a reportable field.
Resolution
Possible Cause 1: The field id "name" is defined as a Standard field
- Check if the field id "name" is defined in the Candidate Profile template.
- Set it as CUSTOM field with the attribute custom="true".
- Refresh the metadata via Admin Center > OData API Metadata Refresh.
Note: It is not supported to change the custom attribute via the Manage Templates tool. This change can be done via Provisioning only.
If you are no longer working with an Implementation Partner, you can submit a change request to SAP Support using the approval document downloaded from the following KBA.
- KBA 2258199 - Software Change Request for SuccessFactors Recruiting Management
- Request item: "XML Template Upload due to Manage Templates limitation"
Possible Cause 2: Data type mismatch caused due to a field type change
Please update the field value for existing candidates via OData API or Integration Center.
If you don't know which field caused the error, please open a support ticket and provide details as per KBA 2437841 - Troubleshooting API issues - what you need to provide to Support - Recruiting Management.
Possible Cause 3: The custom picklist field used as a filter is not a reportable field
Please refer to KBA 2372331 - Error: "Failed to retrieve result with given criteria." occurs when trying to filter on a picklist field using OData API - Recruiting Management
Keywords
ODATA query, OData API Candidate Export, Candidate Profile, GET, invalid column name: T.RCM_CANDIDATE, RCM-66130 , KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-CAN , General Candidate Issues (not Offers, not Profiles) , Problem