Export To Excel fails for (40K Row and 60 column) table box in Ajax Client

[#1]

We have a table box which contains all the transaction lines. When we try to export the table data to Excel via ajax client, It fails.

I give error mentioning "Connection lost with Server" and QV session gets lost.

However, with same qvw file, same size of data, export to excel works in Qlikview developer as well as in PlugIn client.

I already set the export memory limit to 1GB in QV server and object calculation time out and print time out is set to 300 sec.

Session time out parameters are set to 1800 second.

Upon Investigation, My observations are as below.

Qlik view session log has message saying "Socket Closed by Client"

QlikView Event Log has message "Opening of document failed due to no Access"

We observed http traffic with fiddler and found that, when we click on the Export to Excel button, Ajax client sends request to server and after 1 minute we get the response Session Lost, restart.

After that we get the login page from QV server.

I observed that in HTTP header KeepAlive connection property is set and It takes more than 2 minute on the QlikView server to generate the Excel file and after that it starts sending the streams for the XL file. Before that only, I think Browser times out the connection and session gets lost.

Please provide solution that how to export 40K lines to Excel using Ajax client. Export to excel via Ajax client for 20k lines works fine

[peter_turner]

Hello,

Were you able to resolve this problem, as i have a similar problem when exporting large pdf reports.

When the report takes longer than 60 seconds, i get the 'lost connection to server, reconnecting' error box. This happens exactly after 60 seconds from my AJAX page.

Peter.

[#3]

Hi Peter

This was a bug in QlikView Webserver.They seemed to have fixed this bug in SR2 release. With SR2 release they have given an extra config property "QvsTimeOut" in config.xml present in C:\Documents and Settings\All Users\Application Data\QlikTech\QvWebServer.

Before SR2 Qliktech provided an patch to us (Build No 7261) to set this time out property.

Hope this solves your problem.

Thanks

Krishna

[peter_turner]

Thanks Krishna,

I upgraded to SR2 and changed the <QvsTimeout> variable and that fixed my problem also.

Thanks,
Peter.

[Anonymous]

I have the same problem to export.

To upgrade to SR2 you just execute a Desktop Qlikview Setup or was needed an adicional configuration on server?

My actual version is 11.0.2 SR1

thanks