I had the same problem.What i did:
-backed up the database with gback
-tried to restore it using gback and failed but it
stopped when tried to restore an index.
-I dropped that index, backed up again, restored the
database without errors and after that added again the
same index.
After that all was ok.
Sorry for english.Hope it helps.

--- Rick DeBay <rdebay@...> schrieb:

> I forgot to add that gfix -validate shows no errors.
> I'm running FB
> 1.5.1 and DBW 1.4.2. With JayBird RC4 I get (typo
> is from JB, not me):
> org.firebirdsql.jdbc.FBSQLException: You cannot
> getAutomcommit on an
> unassociated closed connection
>
> -----Original Message-----
> From: Rick DeBay
> Sent: Tuesday, August 10, 2004 10:46 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] internal gds software
> consistency check
> (partner index description not found (175))
>
> I get this error:
> internal gds software consistency check (partner
> index description not
> found (175))
>
> when I run a stored procedure that updates two
> tables that have a
> foreign key relationship:
>
> CREATE PROCEDURE INVOICE_ALL_CLAIMS (
> INVOICE_NO VarChar(10),
> INVOICE_DT Date)
> returns (
> INV_COUNT Integer)
> AS
> DECLARE VARIABLE ACCOUNT VARCHAR(15);
> DECLARE VARIABLE PHARM DECIMAL(7,0);
> BEGIN
>
> FOR SELECT DISTINCT
> ACCOUNTID,
> SRVPROVID
> FROM CLAIMSPAIDREVERSED
> WHERE INVOICE IS NULL AND DATESBM <= :INVOICE_DT
> INTO
> :ACCOUNT,
> :PHARM
> DO BEGIN
> INSERT INTO INVOICE (INVOICE_NO, ACCOUNT,
> PHARMACY)
> VALUES (:INVOICE_NO, :ACCOUNT, :PHARM);
>
> UPDATE CLAIMSPAIDREVERSED
> SET INVOICE = :INVOICE_NO
> WHERE
> ACCOUNTID = :ACCOUNT AND SRVPROVID = :PHARM
> AND
> INVOICE IS NULL AND DATESBM <= :INVOICE_DT;
> END
> SELECT COUNT(INVOICE) FROM CLAIMSPAIDREVERSED
> WHERE INVOICE = :INVOICE_NO
> INTO :INV_COUNT;
> END
>
> ALTER TABLE CLAIMSPAIDREVERSED ADD CONSTRAINT
> FK_CPR_INVOICE
> FOREIGN KEY (INVOICE,ACCOUNTID,SRVPROVID)
> REFERENCES INVOICE
> (INVOICE_NO,ACCOUNT,PHARMACY)
> ON DELETE NO ACTION
> ON UPDATE NO ACTION;
>
> Rick DeBay
> Senior Software Developer
> RxStrategies.net
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Yahoo! Domains - Claim yours for only $14.70
>

http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM

>

--------------------------------------------------------------------~->

>
>
>
> Yahoo! Groups Links
>
>
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
>

___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de