Symptom
Calling API_CLFN_PRODUCT_SRV ( Method GET ) causes: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated
Environment
- Classification
- SAP S/4HANA, Cloud Edition
Reproducing the Issue
Call API_CLFN_PRODUCT_SRV ( Method GET ) to return Product class assignment and characteristic valuation
Cause
Dump occuring for the API API_CLFN_PRODUCT_SRV 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.
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 , $expand , CPI , KBA , CA-CL-CL , Classification , CA-CL-CL-2CL , Classification (Public Cloud) , Problem