Application hangs while downloading csv output of report

[ashishah]

Hi All,

We have cognos 8.4 implemented. Users run and save reports as csv. Usually the csv output is quite huge (csv file is around 120 MB in size). But they are not able to download the csv output. While downloading the browser throws error saying
------------------------------------
"Internet Explorer cannot download 2k5kh7lkhlkjhkjh7k6k54kjh.xls from <IP Address>

The connection with the server was reset."
-------------------------------------

And after this the application hangs and no users are able to access it for some time (for approx 2-3 minutes). Due to this other users also face different errors.

This has become a critical problem as due to this error the complete application goes for a toss. Though the application accessible automatically after 2-3 minutes.

I checked the cogserver.log file while the application is hung and found multiple entries of below text for that particular time period
------------------------------------
""80.0.4.139:9300   1628   2009-05-12 21:22:10.909   +5:30               JobQueueReceiver   MS   2062   4   Audit.RTUsage.ms.MS      com.cognos.monitor.queue.JobQueueReceiver:entering poll wait "
-------------------------------------
I also tried to access application using dispatcher but it did'nt help. Application throws below error while I try downloading csv file.
-------------------------------------
"PRS-PRH-0251 - The request to target "Content Manager" could not be submitted"
Details: "java.io.IOException : Failed to send HTTP request or read HTTP response"
-------------------------------------
Any help is really appreciated. Application unavailability is a big big problem.

Regards

Ashish

[twlarsen]

Hi Ashish,

I routinely download larger files using Cognos (between 300-700MB's) and don't experience any problems.  Where exactly in the download process does the error happen?  Does it begin to download?

Todd

[ashishah]

Hi Todd,

Yes, The download begins but stops mid way and IE browser throws error saying "Connection with the server was reset." and the application goes down for some time.

I have noticed that this is not consisting problem. Some time the file gets downloaded very fast (in download window it shows 8-9 MBPS speed) but some times it shows speed like 120 KBPS and the application hangs mometarily.

Do you also take csv output of size 300-700 MB?

Regards,

Ashish

[anandoc]

There could be various things causing this.

1) Try to switch the gateway from CGI to ISAPI. Much better performance under IIS.
2) What is your JAVA heap size set to?
3) When the application hangs and no one can use it, whats the Virtual Memory size of JAVA? Use Process Explorer to check the total virtual bytes and NOT just the private bytes which Task Manager shows you
4) Can you download the report as PDF or any other formats?