fPSQL error

[Bruce Easton]

Twice to myself did I write in the forest, but a question have I still:

> I said on Monday, October 16, 2006 12:43 PM:
> >
> > I am getting an error from fPSQL:
> >
> > Error opening sort file
> > /aaa008e8:  Permission denied
> >
> > when I run a query on a client's Windows box that was recently restored.
> > This happens on at least two of the files, but does not happen
> on only one
> > of the filePro demo files that reside in the same directory.  I rebuilt
> > indexes and checked permissions and Novell netware rights on the
> > folders and
> > files to try to find a difference bewtween the one that does
> not give the
> > error and the others and I don't see any difference.
> >
> > I tried setting PFTMP to different things, but with no change to the
> > behavior I describe above.  Has anyone seen anything like this before?
> >
> > Bruce
>
> The filePro Plus is 5.0.14 and the fPSQL is 5.0.13DN9.  Don't
> know yet what
> the OS/network version is, but these were all harmonious before
> the restore.
>
> Bruce

Turns out this was a permissions problem on the root directory of the
server. One of the existing SQLs worked because it had no "GROUP BY" and
therefore did not need to create temporary sorting file in the root dir.

Is there any way to direct these temporary sorting files to another
directory?   We have already tried PFTMP.

Bruce

Bruce Easton
STN, Inc.