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

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

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'

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.

 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

 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