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