Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread DBISAM Engine Error # 11010 Table 'C:\Windows\TEMP\45760.DAT' does not exist.
Thu, Jul 17 2008 3:43 PMPermanent Link

"John Taylor"
I am using DBIsam 3.29, the subject describes the exception being thrown.
As you can see
the session's privatedir is set the the windows temp path.  Can anyone tell
me why this
'does not exist' exception would be raised ?

The pertinent procedure is...

procedure TFmSF4Main.RepairFolderTree(const ftype : string);
var
  sql : string;
  Q : TDBIsamQuery;
  tablename : string;
  count : integer;
  Root : string;
  s : string;
  TestPath : string;
  TestNode : TTreeNode;
  trash : string;
begin
    if ftype = 'S' then
    begin
      Root := 'Fax Folders\Outgoing Faxes\';
      trash := 'Trash\Outgoing';
    end
    else
    begin
      Root := 'Fax Folders\Incoming Faxes\';
      trash := 'Trash\Incoming';
    end;
    Q := TDBIsamQuery.Create(nil);
    Screen.Cursor := crhourglass;
    try
      if ftype = 'S' then
        tablename := 'sfsentfaxes.dat'
      else
        tablename := 'sfreceivedfaxes.dat';
      Q.DataBasename := dm.DBISAMDatabase1.directory;
      Q.SessionName := dm.DBISAMDatabase1.Sessionname;
      Q.RequestLive := true;//for speed
      sql := 'SELECT DISTINCT FOLDER FROM "' + tablename + '" WHERE FOLDER
<> "" ORDER BY FOLDER';
      Q.Sql.add(sql);
      Q.Open;
      Q.First;
      count := 0;
      while not Q.Eof do
      begin
        s := Q.FieldByName('FOLDER').AsString;
        if (length(s) > 0) then
        begin
          TestPath := Root + s;
          if s = trash then
            TestPath := 'Fax Folders\' + s;
          TestNode := Self.GetNodeFromPath(TestPath);
          if TestNode = nil then
          begin
            InsertPathInTree(s,ftype);
            inc(count);
          end;
        end;
        Q.Next;
      end;
    finally
      Q.Free;
      Screen.cursor := crdefault;
    end;
end;


Thanks in advance
John Taylor

Thu, Jul 17 2008 4:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< I am using DBIsam 3.29, the subject describes the exception being thrown.
As you can see
the session's privatedir is set the the windows temp path.  Can anyone tell
me why this
'does not exist' exception would be raised ? >>

More than likely it is AV software.  Are you running AV software ?  If so,
then see here:

http://www.elevatesoft.com/bulletin_14.htm

Unfortunately there isn't any way to fix this for 3.x unless you:

1) Turn off the scanning for the temporary files directory
2) Have the source code and change DBISAM to use different temporary table
extensions (not guaranteed to work for all AV software, either).

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Jul 18 2008 7:03 AMPermanent Link

"John Taylor"
The user insists that they are not running any AV software but I will prod
them again for the truth.

Thanks Tim.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:726FE96D-98AC-4435-9B5F-360FD4EB777A@news.elevatesoft.com...
> John,
>
> << I am using DBIsam 3.29, the subject describes the exception being
> thrown. As you can see
> the session's privatedir is set the the windows temp path.  Can anyone
> tell me why this
> 'does not exist' exception would be raised ? >>
>
> More than likely it is AV software.  Are you running AV software ?  If so,
> then see here:
>
> http://www.elevatesoft.com/bulletin_14.htm
>
> Unfortunately there isn't any way to fix this for 3.x unless you:
>
> 1) Turn off the scanning for the temporary files directory
> 2) Have the source code and change DBISAM to use different temporary table
> extensions (not guaranteed to work for all AV software, either).
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Image