Symptom
OData API Query for JobRequisition entity doesn’t return any data but returns the below error:
<code>COE_GENERAL_SERVER_FAILURE</code>
<message lang="en-US">Failed to retrieve result with given criteria.</message></error>
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
Recruitment Management
Cause
- The JobRequisition XML templates do not have the defaultLanguage
- And there is no NULL check in the code as well to handle this type of API request.
Resolution
Please perform the following to resolve this error.
1) Update all the JobRequisition templates in provisioning with the defaultLanguage. Including inactive ones
2) Refresh the Odata API metadata cache after updating the jobreq template.
Please follow the KBA 2171588 which explains how to refresh the Odata API metadata
An example xml of the defaultLanguage is shown below:
<field-definition id="defaultLanguage" type="text" required="false" custom="false">
<field-label><![CDATA[Default Language]]></field-label>
<field-label lang="en_US"><![CDATA[Default Language]]></field-label>
<field-description><![CDATA[Default Language]]></field-description>
</field-definition>
See Also
KBA 2344135 - Job Requisition - Implementation Tips & Tricks from Support - Recruiting Management
Keywords
COE_GENERAL_SERVER_FAILURE, Failed to retrieve result with given criteria , KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM , Recruiting Management , Problem