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
- Go to ODATA API Data Dictionary
- Search for the entity for which the ODATA query is getting executed
- Search for the field for which the error is coming in HCI
- Check the Type for that field
- 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
Product
SAP SuccessFactors HCM Core 1708