SAP Knowledge Base Article - Public

2899833 - OData Error Exception 70006930: Attribute Value Is Not A Number


You are unable to add a filter for LastChangeDateTime in OData. An error occurs.

Error: "Error in filter System Query, Operation failed::Issue occurred during query execution in TREX (6930): attribute value is not a number;exception 70006930: attribute value is not a number".


SAP Business ByDesign

Reproducing the Issue

In SAP Business ByDesign:

  1. Go to Application User & Management work center
  2. Click on Custom OData Service view
  3. Click on New 
  4. Create a custom OData service

In Postman:

  1. Create GET request with Expand
  2. Execute GET request 


The date format is incorrect.


The date should be passed in the following format yyyymmddhhmmss.


Fehler in filter-Systemabfrage, Vorgang fehlgeschlagen, Problem beim Ausführen der Abfrage in TREX (6930 ), Projekte im System abrufen, Filter nach Datum, attribute value is not a number, exception 70006930, , KBA , AP-RC-ODF-BYD , OData Framework and Console (ByD) , Problem


SAP Business ByDesign all versions