error Time-Out.

[Former Member]

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

[Former Member]

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

[Former Member]

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

Click PROGRAM=> EXECUTE IN BACKGROUND

Goto SM37 & check the spool output for results.

[Former Member]

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

[former_member188827]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Thanks Prashant .

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

Regards

Prajwal.k

[Former Member]

Thanks a lot Prashant.

Regards

Prajwal.k