I have solved the immediate problem, but it seems like a workaround
so I am leaving the entire original message intact below in case
someone can tell me what is going on.

I noticed that the select for the RDB$Indices reported <null> for
Index_Inactive. So with a newly created table with no rows, I created
my FK and then did a backup and restore. Then when I looked at this
query again, the Index_Inactive was = 1, not <null>. Now I can import
my data.

Anyone know what is going on here?

Rick

> 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)
> );
>