SAP Knowledge Base Article - Preview

3490795 - Failed to execute query. QueryFailedError: invalid input syntax for type numeric

Symptom

Application is developed via SAP Build Apps, POST fails, for example in http trace:

Request:
/destinations/SAP-Build-Apps-Runtime/projects/16f243a2-08a7-4aed-b5d8-76fa3ee5a5a5/entity/AAAA

Request Payload:


  1. {url: "", headers: {Accept: "application/json, text/plain, */*", Content-Type: "application/json"},…}
    1. data: "{\"operation\":\"create\",\"record\":{\"Filed1\":\"XXXX\",\"Field2\":\"\"},\"resourceName\":\"AAAA\"}"
    2. headers: {Accept: "application/json, text/plain, */*", Content-Type: "application/json"}
      1. Accept: "application/json, text/plain, */*"
      2. Content-Type: "application/json"
    3. method: "post"
    4. url: ""



Response:

  1. responseText: "{\"code\":\"invalidInputs\",\"message\":\"Failed to execute query. QueryFailedError: invalid input syntax for type numeric: \\\"XXXX\\\"\",\"driverCode\":400}"
  2. status: 400
  3. statusText: "Bad Request"





Read more...

Environment

Application developed via SAP Build Apps

Keywords

SAP-Build-Apps-Runtime, Failed to execute query, QueryFailedError, invalid input syntax for type numeric, SAP Build Apps, Create record , KBA , CA-LCA-ACP , SAP Build Apps , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.