At 10:56 AM 12/05/2005 +0100, you wrote:

>Hi,
>
>
>
>I am using FB SS 1.5.2 with Delphi Apps connecting through the BDE
>(5.1.2) to the FB database.
>
>
>
>I am experiencing some very random problems where every once in a while
>calling .ApplyUpdates on my Query will throw an exception, something
>like;
>
>
>
>Insufficient disk space. File:
>C:\DOCUME~1\jamesw\LOCALS~1\Temp\INMEM000.REM
>
>
>
>Can anyone shed any light what might be wrong ? I have checked the file
>system of the pc in question and it has plenty of free space etc.

Does it have plenty of free space in that temp directory where the BDE is
putting its local files for the dataset cache? Your error message
indicates that it doesn't. It's not a database engine error but a
filesystem one.

>Also I can get randomly an "Operation Aborted" Exeption raised at the
>same point.

Again, not a database engine error. It's a Delphi one, probably in
response to running out of space to park the Paradox files created by the
BDE. It's a fair guess that you are using TTables there (not a good thing
with client/server) and thus creating enormous cache files. If you have
long-running transactions as well, chances are that there are a LOT of
those files.

Depending on where the Paradox log and lock files are, it would be worth
taking a peek at the sizes of them to see whether it's time to delete them
(which you do with all apps and the db server shut down, natch.)

>I cannot replicate it either which is rather annoying, is
>this an error anyone else has come across and can give me some pointers
>to look into.

Not what you want to hear, but if you are trying to use Fb 1.5, then it's
past time that you dropped the BDE. That version doesn't support native
Firebird databases (dialect 3, that is). The last-ever BDE InterBase
driver was 5.2, which was only supported (and then only marginally) as far
as Delphi 6. Basically Borland stopped BDE support for IB and family at IB
5.6, given that they never shipped a driver that fully supported the IB 6+
changes.

Short term, try to make more space available on the C drive for the Paradox
files. Also do other sensible things like moving your Firebird engine temp
directories to explicit locations on another drive that has adequate space,
so that the Firebird engine is not competing with the Paradox engine for
temporary space. If you have other apps on the server that accumulate huge
volumes of temp files, such as a web browser or another BDE system, then
early retirement could be a solution. :-)

./heLen