3137263 - ODP extractors from SLT are slow - SAP ASE for Business Suite

• ODP extractor is slow on SLT systems running on SAP ASE database.
  
  
• The slow extraction results in subsequent DTP and dataload timeouts/failures/YELLOW light on the target BW on HANA system.
• Below TIME_OUT dumps are received on the SLT system, while reading the data from ODQMON via view ODQMON_V using standard program : CL_ODQ_CORE_DELTA_EXTRACTOR 

Category               ABAP programming error
Runtime Errors         TIME_OUT
ABAP Program           CL_ODQ_CORE_DELTA_EXTRACTOR===CP
Application Component  BC-BW-ODP

Call program...........CL_RSDS_ACCESS_ODP============CP
Function module..... RODPS_REPL_ODP_FETCH_XML

• The sql query on the database is identified to be:

SELECT "CLIENT" ,"TSN" ,"UNITNO" ,"MODELNAME" ,"QUEUENAME" ,"LINES" ,"RAWSIZE" FROM "ODQDATA_V" WHERE "CLIENT" = ? AND "MODELNAME" = ? AND "QUEUENAME" = ? AND "TSN" > ? AND "TSN" <= ? ORDER BY "ODQDATA_V" ."CLIENT" ,"ODQDATA_V" ."TSN" ,"ODQDATA_V" ."UNITNO" ,"ODQDATA_V" ."MODELNAME" ,"ODQDATA_V" ."QUEUENAME" /* R3:CL_ODQ_CORE_DELTA_EXTRACTOR===CP:275 T:ODQDATA_V M:001 */

• Per sp_w output collected in isql, the process executing this query is an OPEN CURSOR

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver Business Warehouse
• SAP BW on HANA
• SAP Landscape Transformation Replication Server (SLT)

SLT, TIME_OUT, CL_ODQ_CORE_DELTA_EXTRACTOR, ODP, slow, DTP, ODQDATA, ODQMON, ODQMON_V, BW4HANA, "OPEN CURSOR", cursor , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , Problem