Skip to Content
0
Former Member
Jul 26, 2012 at 02:12 PM

BW Report taking long time to execute

1012 Views

Experts,

I need your help asap.

I am running a BW report and it is taking long time to execute, almost 40 minutes. Early it used to execute in 2-3 minutes but now it is taking 40 minutes.

I ran the query using RSRT tcode in "Debugg + Execute" mode and below are the logs i found. From the below logs i could see that till 8:51 it ran good but suddenly it has taken nearly 40 minutes to go to next step and again from 9:33 it executed normal.

Here I am not able to found why it has taken so much time. Can you please help me to find out what is the reason it has taken so much time.

Thanks for your support !

Session UID Step UID Step Type Step Counter User name Start Time Handle ID Handle Type Info Provider Object Name Detail Levl Event ID Event Text Duration Counter Event Counter 4QNAB9IRTOKJY132WL7APL6A6 4QNABMJBYBCSI81GSJ63QWZYM BEX3 3 JYTPY 7/26/2012 8:51 4 W3_I QUERYDESIGNER 2 19911 3.x Web Rep. Item 0.000191 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNABMJBYBCSI81GSJ63QWZYM BEX3 3 JYTPY 7/26/2012 8:51 5 W3_I ZISO_MP1 GR1GR2NAVBLOCK 2 19911 3.x Web Rep. Item 0.000739 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNABMJBYBCSI81GSJ63QWZYM BEX3 3 JYTPY 7/26/2012 8:51 1 W3_T 2 19919 Close Web 3.x 0.000081 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNDAELXTPQG0Q3UP6Y32IDQM BEX3 4 JYTPY 7/26/2012 9:33 DFLT 2 1 Wait Time, User 271.660705 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNDAELXTPQG0Q3UP6Y32IDQM BEX3 4 JYTPY 7/26/2012 9:33 DFLT 2 Not Assigned 0.000036 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNDAELXTPQG0Q3UP6Y32IDQM BEX3 4 JYTPY 7/26/2012 9:33 1 BRFC RRW3_WEBRFC 2 10000 RFC call 0.000145 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNDAELXTPQG0Q3UP6Y32IDQM BEX3 4 JYTPY 7/26/2012 9:33 1 W3_I MAIN 2 19911 3.x Web Rep. Item 0.000752 0 1 4QNAB9IRTOKJY132WL7APL6A6 4QNDAELXTPQG0Q3UP6Y32IDQM BEX3 4 JYTPY 7/26/2012 9:33 2 W3_I 2 19911 3.x Web Rep. Item 0.000158 0 1

Regards,

Sajid.