470,826 Members | 2,021 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,826 developers. It's quick & easy.

ASP Script timeout

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
Jul 19 '05 #1
7 2193
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" <s_****@rediffmail.com> wrote in message
news:ba**************************@posting.google.c om...
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

Jul 19 '05 #2
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%">&nbsp;</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(tri m(rs.Fields("PROJ_NAME")),1,len(trim(rs.Fields("PR OJ_NAME")))-10)%></OPTION>
<%
i=i+1
rs.MoveNext
loop
rs.Close

%>
</SELECT>&nbsp;
<%
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
Jul 19 '05 #3
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" <s_****@rediffmail.com> wrote in message
news:ba**************************@posting.google.c om...
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%">&nbsp;</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(tri m(rs.Fields("PROJ_NAME")),
1,len(trim(rs.Fields("PROJ_NAME")))-10)%></OPTION> <%
i=i+1
rs.MoveNext
loop
rs.Close

%>
</SELECT>&nbsp;
<%
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

Jul 19 '05 #4
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
Jul 19 '05 #5
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
Jul 19 '05 #6

Guys,

I am having a simular problem, but not using SQL!

here is my code:

DO while not rsImages.EOF
if(sFldValue=rsImages.Fields.Item("Image").Value) then
sTempImageList=sTempImageList & "<option SELECTED value='"
rsImages.Fields.Item("Image").Value & "'>"
rsImages.Fields.Item("Image").Value & "</option>"
else
sTempImageList=sTempImageList & "<option value='"
rsImages.Fields.Item("Image").Value & "'>"
rsImages.Fields.Item("Image").Value & "</option>"
end if
rsImages.movenext()
LOOP

rsImages.close()
Set rsImages = Nothing

sTempImageList="<select onchange='document.form1." & sFldName
".value=this.value; document.form1." & sFldName
"_IMG.src=""../images/"" + this.value.replace(""."",""_small."")'>"
sTempImageList & "</select>"
Ray at wrote:
*Okay, you're right. Nothing is jumping out at me. Is anythin
showing up
in any event logs on the server or anything? Are any IIS setting
different
between server 1 and server 2?

Ray at home

"Surajit Laha" <s_****@rediffmail.com> wrote in message
news:ba**************************@posting.google.c om...
Hi,

I already told you that the code works perfectly fine in th

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 i

the
existing server (and that too so fast), I think you agree wit

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=

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%">&nbsp;</TD>
</TR>
</TABLE>
<br>

<table border=0 align=center>
<%
strsql="SELECT distinct B.PROJ_NAME, A.PROJ_ID FRO

MSP_WEB_PROJECTS
A, MSP_PROJECTS B WHERE A.PROJ_ID=B.PROJ_ID AND B.PROJ_TYPE=0 ORDE

BY
B.PROJ_NAME"

rs.Open strsql,con
%>
<tr>
<td>

<font face=verdana size=2 color=blue>Selec

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(tri m(rs.Fields("PROJ_NAME")),
1,len(trim(rs.Fields("PROJ_NAME")))-10)%></OPTION>
<%
i=i+1
rs.MoveNext
loop
rs.Close

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

</code>
__________________________________________

If I simply comment rs.Fields parts of the code (opening th

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

-
budgy
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

Jul 19 '05 #7

Guys,

I am having a simular problem, but not using SQL!

here is my code:

DO while not rsImages.EOF
if(sFldValue=rsImages.Fields.Item("Image").Value) then
sTempImageList=sTempImageList & "<option SELECTED value='"
rsImages.Fields.Item("Image").Value & "'>"
rsImages.Fields.Item("Image").Value & "</option>"
else
sTempImageList=sTempImageList & "<option value='"
rsImages.Fields.Item("Image").Value & "'>"
rsImages.Fields.Item("Image").Value & "</option>"
end if
rsImages.movenext()
LOOP

rsImages.close()
Set rsImages = Nothing

sTempImageList="<select onchange='document.form1." & sFldName
".value=this.value; document.form1." & sFldName
"_IMG.src=""../images/"" + this.value.replace(""."",""_small."")'>"
sTempImageList & "</select>"
Ray at wrote:
*Okay, you're right. Nothing is jumping out at me. Is anythin
showing up
in any event logs on the server or anything? Are any IIS setting
different
between server 1 and server 2?

Ray at home

"Surajit Laha" <s_****@rediffmail.com> wrote in message
news:ba**************************@posting.google.c om...
Hi,

I already told you that the code works perfectly fine in th

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 i

the
existing server (and that too so fast), I think you agree wit

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=

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%">&nbsp;</TD>
</TR>
</TABLE>
<br>

<table border=0 align=center>
<%
strsql="SELECT distinct B.PROJ_NAME, A.PROJ_ID FRO

MSP_WEB_PROJECTS
A, MSP_PROJECTS B WHERE A.PROJ_ID=B.PROJ_ID AND B.PROJ_TYPE=0 ORDE

BY
B.PROJ_NAME"

rs.Open strsql,con
%>
<tr>
<td>

<font face=verdana size=2 color=blue>Selec

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(tri m(rs.Fields("PROJ_NAME")),
1,len(trim(rs.Fields("PROJ_NAME")))-10)%></OPTION>
<%
i=i+1
rs.MoveNext
loop
rs.Close

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

</code>
__________________________________________

If I simply comment rs.Fields parts of the code (opening th

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

-
budgy
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by John Silver | last post: by
6 posts views Thread by Randy Weber | last post: by
11 posts views Thread by www.MessageMazes.com | last post: by
reply views Thread by Frederic Wenzel | last post: by
8 posts views Thread by michal | last post: by
15 posts views Thread by Mikhail Kovalev | last post: by
5 posts views Thread by This | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.