"Too Many Files" error message.

Jason · Guest

Hi,

We have recently started having a problem with Aardvark. On Saturday 27 November, when a user clicked on an attached file, an error message was reported: "too many files". This also occured for me. Restarting IIS temporarally solved the problem. However, this morning (30 Nov), the error message was back. I tried restarting IIS, but this did not fix the problem, so instead, "Shut Down" and "Started" the component services, which has once again "fixed" the problem. I dont know how long this will fix for.

Do you have any ideas as to what is going wrong? The server is a 2003 server with a local SQL installation.

Thanks,

Jason

chris sampson · Joined: 21 Sep 2004 Posts: 24 Location: Red Gate Sofware

Hi Jason,

May I ask, was anything put in your event logs at the time that this problem occured? Could you let me know what there is if so?
_________________
Chris Sampson
Support Engineer
Red Gate Software

Guest

Hi Chris,

No - there isn't anything out of the ordinary in the event logs, just the same old usual messages. I cant pinpoint an exact time, only a day (29 Nov) that the problem occurred, and there isnt anything.

Thanks,

Jason

chris sampson · Joined: 21 Sep 2004 Posts: 24 Location: Red Gate Sofware

Hi Jason,

Could you let us know the exact text for the error message and any numbers etc. associated with it.
_________________
Chris Sampson
Support Engineer
Red Gate Software

Jason · Guest

All it says is "Too Many Files". Is there an aardvark log file which I can look through for an error number?

All I can tell you is that the page that throws the error is download.asp - probably line 42 (displayed on 75) - however, you probably knew that already.

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Hi Jason,

From the Aardvark code it looks like there may be a potential problem if you have more than one entry in the attachments table for the same attachment on the same bug.

Maybe you can find out by running a query in the Aardvark database to find the records for the attachment:

Guest

Hi Brian,

The problem was not specific to one particular bug id - it was all attachments, no matter which bug they were in.

I am not totally sure what you are asking me to look for - however, I did a quick check, and we do occasionally have the same file in the same bug - however, the stored filename is different. Is this any help?

Thanks

Jason

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Hi Jason,

You can have many files with the same file name attached to an issue because the real 'physical' file name is a GUID. I've tested this bit and it works. It must be some system problem.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Hi Jason,

Do the filenames have speces in them? Maybe it would help to change download.asp so that the content-disposition header it sends is embedded in quotes.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

Jason · Guest

Hi Brian,

Once again, the server has started reporting "too many files" when openning an attached file. There is no space in the file name, and no other error code (html source of error page below, if that helps)

I have also dumped the variables out that were sent to obBugs.GetAttachment (the command I think is throwing the error):
Session=3
lID=555
sPublicName=NullPointerException.jar
vBinary=
lSize=17089
sError=Too many files

Running the SQL command suggested earlier, I get the following data returned:

RecordID=555
CompanyID=3
Type=B
ItemID=3208
PrivateName=C:\Program Files\Aardvark\Uploads\Uploaded\3\{1B79A099-88B5-4F5E-B74D-6CA50B27D344}
PublicName=NullPointerException.jar
FileSize=17089
BugID=3208
ExternalPassword=

It is worth pointing out that it is not only the above file that causes the problem - attempting to open ANY file will cause this error.

<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">




<title>Aardvark</title>

<style type="text/css">

</style>
<meta name="keywords" content="">
<link rel="stylesheet" href="styles/main.css">
</head>
<body bgcolor="#FFFFFF">



<P CLASS="WARNING">Too many files


</body>
</html>

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Hi Jason,

I've given up on the assumption that it's ASP, IIS or Aardvark that is throwing the error and concentrated on Visual Basic. 'Too Many Files' is a VB error (error number 67) that seems to hark back to the DOS days when you had to specify how many open files you could have at one time in your config.sys. I don't see how this applies to Windows 2003, but maybe the suggestions in the technet article help?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgTooManyFiles.asp
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

Guest

Okay. As an experiment, I wrote a program which created 3000 files and kept them open, wrote to these files in a nice random sort of way, then closed them all, without recieving an error.

As the "Solution" given by microsoft is to increase the number of free file handles, surely this is just delaying the inevitiable "too many files" error?

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Hi Jason,

I had a feeling this wouldn't work (unless you run DOS!). How about updating your Visual Basic Runtime and see if that helps? There could be a problem with the VB Runtime installation. Here is a link where you can download the VB 6.0 SP5 archive:

http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9a24f9-b5c5-48f4-8edd-cdf2d29a79d5&DisplayLang=en
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

Brian Donahue · Joined: 23 Aug 2004 Posts: 6341 Location: Red Gate Software

Just to confirm, the solution to this problem was to update the VB Runtime (VBRUN60.dll). This eliminated the 'too many open files' error for two occurrances of this problem.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

	All times are GMT + 1 Hour
Page 1 of 1