Skip to Content
0
Former Member
Sep 02, 2009 at 03:38 PM

data extraction is taking long time

337 Views

Hi,

I am extracting data into infocube from datamart. it's fullupload and almost extracting 24lack records. generally it should take less than time but taking more than 6 hours to upload. data selection and scheduling is happening correctely but acknowledgement from source infocube is taking more time(may be data mart)

BW statistics are not activated to this infocube.

here is job log to this data load.

01:32:26 'SAPGGB', TABNAME => '"/BI0/0P00000050"',

01:32:26 ESTIMATE_PERCENT => 10 , METHOD_OPT => 'FOR ALL

01:32:26 COLUMNS SIZE 75', DEGREE => 1 , GRANULARITY =>

01:32:26 'ALL', CASCADE => TRUE ); END;

01:32:27 SQL-END: 2009.09.02 01:32:27 00:00:01

06:35:44 Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 10,101 records

06:35:44 Result of customer enhancement: 10,101 records

06:35:44 Asynchronous send of data package 1 in task 0002 (1 parallel tasks)

06:35:44 tRFC: Data Package = 0, TID = , Duration = 00:00:00, ARFCSTATE =

06:35:44 tRFC: Start = 2009.09.02 01:30:14, End = 2009.09.02 01:30:14

06:35:45 Asynchronous transmission of info IDoc 3 in task 0003 (1 parallel tasks

06:35:46 Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 10,101 records

06:35:46 Result of customer enhancement: 10,101 records

06:35:46 tRFC: Data Package = 0, TID = , Duration = 00:00:01, ARFCSTATE =

06:35:46 tRFC: Start = 2009.09.02 06:35:45, End = 2009.09.02 06:35:46

06:35:46 Asynchronous send of data package 2 in task 0004 (1 parallel tasks)

06:36:55 tRFC: Data Package = 1, TID = 0A1401543C764A9E124057C6, Duration = 00:0

06:36:55 tRFC: Start = 2009.09.02 06:35:45, End = 2009.09.02 06:36:55

06:36:55 Asynchronous transmission of info IDoc 4 in task 0005 (1 parallel tasks

06:36:56 Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 10,101 records

06:36:56 Result of customer enhancement: 10,101 records

please advice me where can i check and possible reasons to take long time.

Thanks,

Kasi