2. ASPRunnerPro General questions
  3. Error exporting to Excel
This topic is locked

Error exporting to Excel

 		8/19/2005 3:03:36 PM
ASPRunnerPro General questions
R
 razvan author

When exporting over roughly 15,000 records to Excel it gives the following error, iregardless chossing Open or Save:

"Internet Explorer cannot download ...l&type=excel&btnsubmit=Export from valid.website.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later."

The "Export to Excel" works fine for fewer records when exporting from the same table/data source.
Sergey Kornilov admin 8/22/2005

Hi,
could you send me an URL where I can see this error?
Otherwise please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.
R
 		razvan author 8/24/2005

Sergey,
unfortunately it is on my company's intranet (no access from outside/internet) and I can't either send you any zipped files (I work for a financial institution and is against policy).

The project I have created is based on an Oracle view and it gives the error I mentioned when trying to export more than 15,000 records - otherwise everything works as expected.

Thank you!
Sergey Kornilov admin 8/25/2005

Hi,
please open ..._export.asp file on your web server with a text editor, find the following code snippet:

Response.Write "</tr>"

rs.MoveNext

iNumberOfRows = iNumberOfRows + 1

loop
End Sub


and replace it with this one:

Response.Write "</tr>"

response.flush

More...

rs.MoveNext

iNumberOfRows = iNumberOfRows + 1

loop
End Sub


Please let me know if this helps.

If this modification fixes the problem we will include it in the next ASPRunnerPro update.
R
 		razvan author 8/25/2005

Thank you for the solution - it worked patially only - meaning that it doesn't give the error anymore, but the final Excel exported file has incomplete records (in my case the search finds 19,180 total records and the Excel file has only 6,859 records...)
Sergey Kornilov admin 8/25/2005

Just in case check IIS timeout settings and increase it if necessary.
R
 		razvan author 11/14/2005

Sergey,
it does time out after a while (variable number of records exported before timing out) - the error is:

Active Server Pages error 'ASP 0113'

Script timed out

/TEST_VIEW_export.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.


I have checked the ScriptTimeout value and it is 3600 (1 hour). My export times out after only a few minutes.

Anything else I can check or try?

The export tool is very important to my users, as they need raw data in Excel format for further analisys.
Thank you.
J
 		JCK 12/16/2005

Did you guys ever find the solution to this problem? I'm having the exact same export issue.
Sergey Kornilov admin 12/16/2005

Hi,
please try modify Server.ScriptTimeoutvariable inside ..._export.aspfile.

Locate this line and set the desired value:

Server.ScriptTimeout = 120
J
 		JCK 12/19/2005

Hi,

please try modify Server.ScriptTimeoutvariable inside ..._export.aspfile.

Locate this line and set the desired value:

Server.ScriptTimeout = 120


That worked. Thanks!