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 7 2334
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
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(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>
<%
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
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%"> </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> <% 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
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
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
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%"> </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> <% 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
-----------------------------------------------------------------------
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%"> </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> <% 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
----------------------------------------------------------------------- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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 ......
|
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...
|
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() -...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |