SAP Knowledge Base Article - Public

3027067 - Integration Center: Error In IC report when selected LAST with additional filter on filed

Symptom

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

There is an error in IC.

"Unable to understand API request with character sequence: employmentNav/LAST]/compInfoNav,employmentNav/compInfoNav at character position number: 18 invalid characters: ]/compInfoNav,employmentNav/compInfoNav. Refer to https://help.sap.com/viewer/d599f15995d348a1b45ba5603e2aba9b/PRODUCTION/en-US for correct API syntax and examples. Code: ServerErrorException"

Status: Internal Server Error

Status Code: 500

While navigating through 1:M (Many relationship) navigation at least twice and selecting the <Last> record plus adding additional filter to the second 1:M navigation.

 

 

Environment

  • SAP SuccessFactors HXM Core
  • Integration center

Reproducing the Issue

Steps to replicate issue:

  1. Create a simple output IC job and select the Biographical Information as Starting Entity.
  2. Add a new field with the following path.
      
    employmentNav/Employment Details /Compensation Information / Compensation Information

  3. Set the field filters.
      
    Employment Details <Last> and userId ==XXXX.

With Picklist:

  1. Create a simple output IC job and select the EmpEmployment as Starting Entity.
  2. Add a new field with the following path.
      
    jobInfoNav/jobCodeNav/jobLevelNav/picklistLabels/label(label)
      
  3. Set the field filters.
      
    Job information <Last> and PicklistLabel <locale>==en_GB.

Cause

The issue is appearing because in the query for parameter "LAST" there is no starting square bracket which is leading to the Syntax exception.

Resolution

  • Engineering team is currently working on the issue and they will patch the issue with b2105 release.
  • This is currently fixed in B2105 Preview
  • This will be fix on B2105 Production at 21st - 22nd of May 2021.

Keywords

LAST], 18 invalid characters, Last, filter, Integration Center , KBA , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HXM Core 2011