I am trying to write a search script in my spare time at work. We have a knowledge base consisting of 200+ .mht files. My script was working ok when I was testing it on just a few files but I am getting out of memory errors trying to search through the whole KB. Here is the search code:
View RepliesI am trying to create a search script but I am running into an out of memory error. Here is the search subroutine which loops multiple times:
Code: .....
We're getting "ERROR (0x8007000E) Not enough storage is available to
complete this operation" errors on a fairly large, busy ASP/SQL Server web
site. The error is being thrown on a line calling oRs.GetRows() on one of
our busiest pages. The array returned from the GetRows() call will be
'cleaned up' when the page goes out of scope, but I wonder if we should be
calling Erase specifically after the last usage to explicitly free allocated
memory. Is there any actual benefit doing this cleanup explicitly? I've
always throught that ASP's memory deallocation was a bit spotty - can anyone
comment.
We are receiving an error in our ASP website that used to run fine on our old servers but seems to be struggling on our new ones, I'm wondering if you've seen this error before?
Microsoft Cursor Engine error '8007000e'
Out of memory.
/oob/activities/default.asp, line 470
The last line that shows where the error happening is different on every page but it appears at the first database connection on each page.
The only way to get rid of the error and get the site working again is to recycle the application pool for the site (or restart IIS).
We have two servers, one running IIS and the other running MSSQL 2005. Both are the following specs: Code:
I think I already know the answer ("NO"), but I figured I'd ask anyway:
Is there a way to populate a SQL-like object entirely in memory, without having to save it in a SQL-like environment like MySQL, MS-SQL, or Access?
I'd like to take the contents of some CSV's and dump them into a virtual SQL table, and then call from that table using a SQL statement ("SELECT * FROM VirtualTable WHERE Foo='Bar'"). I know that in .NET I could use a data-grid to do basically that, but I was wondering if there was a classic ASP solution.
I am getting an ASP error.. that tells the server it is OUT OF MEMORY.then the server displays a message about the DLLHOST.exe and it waits for an "OK" from me.after hitting OK... it goes back to working fine.BUT, while the notification is up on the screen.the website is NOT AVAILABLE.that is the message that visitors get when they try to get to the website.so, is there a way I can tell the system to SKIP the notification .andmjust restart the service.
What memory is the issue here.I am assuming this memory error is coming from an INFINITE LOOP or something.from one of my ASP pages. so, I would imagine the best move would be to get RID of the "On Error Resume Next" code at the top of my pages.. to try and isolate the problem?
I'm having a problem that I can only attribute to something that I don't
know about ADO. I am using an ADODB.Connection with .CursorLocation = 3
since I am using MSSQL with text fields.
I am running a large set of 4 LEFT JOINS (5 tables in all). Currently
my recordset is returning 168 rows and 23 colums. After looping through
the ADO connection 27 times (creating a pdf report for users to print)
the data goes nutz. I have tried using different inputs and no matter
what on the 27th time is stops.
Does any body know any tool that profiles Internet Explorer for memory
leaks.
am just wondering is there a easier way to release all the memory after the program is done?or do I need to set all my variable = nothing one by one at the end of my code?
View Replies View RelatedWe've got this problem on our site where slowly eats virtual memory until IIS stops serving pages...
Restarting the IIS process fixes the problem, until the next time it reaches that point. I've made sure all our ADO objects are being closed and set = Nothing. I don't know what else could eat up all that memory...
Had developed a webpage to refresh automatically from one ASP page to another, with the feature of displaying local data that is actively poll & inserted from other remote database servers. The local server is using IIS & Microsoft SQL 2000. I have the problem of "Out of Memory at line 30" after the ASP page has ran for 13 hours, at client machines that is connecting to the server hosting the ASP. However by closing the Internet Explorer and re-open the ASP page, the problem is temporary resolved until another 13 hours later. I think i've had the server objects set to nothing, and had put all queries into sub. I couldn't think of other solution for the problem...
Is duplication of sub affecting the performance? Any setting to be done on server, e.g. IIS / SQL? I've attached the ASP file.
Are there any tools to test asp code on memory leaks. Or the took that will monitor IIS server against specific asp-page in order to find mem leaks on in.
View Replies View RelatedI am trying to configure apache::asp on apache2 and when i try to serve an asp page I get an internal server error. I get this in the error logs
66.249.65.228 - - [10/Jan/2008:12:57:57 -0500] "GET /asp/includes/functions.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:58:38 -0500] "GET /asp/includes/feed.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:06 -0500] "GET /asp/includes/contactField.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:19 -0500] "GET /asp/includes/encryption.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:33 -0500] "GET /asp/includes/LogonEdit.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:47 -0500] "GET /asp/includes/header.asp HTTP/1.1" 500 603
We've been expriencing periodic database connection errors with ASP code
talking to an MS Access database. Every once in a while, the code can't
connect to the database.
Usually there are no log entries that might point
to difficulties, but early this morning the Application Log was filled with
the 2 errors below. Once we did an IISRESET, the problem cleared. Does IIS
need to be re-installed, or??
Since upgrading to Windows 2003 Server from Windows 2000
Enterprise Server we have had alot of ASP problems. The
problems are centered around asp pages which are one level
or more below the main folder within a web site. We have
many web sites which have used the database interface
wizard in FrontPage which puts these pages up to three
levels deep inside the folder hierarchy of the main site.
The pages will not work with IIS 6. I have had to re-
engineer many of these sites without the database
interface wizard. My solution at this point is to put all
ASP pages at the root level which seems to work but
negates all version of Frontpage management including
FrontPage 2003 Beta. This is a serious problem!
Especially for us who teach FrontPage and ASP!
first, in NS (version 3, don't ask), get a
Code:
HTTP Error 400
400 Bad Request
Due to malformed syntax, the request could not be understood
what's that?
second, how do you turn the pop-up error alert window in IE for Mac off so that we can see the error in the browser window?
just for the record, the app works in windows fine, seems to have troubles on the Mac side.
I have a classic ASP application that runs fine on IIS on win 2000 or IIS on XP. But recently a client installed it on Win 2003 and now consistently gets an Internet Explorer-side error:' syntax error line. char 1' when he browses to it with IE 6.0.
When client moved the whole app as-is to an XP machine and then browsed to
it, he had no problem. I suspect the error involves client-side javascript. Iam looking into it; in the meantime:Are there a known issues of this kind involving IE 6.0 and windows 2003?
I recently finished a project for someone and they are getting 500 errors. What's driving me nuts is the application works fine from my location. All I can think is it could be a firewall issue but I've messed with my firewall and I can't reproduce the error.
What's ever more annoying is they are getting this error from more than one location. I don't see anything that would cause this. This is an admin application that uses Session and adds/updates an access DB. Works fine here.
I am trying to beef-up the security when passing data between pages. I am currently using the following code to navigate between some of my pages.
<a href="javascript: GetFormValue(FRMTRANSFERS.TXTHOSPITALID,'ADDPATIEN T');">
<SCRIPT LANGUAGE="JavaScript">
function GetFormValue(FField,StrPage)
{
var myField = FField
var myNumber = myField.value
self.location = StrPage + ".asp?ID=" + myNumber;
}
</SCRIPT>
I would rather use cookies to do this but i need to know if you can create a cookie that doesn't get written to the harddrive. I can't use session variables as i can't write then in Javascript - at least i think not -
I have managed up to the point that a byte[] imageContent contains a picture which i can show in a aspx page by:
// return byte array to caller with image type
Response.ContentType = "image/jpeg";
Response.BinaryWrite(imageContent);
but what i need is to post it back to the page that the user entered various details without losing them.
I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.
For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program runs for all day it hangs up and shows
nothing.
In the asp program I have many if and then statement as well as big
loop.
My question is how can I solve this problem? Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.
I have a page which sends a query to an DB2 using an ODBC. The
results are then written to a text file. I am unable to write directly to
the users drive because of permissions.
The problem I have is that when the
query set becomes too big, I get error '8007000e' Not enough storage is
available to complete this operation. The query is returning 100, 000
records or more. So my question is how do I handle this? Somebody had
suggested to me to chunk the data. Code:
I get the following error message from an ASP page that we have:
METHOD: POST
ERROR DESCRIPTION: 007~ASP 0100~Out of memory~Unable to allocate required
memory.
ERROR NUMBER: -2147024882
ERROR SOURCE: Response object
Does anyone out there have any ideas? Please let me know if you need any
more information ... I am not sure why this message has suddenly started to
pop up.
I checked the system logs and cannot see any particular memory loss related
message so I don't know.
I have found this message in Event Viewer on my Windows 2000 server.
Error: File/Test/upload/upload.asp Line 85 Out of memory. Unable to allocate required memory..
It seems to be the cause of a problem I have had uploading and downloading files through an ASP page using Binary Stream Objects. Anyone got any ideas about how to solve this?
I have a problem with a bit of asp used in a date selection box. It is supposed to get the right days and dates and then list them in the select box for up to a week ahead. The error i get is Out Of Memory specifically the line reading:
ReDim daysOfWeek(strDaysTaken)
Here is the code:
I'm creating some menus based on a recursive menu script I got from here
I have modified it to use a SQL database as well as a jquery nested menu which works similarly to suckerfish dropdowns.
What I want the script to do is to recursively go through the list and when there is a child display it. My version works just fine the first go around but then fails once it's called a second time.
I can't show you the link because it's on our internal server, but here is my code:
I am getting the following error from my ASP application:
Microsoft VBScript runtime error '800a0007'
Out of memory: 'Server.CreateObject'
It always (as far as i have observed) occurs when i try to create a new
ADODB.connection object in my cCon helper function (opening a connection and
returning it):
Function cCon()
Dim cnRet
set cnRet = server.createobject("ADODB.Connection") 'This is where the
error is thrown
cnRet.connectionstring = GLB_CONSTR_DB
cnRet.open
Set cCon = cnRet
End Function
The page that errors will typically call this function 6- 10times from
different functions which handle their connections in this way: Code:
I have a huge web site mixed ASP and ASP.NET and MSSQL. I am using hosting provider who set my site to use no more than certain amount of memory. Some times the site gives error server down because the server starts to freee up the memory when it reaches the maximum. Please give me some advices how to track the leeking memory. I suppose it's because of some unclosed db connections.
View Replies View RelatedI am having this problem (Listed in the Subject line)with my IIS 5.0 Server.
Installed on an IBM @series with 512MB.
We are doing a stability test on our application to prepare for Microsoft
SQL Server 2000 certification, and we found a memory leak, but we cannot find
its source and fix it.
We use an ASP page written in JScript that connects to Analysis Services
2000 using ADOMD and retrieves data from it (this is a very simplified
version of our real application that we created just to test the memory
leak), see the code below.
We are using Microsoft Application Center Test to run this page, and
Performance Monitor to monitor the Memory/Committed Bytes and Processor usage
of our web server. The Memory/Committed counter slowly increases over time,
which indicates a memory leak, right? The Private Bytes for the InetInfo
process remain stable.
Our setup is a web server running Windows 2000 and Analysis Services on a
different server running Windows 2000. The application Center Test is running
from another computer. We also tried using a web server running Windows XP
Pro instead of Win2000, with similar results.
Using PerfMon, we monitor the number of Analysis Services connections, and
this number remains stable, so the memory leak doesn't seem to be due to an
ever increasing number of AS open connections.....
Is there a way of performing an sql query and then call it again from memory rather than having to execute the query again?
As We have a few pages which gets data from a long query but then depending on user interaction could get recalled several times but with the data still the same.
I am running a web application with application protection level set to high, so it runs in a separate dllhost.exe process, the process takes around 14,000 K of memory I wanna know if this is fine or I have a memory leak problem.
I set all record sets to nothing without closing them and also I close the database connection.
Are there any tools that can measure the ASP page performance and tell me where do I have performance bottlenecks?
Can this be the reason for huge memory expansion ? Doesn't this script free memory of the object it had created?
sub createCOMobject()
set obj1 = createObject("object1")
dim flag = 1
useObject flag,obj1
end sub
----------------------------------
sub useObject (flag, byRef obj1)
....
set obj1 = Nothing
end sub ....