Hi Bhavbhuti,

>
>
> I just got a copy of the corrupted database and tried to open the
> table in FlameRobin and I get the following message:
> ---------------------------
> An IBPP error occurred.
> ---------------------------
> *** IBPP::SQLException ***
> Context: Statement::Fetch
> Message: isc_dsql_fetch failed.
>
> SQL Message : -901
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements
>
> Engine Code : 335544329
> Engine Message :
> invalid BLOB ID
>
> ---------------------------
> OK
> ---------------------------
> If I okay this message I still can see the data in the table but I am
> not sure which records are corrupted.
>

If you check IBPhoenix.com, you'll find IBFirstAid (or something like
that) which can diagnose and fix broken tables.

A missing blob can be ignored - it may even be a back version of
a blob. Try gbak with the -g switch.

Cheers,

Ann