3530770 - ODP: STRING_SIZE_TOO_LARGE dump while extracting CDS data through a Query

• Reading CDS view data from SAP Netweaver or BW/4HANA system through a query results in a STRING_SIZE_TOO_LARGE dump in the source system.
• Sometimes the dump is SYSTEM_NO_ROLL.
• The exception error occurs in the method WRAP_DATA in class CL_ODQ_UTILITIES:
  |>>>>>|      CALL TRANSFORMATION id SOURCE t_data = it_data RESULT XML lr_xml.                 
• This issue may affect multiple queries built on top of Open ODS view, which are created based on CDS view from the S/4 system.

Here're the main details of the 2 different dump:

##DUMP1##

Category               ABAP programming error
Runtime Errors         STRING_SIZE_TOO_LARGE
Except.                CX_SY_STRING_SIZE_TOO_LARGE
ABAP Program           CL_ODQ_UTILITIES==============CP
Application Component  BC-BW-ODP

|    "STRING_SIZE_TOO_LARGE" CX_SY_STRING_SIZE_TOO_LARGE
|    "CL_ODQ_UTILITIES==============CP" bzw. CL_ODQ_UTILITIES==============CM008
|    "WRAP_DATA"

|    Transaction......... RSRT
|    Call program...........CL_RSDS_ACCESS_ODP============CP 
|    Function module..... RODPS_REPL_ODP_FETCH_XML  

|    An attempt was made create a string of length 2145387179 (bytes). This exceeds the maximum length for a string (2145386496)

|IT_DATA  
|    Table IT_6538[2176204x1558]   <--- big internal table

##DUMP2##

Category               Resource bottleneck
Runtime Errors         SYSTEM_NO_ROLL

|    "SYSTEM_NO_ROLL"
|    "CL_ODQ_UTILITIES==============CP" bzw. CL_ODQ_UTILITIES==============CM008
|    "WRAP_DATA"

|    Transaction......... RSRT 
|    Call program...........CL_RSDS_ACCESS_ODP============CP
|    Function module..... RODPS_REPL_ODP_READ_DIRECT_XML 

|Short Text                                                                                        |
|    The memory request for 1459875032 bytes could not be complied with.

|IT_DATA 
|    Table IT_1795[31019165x178]   <--- big internal table

• BW Netweaver or SAP BW/4HANA as the target system
• S/4 as the source system
• ODP as the connector

ABAP CDS view, SAP BW/4HANA, Query, Open ODS view, , KBA , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DBA-ODSV , Open ODS View , Problem