Skip to Content
0
Former Member
May 30, 2011 at 09:57 AM

How to reduce long extraction time - Generic extractor based on view

337 Views

Hello. The previous thread about this error was closed without any answer.

I'm in the same configuration.

"Using a generic extractor (Delta enabled on confirmation date) based on view to load data from ECC6 to BI.

Now my issue is that the delta extraction is running for a long time (around 1 hr) even if the data volume is very small

While checking the job overview in source system i saw that the job is hanging at the below step for almost 1 hr."

1 LUWs confirmed and 1 LUWs to be deleted with function module MF RSC2_QOUT_CONFIRM_DATA.

I am not understanding why this is happening.

Here is the log of the job:

30.05.2011 03:58:11 Job started

30.05.2011 03:58:11 Step 001 started (program SBIE0001, variant &0000000166864, user ID ALEREMOTE)

30.05.2011 03:58:11 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks)

30.05.2011 03:58:11 DATASOURCE = 0CO_OM_WBS_6

30.05.2011 03:58:11 *************************************************************************

30.05.2011 03:58:11 * Current Values for Selected Profile Parameters *

30.05.2011 03:58:11 *************************************************************************

30.05.2011 03:58:11 * abap/heap_area_nondia......... 4000000000 *

30.05.2011 03:58:11 * abap/heap_area_total.......... 8000000000 *

30.05.2011 03:58:11 * abap/heaplimit................ 100000000 *

30.05.2011 03:58:11 * zcsa/installed_languages...... DEFS *

30.05.2011 03:58:11 * zcsa/system_language.......... E *

30.05.2011 03:58:11 * ztta/max_memreq_MB............ 2047 *

30.05.2011 03:58:11 * ztta/roll_area................ 6500000 *

30.05.2011 03:58:11 * ztta/roll_extension........... 2000000000 *

30.05.2011 03:58:11 *************************************************************************

30.05.2011 03:58:11 1 LUWs confirmed and 1 LUWs to be deleted with function module RSC2_QOUT_CONFIRM_DATA

30.05.2011 05:02:53 Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 171 records

30.05.2011 05:02:53 Result of customer enhancement: 171 records

30.05.2011 05:02:53 Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 171 records

30.05.2011 05:02:53 Result of customer enhancement: 171 records

30.05.2011 05:02:53 Asynchronous send of data package 1 in task 0002 (1 parallel tasks)

30.05.2011 05:02:53 IDOC: Info IDoc 2, IDoc No. 4667050, Duration 00:00:00

30.05.2011 05:02:53 IDoc: Start = 30.05.2011 03:58:11, End = 30.05.2011 03:58:11

30.05.2011 05:02:53 tRFC: Data Package = 1, TID = AC11082D38B44DE308DD028A, Duration = 00:00:00, ARFCSTATE = RECORDED

30.05.2011 05:02:53 tRFC: Start = 30.05.2011 05:02:53, End = 30.05.2011 05:02:53

30.05.2011 05:02:53 Altogether, 0 records were filtered out through selection conditions

30.05.2011 05:02:53 Asynchronous transmission of info IDoc 3 in task 0003 (0 parallel tasks)

30.05.2011 05:02:53 IDOC: Info IDoc 3, IDoc No. 4667051, Duration 00:00:00

30.05.2011 05:02:53 IDoc: Start = 30.05.2011 05:02:53, End = 30.05.2011 05:02:53

30.05.2011 05:02:53 Synchronized transmission of info IDoc 4 (0 parallel tasks)

30.05.2011 05:02:53 IDOC: Info IDoc 4, IDoc No. 4667052, Duration 00:00:00

30.05.2011 05:02:53 IDoc: Start = 30.05.2011 05:02:53, End = 30.05.2011 05:02:53

30.05.2011 05:02:53 Job finished

Thanks for your help.

Yann