FBServer 1.5.3.4870

I'm creating a new database and have run into a frustrating problem.

I have the Customer_Orders table (see below). This should be related
to the Contacts table by FK Customer_Orders.Customernum ->
Contacts.Idnum. When I add this FK before importing any rows, I can
create the FK but then as soon as I add rows I get the message:

ISC ERROR CODE:335544333

ISC ERROR MESSAGE:
internal gds software consistency check (partner index description
not found (175))

Then I have to use gfix -mend.

If I add one row of data to the table and then create the FK, I get
the same message. Then gfix again.

I ran this query:

select R.RDB$CONSTRAINT_NAME, R.RDB$INDEX_NAME as REFINDEXNAME,
I.RDB$INDEX_NAME as REALINDEX, I.RDB$RELATION_NAME,
I.RDB$INDEX_INACTIVE
from RDB$INDICES I RIGHT JOIN RDB$RELATION_CONSTRAINTS R on
I.RDB$INDEX_NAME = R.RDB$INDEX_NAME
where R.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY' or R.RDB$CONSTRAINT_TYPE
= 'PRIMARY KEY'
order by R.RDB$CONSTRAINT_NAME

and noticed that all the REALINDEX columns are filled in, however the
INDEX_INACTIVE is <null> for the Customer_Order FK while all the
other values in this column for other relations are = 1

I am using DBWorkbench 3.0.4.2 for most of this work if that matters.

Anyone have a suggestion?

TIA,

Rick






CREATE TABLE CUSTOMER_ORDERS
(
IDNUM INTEGER NOT NULL,
CUSTOMERNUM INTEGER NOT NULL,
ORDER_DATE DATE DEFAULT 'TODAY' NOT NULL,
PONUM VARCHAR( 25) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
SOLDBY VARCHAR( 25) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
TERMSNUM INTEGER DEFAULT 1 NOT NULL,
SHIPVIANUM INTEGER DEFAULT 2 NOT NULL,
CONSTRAINT PK_CUSTOMER_ORDERS PRIMARY KEY (IDNUM)
);

CREATE TABLE CONTACTS
(
IDNUM INTEGER NOT NULL,
NAME VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
ADDRESS1 VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
ADDRESS2 VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
CITY VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
STATEORPROVINCE VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
ZIP VARCHAR( 25) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
COUNTRY VARCHAR( 60) DEFAULT ' UNITED
STATES' NOT NULL COLLATE ISO8859_1,
CONTACT VARCHAR( 60) DEFAULT ' ' NOT NULL
COLLATE ISO8859_1,
TERMSNUM INTEGER NOT NULL,
SHIPVIANUM INTEGER NOT NULL,
NOTE BLOB SUB_TYPE 1 SEGMENT SIZE 80,
DATE_ESTABLISHED DATE DEFAULT CURRENT_DATE
NOT NULL,
ISCUSTOMER D_BOOLEAN DEFAULT 1,
ISVENDOR D_BOOLEAN ,
ISBILLTO D_BOOLEAN ,
ISSHIPTO D_BOOLEAN ,
ISACTIVE D_BOOLEAN DEFAULT 1,
ISCREDITHOLD D_BOOLEAN ,
BILLTONUM INTEGER DEFAULT 0 NOT NULL,
OLD_IDNUM INTEGER DEFAULT 0 NOT NULL,
CONSTRAINT PK_CONTACTS PRIMARY KEY (IDNUM)
);