topic Re: error : TIME_OUT in Application Development and Automation Discussions

error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:15:51 GMT

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?

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:22:26 GMT

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

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:23:48 GMT

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) ...

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:25:19 GMT

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

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:25:34 GMT

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

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:26:11 GMT

Hi,

nothing like gun shot solution for your problem,

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

seshu.

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:28:40 GMT

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

Re: error : TIME_OUT

Former Member — Thu, 28 Feb 2008 09:29:22 GMT

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).