We are experiencing an issue where a generic BW extractor hangs and never completes. Occasionally, it will complete and when it does it finishes less than 10 minutes. It is pulling directly from a table join of a local developed Z-table and LTAP. There is a filter on LTAP-QDATU and we tried adding an index to LTAP with no effect. The job ran successfully in both the test and QA environments with no incidents. When it fails it never reaches the following step:
Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 2.283 records
It hangs after displaying:
Job started
09:41:13 Step 001 started (program SBIE0001, variant &0000000288606, user ID SAPCPIC)
09:41:13 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)
09:41:13 DATASOURCE = ZRFPKDLSAVE
09:41:13 RLOGSYS = BIP010
09:41:13 REQUNR = REQU_DMV1ZSP83W43BUPPYYLPMCDQM
09:41:13 UPDMODE = F
09:41:13 LANGUAGES = *
09:41:13 *************************************************************************
09:41:13 * Current Values for Selected Profile Parameters *
09:41:13 *************************************************************************
09:41:13 * abap/heap_area_nondia......... 4000000000 *
09:41:13 * abap/heap_area_total.......... 12000000000 *
09:41:13 * abap/heaplimit................ 40000000 *
09:41:13 * zcsa/installed_languages...... DEBS *
09:41:13 * zcsa/system_language.......... E *
09:41:13 * ztta/max_memreq_MB............ 2047 *
09:41:13 * ztta/roll_area................ 16773120 *
09:41:13 * ztta/roll_extension........... 2000000000 *
09:41:13 *************************************************************************
Any thoughts or recommendations would be appreciated.