Download time out in BDC

[Former Member]

Hi All,

I'm using the FM 'GUI_DOWNLOAD' to download entries from a table.It works well , however if the records are more than 200000 ( 2 lacs), it throws an error which says time out & program terminates. Please assit me in overcoming this time out error & to down load records more than 200000.

[Former Member]

It might be timout problem. Check with Basis team and increase the resources and other settings for this particular program.

Last resort: cut the file and run the bdc for each.

regards,

Sandeep Josyula

*Reward helpful answers

[former_member181962]

HI Amber,

Contact your BASIS team to increase the maximum Permissible Online run time for foreground programs.

Regards,

Ravi

[Former Member]

Thanks for the quick response. Isn't there, any other go to manipulate this . For instance ,can i create four different files of 50,000 each , if i have 20000 records to download. if yes, please suggest me some code to handle this.

[Former Member]

use the keywords "UP to 50000 rows"

Put them in main table for BDC.

clear the table and again read the next set.

you can very well manually divide the file also.

regards,

Sandeep Josyula

[Former Member]

Amber,

It may also depend on how u are copying the records into ur internal table...do u have a str for ur internal table or are u copying using a compnent of large length

santhosh

[Former Member]

Hi ,

Try usingnthis FM " SXDA_COPY_FLAT_FILE " . this won't give you the problem of timeout during download . IF required I can also give you sample code . This is the FM being used by transaction SXDB to upload and download files from presentation erver to application or viceversa .

Regards ,

Varun .