ASP Script timeout

Surajit Laha · Jul 14, 2004

Hi,

I am suffering from a strange problem!

I was porting my ASP pages from one server to the other (both Win 2000
Ad. Server).

While I ported the reports it is not running at all at the new server
and throwing an error:
------
Active Server Pages, ASP 0113 (0x80004005)
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 tried the normal methods to fix this, changing IIS App settings and
increase the script timeout, but no result!!!

I have .NET Framework 1.1 installed with Win 2k SP4 in this new
server.
Rest seems to be the same.

Can anyone please point what is happening wrong??

I fetch some data from database, it seems like when the Recordset
tries to fecch data, it hangs.

If the page has no database interaction, it runs fine!

I checked the server process, when I send the ASP page request, the
DLLHOST process run by IWAM_<servername> account seems to be taking
99% of the server CPU!

Please put some light into it.

-surajit

Ray at · Jul 14, 2004

Hard to say without seeing some code. Is there an infinite loop somewhere?
That'd typically be the cause of this.

Ray at work

Surajit Laha · Jul 15, 2004

Hi,

I already told you that the code works perfectly fine in the current
server.
The trouble started when I ported the code to a new server!

If the code had some infinite loops etc., it would not even run in the
existing server (and that too so fast), I think you agree with this.

Still I would post some part of the code:
_______________________________________________
<code>
<%@ Language=VBScript %>
<%option explicit%>
<HTML>
<HEAD>
</HEAD>
<%
''define all connection settings here
dim con
set con=server.CreateObject("ADODB.Connection")
con.Open "dsn=RepProject; uid=reports; pwd=mypassword"
%>
<%
Dim StrSql
set rs=server.CreateObject("ADODB.recordset")
%>
<p align=center>

<TABLE WIDTH=100% ALIGN=center BORDER=0 CELLSPACING=0 CELLPADDING=0>
<TR>
<TD align=left width="20%"><IMG SRC="../images/logo.gif"></TD>
<TD align=center width="60%"><b><font face="verdana" size=4
color=blue>Metrics Report</font></b></TD>
<TD align=left width="20%"> </TD>
</TR>
</TABLE>
<br>

<table border=0 align=center>
<%
strsql="SELECT distinct B.PROJ_NAME, A.PROJ_ID FROM MSP_WEB_PROJECTS
A, MSP_PROJECTS B WHERE A.PROJ_ID=B.PROJ_ID AND B.PROJ_TYPE=0 ORDER BY
B.PROJ_NAME"

rs.Open strsql,con
%>

<tr>
<td>

<font face=verdana size=2 color=blue>Select Project(s):</font></td>
<td>
<SELECT size=7 id=project name=project multiple style=
"BACKGROUND-COLOR: lightsteelblue;" >

<%i=1%>
<%
do while not rs.EOF %>

<OPTION value="<%=trim(rs.Fields("PROJ_ID"))%>"><%=mid(trim(rs.Fields("PROJ_NAME")),1,len(trim(rs.Fields("PROJ_NAME")))-10)%></OPTION>
<%
i=i+1
rs.MoveNext
loop
rs.Close

%>
</SELECT> 
<%
set rs=nothing
con.close
set con=nothing%>

</code>
__________________________________________

If I simply comment rs.Fields parts of the code (opening the recordset
and then close it, it would run!!!)

Some articles on the net suggested that this could be related to
Windows 2000 SP4 issue.

Any lights, guys???

Please help.

-surajit laha

Ray at · Jul 15, 2004

Okay, you're right. Nothing is jumping out at me. Is anything showing up
in any event logs on the server or anything? Are any IIS settings different
between server 1 and server 2?

Ray at home

Surajit Laha · Jul 20, 2004

Hi Guys,

I have solved the problem!!!!!

What happened is, the SQL Server user, thru which I was connecting to
the database to fetch records, did not have enough permission on the
database!

The strange thing is that the error message never pointed me to any
SQL server timeout, it always told me that it is an ASP script timeout
error.

And why would the DLLHOST.exe would behave like that for this???

Really strange gyus.

But once I found the problem (after hell lot of brainstorming) and
resolved the issue, the report just flied!

Thnaks to you all who tried to help me out.

Regards,

Surajit Laha

Surajit Laha · Jul 20, 2004

Hi Guys,

I have solved the problem!!!!!

What happened is, the SQL Server user, thru which I was connecting to
the database to fetch records, did not have enough permission on the
database!

The strange thing is that the error message never pointed me to any
SQL server timeout, it always told me that it is an ASP script timeout
error.

And why would the DLLHOST.exe would behave like that for this???

Really strange gyus.

But once I found the problem (after hell lot of brainstorming) and
resolved the issue, the report just flied!

Thnaks to you all who tried to help me out.

Regards,

Surajit Laha

ASP TimeOut	1	May 5, 2004
"list of files" & timeout	1	Oct 27, 2003
Handling Script Timeout when invoking ActiveX Object	13	Nov 10, 2004
Active Server Pages error 'ASP 0113'	21	Sep 11, 2008
timeout expired	1	Jul 21, 2006
Script timed out Message added to Binary File End	11	May 4, 2006
"Free ASP Upload"... again	0	Mar 1, 2010
"Pure ASP Upload"... again	0	Feb 28, 2010

ASP Script timeout

Surajit Laha

Ray at

Surajit Laha

Ray at

Surajit Laha

Surajit Laha

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads