SAP Knowledge Base Article - Public

2659419 - ODATA Execution Error Code: 500-ServerErrorException Internal Server Error - Illegal character in query at index xx

Symptom

You are running OData API query and you received the following error message:

  • [EXCEPTION] ODATA Execution Error Code: 500-ServerErrorException Internal Server Error-java.net.URISyntaxException: Illegal character in query at index xx: 

Environment

SuccessFactors - OData API

Reproducing the Issue

Run your OData API query and observe this response error

Cause

illegal character in the OData URL

Resolution

Copy your query in some text editor like Notepad++

In the example below, we can see one illegal character (>) in the OData query at the position/Col equals 67.

In this case, the error message will be =   ODATA Execution Error Code: 500-ServerErrorException Internal Server Error - Illegal character in query at index 67

Please remove this incorrect char and the query will run successfully.

col_67.PNG

More details about how you can build OData queries in SF, please use refer to our OData Developer handbook.

See Also

SAP SuccessFactors HCM Suite OData API: Developer Guide:

https://help.sap.com/viewer/d599f15995d348a1b45ba5603e2aba9b/latest/en-US/61afa1d53828488fa15356b0f3d7e049.html

Keywords

  • ODATA Execution Error Code: 500-ServerErrorException Internal Server Error - Illegal character in query at index xx
  • SuccessFactors OData API error in query
, KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , How To

Product

SAP SuccessFactors HCM Core all versions