SAP Knowledge Base Article - Public

2819317 - OData Query With Datetimeoffset Filter Gives "Attribute Value is Not a Number" Error

Symptom

You are running an OData query with a Datetimeoffset filter and it results in the following error:

"Issue occurred during query execution in TREX : attribute value is not a number".

Environment

  • SAP Sales Cloud
  • SAP Business ByDesign

Reproducing the Issue

  1. In Google Chrome, open an URL like: 'https://my<tenantid>.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/CorporateAccountCollection?$format=json&$filter=CreationOn ge datetimeoffset'2019-01-00T00:00:00Z''
  2. Enter the required credentials
  3. Error: "Issue occurred during query execution in TREX : attribute value is not a number"

Cause

Such an error occurs when you enter an invalid date like '2019-01-00' for Datetimeoffset, where '00' for day is not acceptable.

Resolution

Please correct the values for Datetimeoffset to enable a working query.

See Also

2330688 - How to Use Methods And Filters in OData Services

Keywords

datetimeoffset, odata, attribute value is not a number , KBA , AP-RC-ODF , OData framework (C4C Only) , AP-RC-ODF-BYD , OData Framework and Console (ByD) , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions