Skip to Content
0
Former Member
Jul 25, 2016 at 08:15 PM

BW extract job hanging and never completing

258 Views

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.