Symptom
- Calling API_BILL_OF_MATERIAL_SRV;v=0002 ( Method GET ) causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated
- 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:
- Call API API_BILL_OF_MATERIAL_SRV;v=0002 ( Method GET ) to return Bill of Material Records
- Dump occurs
Scenario B Involving Maintain Bill of Material app :
- Access the app 'Maintain Bill of Material'
- Input search criteria like plant , BOM usage
- Press Go
- Press button 'Export Table'
- 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