Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
replied

Hi Yann,

Sorry but this 0CO_OM_WBS_6 seems a std extractor. on CO* tables. You may have not created indices on these tables to run all datasources faster.

This is the note on that. Note 382329 - Delta extractors CO: Poor performance

0CO_OM_WBS_6: Delta Load is taking very long time

Edited by: Parth Kulkarni on May 30, 2011 12:05 PM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question