Symptom
- A Custom CDS View had been created or an existing SAP CDS View is used and data can be previewed without issue
- An ODATA request is made against the CDS View and fails for any of the following reasons:
- The request returns an error "DBSQL_SQL_INTERNAL_DB_ERROR". After further investigation, a Short Dump was found and the underlying error was a SQL Code 2048 due with SQL Message:
SQL message: column store error: search table error: [9] Memory allocation failed; exception 1000002: Allocation failed
- A 500 error is received because the request timed out
- The request returns an error similar to:
Runtime Error: 'SYSTEM_NO_ROLL'. The OData request processing has been abnormally terminated. If you use SAP S/4HANA Cloud, please create an case.
Otherwise, if "Runtime Error" is not initial, launch ADT feed "Runtime Errors" or transaction ST22 / SM21 (system log analysis) for details and analysis. - The request returns an error similar to:
Runtime Error: 'TSV_TNEW_PAGE_ALLOC_FAILED'. The OData request processing has been abnormally terminated. If you use SAP S/4HANA Cloud, please create an case.
Otherwise, if "Runtime Error" is not initial, launch ADT feed "Runtime Errors" or transaction ST22 / SM21 (system log analysis) for details and analysis.
Read more...
Environment
SAP S/4HANA Cloud Public Edition
Product
SAP S/4HANA all versions
Keywords
ODATA, request, fails, DBSQL_SQL_INTERNAL_DB_ERROR, 500, Timeout, CDS, View, SYSTEM_NO_ROLL, Runtime Error, timeout error, custom cds view, cds view, external API, memory allocation , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview