SAP Knowledge Base Article - Public

3030314 - Calling API API_PRODUCT_SRV or API_BUSINESS_PARTNER ( GET ) causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated

Symptom

  • Calling API API_PRODUCT_SRV  ( GET )  causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated
  • Calling API_BUSINESS_PARTNER ( GET )  causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated

Environment

  • Master Data
  • SAP S/4HANA, Cloud Edition

Reproducing the Issue

Call API API_PRODUCT_SRV or API_BUSINESS_PARTNER ( Method GET ) to return Product Master or Business Partner Master Records

Cause

Dump occuring for the API API_PRODUCT_SRV or API_BUSINESS_PARTNER  failing with error  DBSQL_STMNT_TOO_LARGE

The number of data record selected by filter criteria is large and when all expands are performed then length of where clause in backend becomes too large.

Resolution

We would therefore suggest to adopt your application to send a different request. You can use $top and $skip to retrieve the data in smaller packages. This will result in shorter where clauses as less records are being selected.

Please check the SAP API HUB 
https://api.sap.com/api/API_PRODUCT_SRV/resource

https://api.sap.com/api/API_BUSINESS_PARTNER/resource

Keywords

TRIGGER_DATABASE_FAILURE_DUMP , CL_SADL_SHORTDUMP=============CM009 , '  , 'The Open SQL command is too long', CX_SADL_DUMP_DATABASE_FAILURE,  DBSQL_STMNT_TOO_LARGE, API_PRODUCT_SRV, API_BUSINESS_PARTNER , KBA , LO-MD-MM , Material Master , LO-MD-BP , Business Partners , Problem

Product

SAP S/4HANA Cloud Public Edition all versions