473,221 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

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 2319
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: John Silver | last post by:
I have a perl script running on machine A, a web server. A visitor completes certain pieces of data and these are compiled into two emails, one addressed to the visitor and copied to the site...
8
by: Mathieu Blais | last post by:
Hi, I need to capture the Script timeout error if that is possible. I know I can increase the timeout value in the server settings or in the scripts itself but I really want to make sure that no...
6
by: Randy Weber | last post by:
I occasionally am getting a script timeout while using an ASP database connection. Everything I read suggests that I can change the Server.ScriptTimeout to address this, but I was unable to find...
0
by: SPD | last post by:
I've been researching this issue with little luck. Here's the situation: We have a few users on slow dialup connections who are posting data from forms. Frequently, they get script timeout...
13
by: Patrick | last post by:
I understand that with IIS5.1 on Windows XP Professional SP1, I can 1) Either set under IIS Manager-> Any specific Virtual Directory-> Configuration->Options->ASP Script timeout for all pages...
11
by: www.MessageMazes.com | last post by:
I sometimes get this error after about 60 seconds of "waiting for mazes.com" (but when the page works, it usually loads in less than 12 seconds). > Active Server Pages error 'ASP 0113' > Script...
0
by: Frederic Wenzel | last post by:
I wrote a script on Linux that uses pyserial to read status messages from a serial line using readlines(). For now, it just displays what it gets on stdout: 17:42 | 0005 | 02 | | 5 |Rack...
8
by: michal | last post by:
hi guys, i was wondering how you deal with script timeouts caused by huge file uploads. Lets say I have a script timeout of 2 minutes and the user uploads a file which takes more than this ......
15
by: Mikhail Kovalev | last post by:
Fatal error: Maximum execution time of 3600 seconds exceeded in z:\home \localhost\www\somefile.php on line 138 php.ini setting fixes default max execution time at 30 sec, In the script itself I...
5
by: This | last post by:
I have a pretty basic emailing script that sends a relatively small number (150) of html emails. The emails are compiled, personalised from a mysql db subscribers list, and sent using mail() -...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.