SAP Knowledge Base Article - Preview

2601445 - Requesting large amount of data through the Gateway is slow and might end up with dumps: STRING_SIZE_TOO_LARGE, TSV_TNEW_PAGE_ALLOC_FAILED

Symptom

An OData request fails OR gets its response really slow. (Fiori/UI5, BW, mobile or other kind of apps from DB/ through RFC/ through HTTP or from CDS Views.)

I. If fails one of the below errors is present in the body:

Runtime Error: 'STRING_SIZE_TOO_LARGE'. The OData request processing has been abnormally terminated. If "Runtime Error" is not initial, launch transaction ST22 for details and analysis. Otherwise, launch transaction SM21 for system log analysis.

OR

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 incident. Otherwise, if "Runtime Error" is not initial, launch ADT feed "Runtime Errors" or transaction ST22 / SM21 (system log analysis) for details and analysis.

AND

STRING_SIZE_TOO_LARGE dump generated in transaction ST22:

Category: ABAP programming error
Runtime Errors: STRING_SIZE_TOO_LARGE
ABAP Program: /IWCOR/CL_DS_EP_WRITER_XML====CP
Application Component: OPU-FND-CCL

OR

TSV_TNEW_PAGE_ALLOC_FAILED dump generated in transaction ST22:

Category Resource bottleneck
Runtime Errors TSV_TNEW_PAGE_ALLOC_FAILED

AND

No error is written in the Gateway Error Log (transaction /n/IWFND/ERROR_LOG)

(Note: The same OData request might succeed for JSON format, when "?$format=json" is used instead of "?$format=xml".)

II. If the response is returned with bad performance the below warning is present in the Gateway Client (/N/IWFND/GW_CLIENT) body:

<TOO_LARGE_PAYLOAD>Response body is too large (xxxx B). Click "Response in Browser"

with Status Code and Message: 200 OK

III. SYSTEM_NO_ROLL dump might be raised too

Category Resource bottleneck
Runtime Errors SYSTEM_NO_ROLL


Read more...

Environment

SAP Gateway (SAP_GWFND)

Product

SAP Gateway all versions

Keywords

CONCATENATE ls_feed-entries lv_entry INTO ls_feed-entries., /IWCOR/CL_DS_EP_WRITER_XML, REST client, Fiori application, SAPUI5, large amount, huge, data, bad performance, too large, slow, gw, too big, huge, enormous, TSV_TNEW_PAGE_ALLOC_FAILED, SYSTEM_NO_ROLL, Maximum string length (2,145,386,496 bytes) exceeded, CX_SY_STRING_SIZE_TOO_LARGE , KBA , OPU-FND-CCL , Consumer Connectivity Layer , BC-MID-ICF , Internet Communication Framework , OPU-GW-COR , Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.