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