I used DBW's repair and got the following messages in the log:
RICK (Server) Tue Aug 10 11:49:52 2004
Database: C:\WINNT\SYSTEM32\RXS.FDB
Index 7 is corrupt on page 77742 in table CLAIMSPAIDREVERSED
(141)
RICK (Server) Tue Aug 10 11:49:54 2004
Database: C:\WINNT\SYSTEM32\RXS.FDB
Page 77805 is an orphan
RICK (Server) Tue Aug 10 11:49:54 2004
Database: C:\WINNT\SYSTEM32\RXS.FDB
Page 86680 is an orphan

How does this happen? I have forced writes on, and I don't muck with
the system tables.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, August 10, 2004 11:30 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] internal gds software consistency check
(partner index description not found (175))

At 11:19 AM 10/08/2004 -0400, you wrote:

>This useful link:
>http://www.ib-aid.com/interbase/firebird/error/commonerrors.html#partne

r

>_index_description_not_found
>
>suggested running a query to check that the correct indexes were there.
>There was no problem with my indexes.
>
>I tried to check the indexes after the error occurs, but I get an error
>that I can't continue after a bugcheck.

Try dropping and recreating the constraint.

/heLen





Yahoo! Groups Links