SAP Knowledge Base Article - Public

2880916 - Error "ServerErrorException" when filtering "postingStatus" field of JobRequisitionPosting entity - Integration Center

Symptom

You created a Scheduled CSV File Output starting on JobRequisitionPosting entity and, when trying to create a new filter on "postingStatus" field, the error below appears:

JobRequisitionPosting_1.jpg

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 HXM Suite
    • Integration Center

Cause

If you go to "OData Data Dictionary" screen and access JobRequisitionPosting entity information, you'll see that "postingStatus" field is nullable = false.

When first creating the filter, its standard value will be null:

JobRequisitionPosting_2.jpg

Integration sends this info to the API server right away and, since the filter is not nullable, the error returns.

Resolution

Ignore, close the error message and continue building the filter as you would. It will work properly.

In some cases, the filter only works with the following criteria = jobReqPostings/postingStatus ne null.  (Job Posting Status   is not equal to null - leave the field blank in the Integration center UI).

See Also

Integration Center guide

Keywords

successfactors, success factors, sf, sfsf, integration center, ic, blank, empty, value, null, property, field, advanced filters, error message, status: internal server error, status code: 500, error loading preview data , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Suite all versions