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

Symptom

  1. Calling API_BILL_OF_MATERIAL_SRV;v=0002  ( Method GET )  causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated
  2. The app Maintain Bill of Material shows popup with 'Unexpected server response' when exporting the results using 'Export Table' button

Environment

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

Reproducing the Issue

Scenario A Involving API  API_BILL_OF_MATERIAL_SRV;v=0002:

  1. Call API API_BILL_OF_MATERIAL_SRV;v=0002 ( Method GET ) to return Bill of Material Records
  2. Dump occurs

Scenario B Involving Maintain Bill of Material app : 

  1. Access the app 'Maintain Bill of Material'
  2. Input search criteria like plant , BOM usage
  3. Press Go
  4. Press button 'Export Table'
  5. popup appears with 'Unexpected server response'

Cause

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.

Resolution

 Scenario A Involving API_BILL_OF_MATERIAL_SRV;v=0002 : 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.

 Scenario B Involving Maintain Bill of Material app :  Reduce the number of total entries by adding more filter values in the filter bar OR Reduce the number of columns in the settings of the table itself

Keywords

 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

Product

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