E_FAIL status error

[Database Administrator]

Our VB application is generating this error:

Data Provider or other service returned an E_FAIL status error

when we attempt to retrieve data from our HISTORY file on certain
records in our PSQL database.

We are running Pervasive SQL 9.5 on a Linux RedHat server. On the
local workstation PCC, in some instances (we have indentified about 15
employee records which are affected by this error) we have been able
to retrieve the records from the file (called HISTORY), delete them,
and then recreate them. When we do that, we are then no longer able to
bring the new records up in PCC - it just sits there querying for
ages, and we have to CTRL+ALT+DEL PCC. The GUI then generates that
error when we click to enter the HISTORY screen.

The application encountered I/O error. Btrieve error 2

The current positioning is invalide. Btrieve error 8

These are errors when querying in PCC to find the records. We have
looked these errors up but have not yet found a way to resolve the
issue. In the table that is causing us grief, there is a unique index
which is comprised of 3 primary keys in the table...we believe that
somehow, we have managed to create duplicate records that shouldn't
have happened, which has resulted in corrupted records. We believe
that we need to delete these dups (that we cannot see) but have not
quite figured out how to do that.

Can anyone offer some suggestions or guidance?

Thanks!

Liz

[Database Administrator]

The Status 2 indicates that the database file has been damaged
(literally, "I/O Error"). This means that you should stop using the
file and repair it as soon as possible, to prevent further data loss.

You can find infomration about basic file recovery from our web site at
www.goldstarsoftware.com/press.asp in the paper on Btrieve File
Maintenance. This should get you started.

If this is not sufficient, or if you are losing more records than you
can afford to lose, then our data recovery capability may also be
helpful to you. Click the big red "File Recovery" button on the website
mentioned above for more details.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - August 2008 ***


ackerliz@gmail.com wrote:
> Our VB application is generating this error:
>
> Data Provider or other service returned an E_FAIL status error
>
> when we attempt to retrieve data from our HISTORY file on certain
> records in our PSQL database.
>
> We are running Pervasive SQL 9.5 on a Linux RedHat server. On the
> local workstation PCC, in some instances (we have indentified about 15
> employee records which are affected by this error) we have been able
> to retrieve the records from the file (called HISTORY), delete them,
> and then recreate them. When we do that, we are then no longer able to
> bring the new records up in PCC - it just sits there querying for
> ages, and we have to CTRL+ALT+DEL PCC. The GUI then generates that
> error when we click to enter the HISTORY screen.
>
> The application encountered I/O error. Btrieve error 2
>
> The current positioning is invalide. Btrieve error 8
>
> These are errors when querying in PCC to find the records. We have
> looked these errors up but have not yet found a way to resolve the
> issue. In the table that is causing us grief, there is a unique index
> which is comprised of 3 primary keys in the table...we believe that
> somehow, we have managed to create duplicate records that shouldn't
> have happened, which has resulted in corrupted records. We believe
> that we need to delete these dups (that we cannot see) but have not
> quite figured out how to do that.
>
> Can anyone offer some suggestions or guidance?
>
> Thanks!
>
> Liz

[Database Administrator]

Thanks, Bill...I used your document and we were able to export the
data minus the corrupt records and then import it into a new table,
rename the old table and then rename the new table....all seems to be
back to normal...the process that crashed because of the corrupt data
has run properly and we are so very relieved!!! Kudos to my very
determined analyst!!

Appreciate your input!!

Liz



On Jul 29, 1:04*pm, BtrieveBill wrote:
> The Status 2 indicates that the database file has been damaged
> (literally, "I/O Error"). *This means that you should stop using the
> file and repair it as soon as possible, to prevent further data loss.
>
> You can find infomration about basic file recovery from our web site atwww.goldstarsoftware.com/press.aspin the paper on Btrieve File
> Maintenance. *This should get you started.
>
> If this is not sufficient, or if you are losing more records than you
> can afford to lose, then our data recovery capability may also be
> helpful to you. *Click the big red "File Recovery" button on the website
> mentioned above for more details.
> * * * * Goldstar Software Inc.
> * * * * Pervasive-based Products, Training & Services
> * * * * Bill Bach
> * * * * BillB...@goldstarsoftware.com
> * * * *http://www.goldstarsoftware.com
> * * * * *** Chicago: Pervasive Service & Support Class - August 2008 ***