2046293 - BW QPROV: Interesting facts about 'Query as InfoProvider'

A 'Query as InfoProvider' is being used and the following occurs: 

• More information is needed about how a QueryProvider works.
• A DTP based on QueryProvider returns unexpected data or runs into memory dumps.
• Further information is needed on analysis options for the QueryProvider.

For example, the following dump can happen:

Category               Resource bottleneck
Runtime Errors         TSV_TNEW_PAGE_ALLOC_FAILED

"TSV_TNEW_PAGE_ALLOC_FAILED"
"CL_RSDTIS_OBJECT==============CP" bzw. CL_RSDTIS_OBJECT==============CM00E                   
"IF_RSDTIS_OBJECT~WRITE_DATAPACKAGE"

Source code:
   23      l_s_key-reqtsn    = i_request_tsn.
   24      l_s_key-datapakid = i_datapakid.  
   25      LOOP AT <l_t_data> ASSIGNING FIELD-SYMBOL(<l_s_data>).
   26        ADD 1 TO l_s_key-record.         
   27        MOVE-CORRESPONDING <l_s_data> TO <l_s_dtis>.
   28        MOVE-CORRESPONDING l_s_key    TO <l_s_dtis>.
>>>>>        APPEND <l_s_dtis> TO <l_t_dtis>.  
   30      ENDLOOP.
   
Call stack:
6 METHOD       CL_RSDTIS_OBJECT==============CP    CL_RSDTIS_OBJECT==============CM00E    29  
  CL_RSDTIS_OBJECT=>IF_RSDTIS_OBJECT~WRITE_DATAPACKAGE                                        
5 METHOD       CL_RSDTIS_FILL_CMD============CP    CL_RSDTIS_FILL_CMD============CM001   214  
  CL_RSDTIS_FILL_CMD=>IF_RSBK_CMD_P~CHANGE_ALL                                                
4 METHOD       CL_RSBK_PROCESS===============CP    CL_RSBK_PROCESS===============CM00Q   376  
  CL_RSBK_PROCESS=>PROCESS_REQUEST                                                            
3 METHOD       CL_RSBK_PROCESS===============CP    CL_RSBK_PROCESS===============CM002    26  
  CL_RSBK_PROCESS=>IF_RSBATCH_EXECUTE~EXECUTE                                                 
2 FUNCTION     SAPLRSBATCH                         LRSBATCHU13                           512  
  RSBATCH_EXECUTE_PROCESS                                                                     
1 EVENT        RSBATCH_EXECUTE_PROZESS             RSBATCH_EXECUTE_PROZESS               504  
  START-OF-SELECTION

• SAP NetWeaver
• SAP BW/4HANA

QPROV, Query as InfoProvider, QueryProvider, semantic group, memory, performance, incorrect data, the dataset stored under an EXPORT/IMPORT ID is restricted , Internal Kernel Error, EXPORT_TOO_MUCH_DATA APPEND_DATA_REFERENCE, TSV_BTR_PAGE_ALLOC_FAILED, , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DST , Data Staging , BW4-AE-DBIF , DB Interface Data Manager , How To