Skip to Content
0
Former Member
Aug 05, 2009 at 08:31 AM

Data Loading Issues with Generic Extractor

29 Views

Hello Guys,

I am loading the data from R3 to BW 3.5 using the Generic Extractor of type function module. Its taking very long to load the data.

Initially i hav been using the same and the data is loaded with in 30 mins its a full load. Now i am calling one FM in the Datasource as per the new requirement. now i have schedule the load on 3rd of Aug and the Data is still loading below is the job log. kindly let me know where exactly the problem is occuring.

Date Time Message

03.08.2009 14:23:26 Job started

03.08.2009 14:23:26 Step 001 started (program SBIE0001, variant &0000000020366, user ID RFC-USER)

03.08.2009 14:23:26 DATASOURCE = ZMM_GRN_AMT

03.08.2009 14:23:26 *************************************************************************

03.08.2009 14:23:26 * Current Values for Selected Profile Parameters *

03.08.2009 14:23:26 *************************************************************************

03.08.2009 14:23:26 * abap/heap_area_nondia......... 2000683008 *

03.08.2009 14:23:26 * abap/heap_area_total.......... 2000683008 *

03.08.2009 14:23:26 * abap/heaplimit................ 40894464 *

03.08.2009 14:23:26 * zcsa/installed_languages...... ED *

03.08.2009 14:23:26 * zcsa/system_language.......... E *

03.08.2009 14:23:26 * ztta/max_memreq_MB............ 250 *

03.08.2009 14:23:26 * ztta/roll_area................ 2000896 *

03.08.2009 14:23:26 * ztta/roll_extension........... 2000683008 *

03.08.2009 14:23:26 *************************************************************************

04.08.2009 01:14:16 Call up of customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 22.472 records

04.08.2009 01:14:16 Result of customer enhancement: 22.472 records

04.08.2009 01:14:16 Call up of customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 22.472 records

04.08.2009 01:14:16 Result of customer enhancement: 22.472 records

04.08.2009 01:14:17 Asynchronous dispatch of data package 000001 in task 0002 (1 parallel tasks)

04.08.2009 06:39:10 Call up of customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 22.472 records

04.08.2009 06:39:10 Result of customer enhancement: 22.472 records

04.08.2009 06:39:10 Call up of customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 22.472 records

04.08.2009 06:39:10 Result of customer enhancement: 22.472 records

04.08.2009 06:39:10 Asynchronous dispatch of data package 000002 in task 0003 (1 parallel tasks)

04.08.2009 06:39:11 tRFC: Data package = 000001, TID = AC18016C13404A773E1101C1, Duration = 00:00:28, ARFCSTATE =

04.08.2009 06:39:11 tRFC: Start = 04.08.2009 01:14:19, End = 04.08.2009 01:14:47

04.08.2009 19:36:46 Call up of customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 22.472 records

04.08.2009 19:36:46 Result of customer enhancement: 22.472 records

04.08.2009 19:36:46 Call up of customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 22.472 records

04.08.2009 19:36:46 Result of customer enhancement: 22.472 records

04.08.2009 19:36:46 Asynchronous dispatch of data package 000003 in task 0004 (1 parallel tasks)

04.08.2009 19:36:48 tRFC: Data package = 000002, TID = AC18016C13404A778A370331, Duration = 00:00:06, ARFCSTATE =

04.08.2009 19:36:48 tRFC: Start = 04.08.2009 06:39:13, End = 04.08.2009 06:39:19

05.08.2009 11:49:37 Call up of customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 22.472 records

05.08.2009 11:49:37 Result of customer enhancement: 22.472 records

05.08.2009 11:49:37 Call up of customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 22.472 records

05.08.2009 11:49:37 Result of customer enhancement: 22.472 records

05.08.2009 11:49:38 Asynchronous dispatch of data package 000004 in task 0005 (1 parallel tasks)

05.08.2009 11:49:39 tRFC: Data package = 000003, TID = AC18016C14D44A7840781E5E, Duration = 00:00:06, ARFCSTATE =

05.08.2009 11:49:39 tRFC: Start = 04.08.2009 19:36:50, End = 04.08.2009 19:36:56

Thanks in Advance

Regards

Edited by: KK on Aug 5, 2009 4:32 AM

Edited by: KK on Aug 5, 2009 4:33 AM

Edited by: KK on Aug 5, 2009 4:45 AM