SAP Knowledge Base Article - Public

2573695 - org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression

Symptom

Error in HCI

org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression: 'lastModifiedDateTime ge datetime'2017-11-28T00:00:00''., cause: org.apache.olingo.odata2.api.uri.expression.ExpressionParserException: Operator "ge" incompatible with operand types "Edm.DateTimeOffset" and "Edm.DateTime" at position 22 in "lastModifiedDateTime ge datetime'2017-11-28T00:00:00'"

while executing an ODATA Query with filter lastModifiedDateTime ge datetime'2017-11-28T00:00:00

Environment

SAP Cloud Platform Integration

Cause

  • This error occurs when there is a mismatch in the Type (datetimeoffset, datetime, etc) of the data that is being used in the operand in the comparison operator for the entity

Resolution

  1. Go to ODATA API Data Dictionary
  2. Search for the entity for which the ODATA query is getting executed
  3. Search for the field for which the error is coming in HCI
  4. Check the Type for that field
  5. Correct the query with the Type that you have found in step no 4.

Keywords

  • HCI
  • ODATA
  • org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression
  • org.apache.olingo.odata2.api.uri.expression.ExpressionParserException
, KBA , failed to invoke method: , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-HCI , Standard SF to 3rd Party CPI (HCI) Content , Problem

Product

SAP SuccessFactors HCM Core 1708