SAP Knowledge Base Article - Public

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

Symptom

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".

Environment

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 

Cause

The date format is incorrect.

Resolution

The date should be passed in the following format yyyymmddhhmmss.

Keywords

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

Product

SAP Business ByDesign all versions