topic Re: time out exception in Application Development and Automation Discussions

time out exception

Former Member — Tue, 24 Apr 2007 14:14:38 GMT

Hi, I have to modify a report because it takes a lot of time to get some records in a select sentence, and finally i always get a time out dump. I think i should use function SAPGUI_PROGRESS_INDICATOR when the program arrives to that select but i don't know hopw to use it...

this is part of the code i have..

SELECT aufnr

werks

budat ltxa1 rueck rmzhl ismnw ismne aufnr

learr pernr

FROM afru

INTO TABLE it_afru FOR ALL ENTRIES IN it_csla

WHERE learr = it_csla-lstar AND

stokz <> gc_marca AND

budat IN s_budat AND

stzhl = gc_stzhl_cero AND

pernr IN s_pernr.

at this point, the program doesn't go on, so i tried the following but don't know if it's ok or not...

data: lw_lineas type i.

DESCRIBE TABLE it_csla LINES lw_lineas.

CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

EXPORTING

percentage = lw_lineas

text = 'Tratando datos AFRU'.

SELECT aufnr

werks

budat ltxa1 rueck rmzhl ismnw ismne aufnr

learr pernr

FROM afru

INTO TABLE it_afru FOR ALL ENTRIES IN it_csla

WHERE learr = it_csla-lstar AND

stokz <> gc_marca AND

budat IN s_budat AND

stzhl = gc_stzhl_cero AND

pernr IN s_pernr.

thanks in advance !!!

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:22:54 GMT

Hi Maria,

you can use FM TH_REDISPATCH in order to redispatch your context to a new process. But be careful, your program does no longer get a time-out.

Best regards,

Thomas

Re: time out exception

suresh_datti — Tue, 24 Apr 2007 14:22:59 GMT

Using SAPGUI_PROGRESS_INDICATOR would be of no help in this context.. in fact it might even make the program run longer.. the real issue could be with your complex where clause. pl ensure that the itab it_csla is not empty & may be you can drop one or two conditions from the where clause.. & then delete the unwanted entries from it_afru after the initial SELECT.

~Suresh

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:30:02 GMT

mmmm the problem is that before this select, there is a check it_csla[] is not initial... It's not my report, i'm just modifing it so i can't make too many changes...

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:32:41 GMT

hi Maria,

as per my understanding , the issue is to reduce the time taking for the select statement, if it is so , you may need to create secondary index for table afru to get the data quickly .becoz you are not using the primary keys in the select statement

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:33:34 GMT

Did you check, if there are suitable indices for the table?

Best regards,

Thomas

Re: time out exception

suresh_datti — Tue, 24 Apr 2007 14:34:00 GMT

try the following change..



SELECT aufnr
werks
budat ltxa1 rueck rmzhl ismnw ismne aufnr
learr pernr
FROM afru
INTO TABLE it_afru FOR ALL ENTRIES IN it_csla
WHERE learr = it_csla-lstar AND
budat IN s_budat AND
stzhl = gc_stzhl_cero.

delete it_afru  where stokz ne gc_marca.
delete it_afru where not pernr in s_pernr.

~Suresh

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:42:42 GMT

Ok, thanks, i'll try and let you know if it works...

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:48:22 GMT

Hi Maria,

Create secondary index for following fields

learr

stokz

budat

stzhl

pernr

And report output should be quicker .

Regards

Mr Kapadia

Re: time out exception

Former Member — Tue, 24 Apr 2007 14:54:57 GMT

yes.. thanks, i thinks it will be the best way to solve it... because the other solution doesnt' work very well... i have created very few index because i've always been told there are some problems using them.. which are those problems ????

thanksss !!!!