?
Solved

Not enough temporary disk space in ASP.net application

Posted on 2008-11-13
6
Medium Priority
?
1,227 Views
Last Modified: 2012-06-21
I have recently switch a classic ASP application to an ASP.net version.  The application seems to work well, except for one issue that seems to be occurring(mostly at night/early morning).

I begin receiving the following messages in the event log:
Event code: 3001
Event message: The request has been aborted.

Followed by:
Event code: 3005
Event message: An unhandled exception has occurred.
Exception information:
    Exception type: OleDbException
    Exception message: Unspecified error

Then followed by:
Event code: 3005
Event message: An unhandled exception has occurred.
Exception information:
    Exception type: OleDbException
    Exception message: Not enough space on temporary disk.

The database in question is an access database.  Unfortunately for business reasons we are not able to use another database(mysql, mssql, etc).  We never had an issue with using access for the old ASP sight.

I checked the C:\WINDOWS\Temp directory on the server and there are a few Jet*.tmp files out there, none of them are larger than 4kb.  There is 2+ gigs left on the drive.  The only thing that seems to fix the issue is to restart IIS.  After that, everything works great for a few more days/weeks, then  the same issue begins to occur.  

My only thought is that there was some type of long query being run against the database, but I am unable to reproduce the error on my own(even querying all 22,000 records doesn't seem to cause the issue).

I have tried changing a few registry settings(altering the number of table locks, etc) for JET, but none of them seem to work.  The only other thing that is happening around this time are File indexing and Virus scanning, but even when those end, the problem persists until IIS is restarted.

Any help is appreciated.  I'm tired of getting up at 3:00 am to restart the services.
0
Comment
Question by:Morcalavin
  • 4
  • 2
6 Comments
 
LVL 7

Expert Comment

by:moseack
ID: 22951039
In my opinion it is related to the I/O access perfomed by either the file-indexing-service, or the anti-virus.
OleDB+Jet has known issues with handling failed connection (One failed connection can lock the service out).
0
 
LVL 18

Author Comment

by:Morcalavin
ID: 22951234
I don't understand why this would only be present in the .net app.  The classic ASP application ran for years and we never had this issue, even with indexes and virus scans going on.
0
 
LVL 18

Author Comment

by:Morcalavin
ID: 22951259
I've also found a few instances where this has happened when indexing and virus scanning was not running, although it seems to happen in the early morning more often than during the day.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 18

Author Comment

by:Morcalavin
ID: 23025048
I've come to the conclusion that this isn't related to the IO access of the disk, as it appears to be happening at other times when virus scan and catalogue isn't running.

Are there any knowlegebase entries or articles I can gleam from to better understand this "known issues with handling failed connections"

All of my connections are made via accessdatasources.  Is there any way to trap and cleanup connection errors in a way that won't lock out the service?

I've scoured the web and implemented pretty much every workaround for this issue and still nothing.
0
 
LVL 7

Accepted Solution

by:
moseack earned 1500 total points
ID: 23032865
This seems to be a very comprehensive article:
http://aspalliance.com/14
0
 
LVL 18

Author Closing Comment

by:Morcalavin
ID: 31516391
I converted the database over to an sql express database.  This should eliminate the access issues.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question