topic problem with time_out error in Application Development and Automation Discussions

problem with time_out error

Former Member — Wed, 08 Oct 2008 06:31:50 GMT

Hi guys,

I have this code below and I am getting a time_out error:

LOOP AT i_vbfa.

SELECT SINGLE buchk FROM vbuk INTO v_buchk

WHERE vbeln = i_vbfa-vbeln

AND buchk = 'A'.

IF sy-subrc <> 0.

DELETE i_vbfa INDEX sy-tabix.

ELSE.

SELECT SINGLE vbtyp FROM vbrk INTO v_vbtyp

WHERE vbeln = i_vbfa-vbeln.

IF v_vbtyp NE space.

DELETE i_vbfa INDEX sy-tabix.

ENDIF.

ENDLOOP.

I have a select single within the loop, will it cause trigger the error? why? Thanks

Re: problem with time_out error

KK07 — Wed, 08 Oct 2008 06:35:53 GMT

hi,

for each record u r selecting the records from table that's why it is time out error.

performance way it is not suggestable.instead u can select the values and u can use read statement.

Re: problem with time_out error

Former Member — Wed, 08 Oct 2008 06:36:50 GMT

Hi Mark,

Generally the Time Out occurs when the program is taking more time than system execution time.

the system execution time is maintained by basis people, commonly the time is between 10-20 minutes.

if your program is taking more than that time then the time out error is raised.

avoid using select single statement in a loop.

Regards

Re: problem with time_out error

Former Member — Wed, 08 Oct 2008 06:45:41 GMT

Thanks Mukesh!

Does the 10~20 mins is the total time execution of the program? Would you know how many micro seconds does each select single takes to retrieve the data from teh database?

Thanks!

Re: problem with time_out error

rainer_hbenthal — Wed, 08 Oct 2008 06:50:15 GMT

Single selects are good if they are single selects. But here you are reading a bunch of single rows. Read them all you need in an internal table, this is very much faster. Then instead of peeaking the database in the loop do a read on the internal table. If possible, use a hashed table and your performance gain will be big.

Re: problem with time_out error

Former Member — Wed, 08 Oct 2008 06:58:51 GMT

Create a internal table for i_vbuk with vbeln and buchk fields

and i_vbrk with vbeln and vbtyp fields.

write this before loop.

if i_vbfa[] is not initial.

select vbeln buchk into table i_vbuk for all entries in

i_vbfa where vbeln = i_vbfa-vbeln and buchk = 'A'.

select vbeln vbtyp into table i_vbrp for all entries in

i_vbrp where vbeln = i_vbfa-vbeln and vbtyp ne space.

endif.

sort i_vbuk.

sort i_vbrp.

LOOP AT i_vbfa.

read table i_vbuk with key vbeln = i_vbfa-vbeln binary search.

IF sy-subrc 0.

DELETE i_vbfa .

ELSE.

read table i_vbrk with key vbeln = i_vbfa-vbeln binary search.

IF sy-subrc 0.

DELETE i_vbfa .

ENDIF.

ENDLOOP.

Regards

Madhan

Edited by: Madhan Doraikannan on Oct 8, 2008 8:59 AM

Re: problem with time_out error

rainer_hbenthal — Wed, 08 Oct 2008 07:05:07 GMT


> read table i_vbuk with key vbeln = i_vbfa-vbeln binary search.
> Edited by: Madhan Doraikannan on Oct 8, 2008 8:59 AM

In that special case i would prefer a hashed table rather then a sorted table. Read will be much faster.

Re: problem with time_out error

Former Member — Wed, 08 Oct 2008 07:10:55 GMT

I donot have much idea, but u can do SQL Trace using T.code ST05.

in that you will get what time each select statement is taking and some other details also.

Regards

Mukesh.