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