SAP Knowledge Base Article - Public

3197769 - Calling API API_BILL_OF_MATERIAL_SRV;v=0002 causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated


  Calling API_BILL_OF_MATERIAL_SRV;v=0002  ( Method GET )  causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated


  • Integrated Product Development for Discrete Industries
  • SAP S/4HANA, Cloud Edition

Reproducing the Issue

Call API API_BILL_OF_MATERIAL_SRV;v=0002 ( Method GET ) to return Bill of Material Records


Dump occuring for the API_BILL_OF_MATERIAL_SRV;v=0002  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.


 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.


 TRIGGER_DATABASE_FAILURE_DUMP , CX_SADL_DUMP_DATABASE_FAILURE, CL_SADL_SHORTDUMP=============CM009 , '  , 'The Open SQL command is too long', CX_SADL_DUMP_DATABASE_FAILURE,  DBSQL_STMNT_TOO_LARGE , API_BILL_OF_MATERIAL_V2 , $expand , MaterialBOM , BillOfMaterialItem , KBA , LO-MD-BOM , Bills of Material , LO-MD-BOM-2CL , Bills of Material (Public Cloud) , PLM-FIO-BOM , Fiori UI for Material BOM , Problem


SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions