topic Re: Error: Time limit exceeded... in Application Development and Automation Discussions

Error: Time limit exceeded...

aris_hidalgo — Tue, 10 Apr 2007 06:33:06 GMT

Hello Experts,

I am currently modifying a report where it exceeds the time alloted for programs to run

in our production server which is 10 minutes. I debbuged the report and found out that it fetches

around 550k to 700k of records from tables VBAK and VBAP. After selecting, the internal table

will now be looped and this where the report stops since it cannot process the huge volume of records

which is 550k++. I need help on how to fix this since I can't think of anyway to limit the records being

fetched. Below is the select statement:

SELECT a_{vbeln b}posnr a~auart

a_{vkorg a}vtweg a~kunnr

b_{matnr b}pstyv b~spart

FROM vbak AS a

INNER JOIN vbap AS b

ON a_{vbeln = b}vbeln

APPENDING TABLE lt_vbap

WHERE a~auart IN lr_auart

AND a~vbeln IN s_vbeln

AND a~vbeln IN s_vbill

AND a~vbtyp EQ p_vbtyp.

LOOP AT lt_vbap ASSIGNING <wa_vbap>.

....

ENDLOOP.

Hope you can help me out here guys. Thank you and take care!

Re: Error: Time limit exceeded...

Former Member — Tue, 10 Apr 2007 06:38:33 GMT

If there are no other ways to improvise the execution time and we are bound for certain time, we have to execute the program in background rather than executing in foreground.

Kind Regards

Eswar

Re: Error: Time limit exceeded...

Former Member — Tue, 10 Apr 2007 06:42:31 GMT

DATA:

t_mara type table of mara with header line,

t_mara1 type table of mara with header line.

select *

from mara

into table t_mara

package size 5000.

append lines of t_mara to t_mara1.

endselect.

Try this PACKAGE SIZE option.

Reward if helpful....

Re: Error: Time limit exceeded...

Former Member — Tue, 10 Apr 2007 06:42:47 GMT

Vitraylab,

SELECT a_{vbeln b}posnr a~auart

a_{vkorg a}vtweg a~kunnr

b_{matnr b}pstyv b~spart

FROM vbak AS a

INNER JOIN vbap AS b

ON a_{vbeln = b}vbeln

INTO TABLE lt_vbap

PACKAZE SIZE 30000

WHERE a~auart IN lr_auart

AND a~vbeln IN s_vbeln

AND a~vbeln IN s_vbill

AND a~vbtyp EQ p_vbtyp.

Write the functionality here, which you have written in between loop end loop.

ENDSELECT.

change the packaze size according to your program run time 10 minutes.

Don't forget to reward if useful.

Re: Error: Time limit exceeded...

Former Member — Tue, 10 Apr 2007 06:59:03 GMT

Hai Viraylab,

Each time the program is exiguted it takes much time to fetch required data(may be more than 10 min)

Here is the solution which takes much smaller time.

Create a Database view from the two tables vbak and vbap with join condtion on vbeln.

Now write a select query from that view

(You can fetch data from view as is from db table)

It definitily reduces time.

I hope you got it.But do some analyzation on view.

Reward points if it helps you.

Regrs,

Rama chary.Pammi

Re: Error: Time limit exceeded...

aris_hidalgo — Tue, 10 Apr 2007 07:19:47 GMT

Hello Experts,

Thank you for your helpful replies. However, Can you please elnlighten me on what does the PACKAGE statement do and how can I use database view to my advantage? my main problem is not on the select statement but on the loop statement afterwards where the time limit error occurs since the internal table contains around 550K of records. Examples will be appreciated.

Again, thank you guys and take care!

Re: Error: Time limit exceeded...

Former Member — Tue, 10 Apr 2007 07:22:30 GMT

Hi,

In thew query there is not date specified so its trying to list down all the documents available in the database.

Not sure about the requirement at your end but i feel report should always be bounded by time criteria.

Hope that helps.

Regards

Kapadia

***Assigning points is the way to say thanks in SDN.***