473,699 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Active Server Pages error 'ASP 0113'

"Active Server Pages error 'ASP 0113'
Script timed out"

I am still getting this error, and I am not sure how I could fix this.

When I execute the query at SQL 2005, it only takes 8 seconds.
The stored procedure for this report has been already went through Database
Engine Tuning Advisor to put all the necessary indexes on the associated
tables.

It happens when I run this report on other new web server.

I already put this on the ASP web page for this report.

<% server.ScriptTi meout = 4000 %>

..ConnectionTim eout = 4800
..CommandTimeou t = 4800

Any idea?
Thanks.

Sep 11 '08 #1
20 5616
"Justin Doh" wrote:
"Active Server Pages error 'ASP 0113'
Script timed out"

...<% server.ScriptTi meout = 4000 %>...

.ConnectionTime out = 4800
.CommandTimeout = 4800

Any idea?
Maybe it's not database-related. Are you in an endless loop, perhaps missing
a MoveNext() or something?

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

Sep 11 '08 #2
Justin Doh wrote:
"Active Server Pages error 'ASP 0113'
Script timed out"

I am still getting this error, and I am not sure how I could fix this.

When I execute the query at SQL 2005, it only takes 8 seconds.
The stored procedure for this report has been already went through
Database Engine Tuning Advisor to put all the necessary indexes on
the associated tables.

It happens when I run this report on other new web server.

I already put this on the ASP web page for this report.

<% server.ScriptTi meout = 4000 %>

.ConnectionTime out = 4800
.CommandTimeout = 4800

Any idea?
Thanks.
Before setting ridiculous timeouts, verify that you need them.
1. use SQL Profiler to run a trace to verify that the stored procedure
is the problem
2. identify the bottleneck in your code if the stored procedure is not
the problem

<%
Response.Write "Code start: " & now & "<BR>"
....
Response.Write "Opening connection: " & now & "<BR>"
....
Response.Write "Calling procedure: " & now & "<BR>"

....
Response.Write "Processing results: " & now & "<BR>"
....
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Sep 11 '08 #3


"Bob Barrows [MVP]" wrote:
Before setting ridiculous timeouts, verify that you need them.
1. use SQL Profiler to run a trace to verify that the stored procedure
is the problem
2. identify the bottleneck in your code if the stored procedure is not
the problem

<%
Response.Write "Code start: " & now & "<BR>"
....
Response.Write "Opening connection: " & now & "<BR>"
....
Response.Write "Calling procedure: " & now & "<BR>"

....
Response.Write "Processing results: " & now & "<BR>"
....
But if the problem is an infinite loop of some kind, then you might want to
follow up each of the Response.Write calls with
Response.Flush
to be sure the output gets to the browser. Also, be sure to *NOT* output
your debug into the <TRrows of a <TABLE>. Even with Response.Flush, the
browser will set there forever waiting for the terminating </TABLEbefore
displaying anything.
Sep 11 '08 #4
Old Pedant wrote:
"Bob Barrows [MVP]" wrote:
>Before setting ridiculous timeouts, verify that you need them.
1. use SQL Profiler to run a trace to verify that the stored
procedure is the problem
2. identify the bottleneck in your code if the stored procedure is
not the problem

<%
Response.Wri te "Code start: " & now & "<BR>"
....
Response.Wri te "Opening connection: " & now & "<BR>"
....
Response.Wri te "Calling procedure: " & now & "<BR>"

....
Response.Wri te "Processing results: " & now & "<BR>"
....

But if the problem is an infinite loop of some kind, then you might
want to follow up each of the Response.Write calls with
Response.Flush
to be sure the output gets to the browser.
I did mean to put that in - sorry
Also, be sure to *NOT*
output your debug into the <TRrows of a <TABLE>. Even with
Response.Flush, the browser will set there forever waiting for the
terminating </TABLEbefore displaying anything.
I didn't think that needed to be said, but thanks for saying it.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Sep 11 '08 #5
"Active Server Pages error 'ASP 0113'
Script timed out"

I am still getting this error, and I am not sure how I could fix this.
Try with a very simple query first to verify connectivity, etc.

Jeff
Sep 11 '08 #6
"Old Pedant" wrote:
...Also, be sure to *NOT* output your debug into the <TRrows of a
<TABLE>. Even with Response.Flush, the browser will set there forever
waiting for the terminating </TABLEbefore displaying anything.
It has been years since I saw a browser other than Internet Explorer that
exhibits this behavior. Certainly both Firefox and Opera will display table
rows before </tableis reached.

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

Sep 11 '08 #7
Thank you very much for the feedback.

My output is:
I have the error message on the top of web page

Active Server Pages error 'ASP 0113'
Script timed out

And then, there is output (report with data)..

It retrieved the data fine, but why do I have the error message on the top?

Thanks.

"Jeff Dillon" wrote:
"Active Server Pages error 'ASP 0113'
Script timed out"

I am still getting this error, and I am not sure how I could fix this.

Try with a very simple query first to verify connectivity, etc.

Jeff
Sep 11 '08 #8

"Justin Doh" wrote:
My output is:
I have the error message on the top of web page

Active Server Pages error 'ASP 0113'
Script timed out
And then, there is output (report with data)..

It retrieved the data fine, but why do I have the error message on the top?
Well, this is a pure guess. But one way it *could* happen would be for you
to have an infinite loop AFTER all of the reporting is done but before the
final </TABLEtag was written.

And if your reporting is done into a <TABLEthen the error message, since
it wouldn't be output with <TR><TD>...</TD></TRsurrounding it, then indeed
the browser might show the error message *before* the incomplete <TABLE>.

As Dave Anderson might comment, this would likely only happen with MSIE (and
possibly only with pre-MSIE 7 versions), but I have seen it happen with MSIE
6, for sure. (Well, not timeout...but other errors.)

You can find out the truth of my guess by inspecting the HTML. Do a
VIEW==>>SOURCE in the browser and look at the HTML (in Notepad, if using
MSIE, by default). See if the error message really is at the bottom of the
HTML text and is simply displaying at the top becuz of MSIE peculiarities.
Sep 11 '08 #9
You know what.
When I looked at the SOURCE of HTML (notepad), I see the error message on
the bottom.
How do I fix this?
Thanks.

"Old Pedant" wrote:
>
"Justin Doh" wrote:
My output is:
I have the error message on the top of web page

Active Server Pages error 'ASP 0113'
Script timed out
And then, there is output (report with data)..

It retrieved the data fine, but why do I have the error message on the top?

Well, this is a pure guess. But one way it *could* happen would be for you
to have an infinite loop AFTER all of the reporting is done but before the
final </TABLEtag was written.

And if your reporting is done into a <TABLEthen the error message, since
it wouldn't be output with <TR><TD>...</TD></TRsurrounding it, then indeed
the browser might show the error message *before* the incomplete <TABLE>.

As Dave Anderson might comment, this would likely only happen with MSIE (and
possibly only with pre-MSIE 7 versions), but I have seen it happen with MSIE
6, for sure. (Well, not timeout...but other errors.)

You can find out the truth of my guess by inspecting the HTML. Do a
VIEW==>>SOURCE in the browser and look at the HTML (in Notepad, if using
MSIE, by default). See if the error message really is at the bottom of the
HTML text and is simply displaying at the top becuz of MSIE peculiarities.

Sep 11 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7134
by: carlos seramos | last post by:
I've got two IIS servers. One public and one staging. On the public server the ASP code works fine however on the staging server I've started getting this error recently: error '8002801d' Library not registered. /default.asp, line 4
1
7494
by: Lokesh | last post by:
Hi All, When i am accessing the website i am getting this error: Active Server Pages error 'ASP 0115' Unexpected error /hradmin/Default.asp
6
12827
by: THE BIG MAN | last post by:
I am getting the errror Active Server Pages error 'ASP 0141' Page Command Repeated /contactform.asp, line 12 The @ command can only be used once within the Active Server Page. Anybody know why? <% Dim myMail, myBody
1
1689
by: Terry | last post by:
I just upgraded an NT IIS server to 2003 and IIS 6.0 now my Active Server Pages .asp pages do not load or open in the browser I get 500 Error Server Error. Yet and htm page will open. What do I need to change? or configure? Thanks
7
1963
by: McKirahan | last post by:
What is "active content"? My ASP page just returns HTML.... I have a page with an .htm extension that has a form whose action is an ASP page which generates a report after updating a database with the form data. Under Windowx XP SP2 the IE6 "Information Bar" has the message: "To help protect your security, Internet Explorer has restricted this
3
3402
by: mehul | last post by:
Hi, I am trying to use Active Reports v1.1 (Build 1.1.0.84) in a ASP.NET application. Is it possible to use it through the COM interlop as Crystal Reports for .NET which comes built in with VS.NET doesnt work properly. Rgs,
1
4750
by: Andrew | last post by:
Hey all, Working on revamping our Intranet here and making use of the LDPA, Active Directory, Directory Services, etc. that .Net provides. I am still fairly new on this subject, so the problem I have run into I am not sure how to fix, and really not sure what is causing it. Here's what is going on (test server - Windows 2003 Server): I have a page in a folder (under anonymous authentication in IIS6) that has a link on it that...
1
2501
by: george | last post by:
Hi all, here's my index.asp file. I don't know where has gone wrong. can't run properly, just showing error ASP 0113 Script timeout <!--#include file="head.asp"--> <!-- begin masthead -->
3
10577
by: =?Utf-8?B?SnVzdGluIERvaA==?= | last post by:
I am constantly getting the 'Script timed out' error, and would like to see if there is any way I could modify the ASP page. I think I did all I could to improved the performance at the database table level, but when it comes to the ASP, the error occurs most of time. This error happens when this ASP page has been moved to a new server. I modified the "server.ScriptTimeout = " at the ASP and also at IIS. The report does not retrieve...
0
8703
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9185
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9050
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8935
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7773
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3069
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.