ALV table: export to excel with timeout

[gerd_hotz]

Hello experts,

when I export an ALV-table to an excel file, I often get time out,

and only while doing an export to excel.

The standard filling of the alv runs without timeout.

Is the time out problem a bug ?

Is there a solution for stopping this ?

I've seen that its possible to set parameter in tx smicm,

but there I only can open complete http for a longer period.

What do you think ?

Thanks Gerd

[gerd_hotz]

New query has much better performance !

[thomas_jung]

I don't believe what you describe is normal. How many rows do you have in your context bound to the ALV? In general the export to Excel happens very fast, but I suppose if you had a very large number of rows you might be causing the program to swap (exhaust its memory) during the XSLT to the Excel format.

[gerd_hotz]

Hello,

I've bound about 17.500 rows in my context.

The programm is searching this rows fast, but when I want to export it to

excel then I get this timeout.

I think that the data is already in cache while exporting it to excel, so I don't

understand the timeout.

What do you think ?

BR

Gerd

[thomas_jung]

That is quite a few rows. Data being in memory doesn't help during Excel Export. The data has to pass through an XSLT and transformed into the Excel XHTML or XML format (depending upon system settings). This operation is memory intensive and the time is highly dependent upon the number of rows it is working across. Exactly how low is your timeout set? If you feel the system is at fault you could always enter a support ticket or search the service marketplace notes for relate items.