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, , 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.