topic Re: error Time-Out. in Application Development and Automation Discussions

error Time-Out.

Former Member — Wed, 05 Sep 2007 06:36:05 GMT

Hi all .

am trying to fetch 2 years data in my program, when i execute the program after a long time its gives Time out error, how to overcome this . please tell me

Regards

Prajwal

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 06:39:34 GMT

you need to execute such reports in background so that they dont result in TIME-OUT error...

as huge amount of data fetching takes lot of time...

and if this time exceeds auto time out duration then report results in error....

you either execute report in BG or increase auto time out duration...

Message was edited by:

sharayu kumatkar

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 06:40:01 GMT

Goto SE38, type the program name & enter the selection screen data.

Click PROGRAM=> EXECUTE IN BACKGROUND

Goto SM37 & check the spool output for results.

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 06:40:17 GMT

Hi,

Either you execute the program in background or use FM SAPGUI_PROGRESS_INDICATOR to keep the connection between Pres server / Appl server active.

Hope this helps,

Best Regards, Murugesh AS

Re: error Time-Out.

former_member188827 — Wed, 05 Sep 2007 06:40:41 GMT

there are alot of records which fulfill ur requirement and hence rquire alot of db accesses whcih is very time consuming, dats y dis message is appearing...

try to give shorter durationi..e instead of two years first fetch data of first six months, den of next six months and so on....fetch data over smaller intervals..

plz reward points if dis helps..

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 06:46:25 GMT

hi all .

i want full 2 year data in a single file . am using gui_download FM to download the

data.

program is working fine if am fetching 6 month data.

please give me steps to execute the progtam in background

Regards

prajwal.k

Message was edited by:

prajwal k

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 06:55:13 GMT

Your program wont work in BACKGROUND bcz it has FM GUI_DOWNLOAD.

GUI_DOWNLOAD doesnt work in background.

There are 2 options:-

1. To modify the program to download data on application server using OPEN DATASET

2. To run the program in foreground in steps for shorter periods & then collate all the files into a single file.

if you execute in Background , then it will dump with GUI_DOWNLOAD.

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 07:04:55 GMT

Thanks Prashant .

I dont no about OPEN DATASET, please give me steps or code to use.

Regards

Prajwal.k

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 07:09:55 GMT

Re: error Time-Out.

Former Member — Wed, 05 Sep 2007 07:12:13 GMT

Thanks a lot Prashant.

Regards

Prajwal.k