error : TIME_OUT

[Former Member]

hi,

thanks in advance,

i am using simple abap program to fetch the data from different tables with ineer joins.

i am storing that data into internal table.

but when i am executing the program i am getting error

Runtime Errors : TIME_OUT.

Short Text

Time Limit Exceeded

any solution on such problem?

[Former Member]

Hi Raghvendra,

your program is taking too much time to execute. The amount of execution time is crossing the time defined in the profile parameter maintained for determining amount of time allowed for a foreground work process before dumping.

Only suggestion is to improve the performance of your program.

Go to transaction RZ11 and check parameter: abap/timeout

It defines the time of execution before application dumps with TIME_OUT error.

Cheers.

Edited by: Aditya Laud on Feb 28, 2008 4:24 AM

[Former Member]

This occurs because of the inner join.

Try to use for all entries if possible.(If UR writing inner join on more

than 2 tables) ...

[Former Member]

Hi,

TIME_OUT errors will occurs, as maximum permitted time for execution of report might be reached. basically the time in secondds like 900,1800,2700 seconds will be given the programs and will be set by Basis team.

Try to execute the program in Background.After giving all selection screen values, Goto Program-->Execute in background option.

Give necessary print parameters and format for output and schedule with Immediate option. Now goto SM37 and check your batch job for the spool.

Even after program has not finished means, you may to do performance tuning for your SELECT statements..

REgards,

Ashok

[Former Member]

Hi,

You can also run the report in the background on the selection screen window go to program you will get option to run it in back ground and then you can check the out put in transaction sm37.

Regards,

Himanshu

[Former Member]

Hi,

nothing like gun shot solution for your problem,

u just change your select statements and loops to improve your report performance.

seshu.

[Former Member]

hi,

use fuction module after each select statement. and where ever u feel its taking huge time .

CALL FUNCTION 'ARCH_ANA_PROGRESS_INDICATOR'

EXPORTING

• PERCENTAGE = 0

TEXT = 'Started Fetching Details '.

regards

siva

[Former Member]

The tables your are using may have huge data and you are selecting the records based on non-primary keys.

if u want to filter the records on non-primary keys of a table create a secondary index (if necessary).