I've received an error report containing the following exception message...

DBISAM Engine Error # 9217 Error reading from the table 'Z:\Medical
Service TimeOff\59880.DAT'

I know that normally this indicates a problem in the data file, but
since this is a temp table created by DBISAM, any information about what
would cause this problem?  (Delphi 7 and DBISAM 3.24).

--
Gordon Turner
Mycroft Computing
http://www.mycroftcomputing.com

Gordon,

<< I've received an error report containing the following exception
message...

DBISAM Engine Error # 9217 Error reading from the table 'Z:\Medical Service
TimeOff\59880.DAT'

I know that normally this indicates a problem in the data file, but since
this is a temp table created by DBISAM, any information about what would
cause this problem?  (Delphi 7 and DBISAM 3.24). >>

Do you know the type of operation being executed when this ocurred ?
Usually these types of operations are caused by external factors, such as
hard drive failures, disk space issues, AV software issues, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> Do you know the type of operation being executed when this ocurred ?
> Usually these types of operations are caused by external factors, such as
> hard drive failures, disk space issues, AV software issues, etc.

According to the EurekaLog file, it failed when executing a
StartTransaction.  (Seems like an odd place to be accessing temp tables.)

--
Gordon Turner
Mycroft Computing
http://www.mycroftcomputing.com

Gordon,

<< According to the EurekaLog file, it failed when executing a
StartTransaction.  (Seems like an odd place to be accessing temp tables.) >>

Is the customer using Vista, perhaps ?  It could very well be an issue with
the folder virtualization in Vista.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> Is the customer using Vista, perhaps ?  It could very well be an issue with
> the folder virtualization in Vista.

I don't think so.  EurekaLog identified the OS as XP/SP2, but I'm not
sure the version I was using could identify Vista.  However, the drive
letter for the file was Z:, so I doubt virtualization was the problem.

--
Gordon Turner
Mycroft Computing
http://www.mycroftcomputing.com

Gordon,

<< I don't think so.  EurekaLog identified the OS as XP/SP2, but I'm not
sure the version I was using could identify Vista.  However, the drive
letter for the file was Z:, so I doubt virtualization was the problem. >>

Then I would definitely look into AV software as a possible issue also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Gordon,

   I have had similar issues in XP when a user is not an administrative
level user. Their user rights dont give them the right to make temporary
tables.

   You might check it out - the temp files are created where your
privatedir is pointed to. By default it will be the same as where your app
is executed from. In XP a non-admin user cant modify files located under the
program files tree.

Neil Huhta



"Gordon Turner" <gordon@mycroftcomputing.com> wrote in message
news:1E24ACDD-87A7-48DB-B2E7-67C4B9DB42A0@news.elevatesoft.com...
> Tim Young [Elevate Software] wrote:
>>
>> Is the customer using Vista, perhaps ?  It could very well be an issue
>> with the folder virtualization in Vista.
>
> I don't think so.  EurekaLog identified the OS as XP/SP2, but I'm not sure
> the version I was using could identify Vista.  However, the drive letter
> for the file was Z:, so I doubt virtualization was the problem.
>
> --
> Gordon Turner
> Mycroft Computing
> http://www.mycroftcomputing.com

Neil,

<< You might check it out - the temp files are created where your privatedir
is pointed to. By default it will be the same as where your app is executed
from. In XP a non-admin user cant modify files located under the program
files tree. >>

This is covered here:

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

However, this wouldn't manifest itself as a #9217 error.  It would manifest
itself as a rights/access error when the table is opened again.

--
Tim Young
Elevate Software
www.elevatesoft.com