Hi friends,


What does the following error mean? Any idea ?
(Firebird-1.0.2.908-Win32 on W2K)

Internal gds software consistency check (partner index description
not found (175))
Statement: delete from schedule

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
internal gds software consistency check (can't continue after
bugcheck).
Statement failed, SQLCODE = -902

This happens where I tried to delete records from a table
which has the following structure and contains only 6 records.

CREATE TABLE SCHEDULE (
ID SMALLINT,
SCHEDULE_NM VARCHAR(50),
BS_PL CHAR(1)
);

ALTER TABLE SCHEDULE ADD CONSTRAINT SCHEDULE_PK PRIMARY KEY
(ID);
CREATE UNIQUE INDEX SCHEDULE_SCHEDULE_NM ON SCHEDULE
(SCHEDULE_NM);


Foreign Key connections from account_heads and sub_schedule,
both
tables are empty.

ALTER TABLE ACCOUNT_HEADS ADD CONSTRAINT
FK_ACCOUNT_HEADS_TO_SCHEDULE FOREIGN KEY (SCHEDULE_ID) REFERENCES
SCHEDULE (ID);

ALTER TABLE SUB_SCHEDULE ADD CONSTRAINT
FK_SUB_SCHEDULE_TO_SCHEDULE FOREIGN KEY (SCHEDULE_ID) REFERENCES
SCHEDULE (ID);

I am able to insert and modify the records. Even a backup and
restore also did not help.

Please help.

Thank you.


Ben.

_______________________________________________________________________
Odomos - the only mosquito protection outside 4 walls -
Click here to know more!
http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&wn