The referenced table was not found during semantic analysis. The referenced columns may need to be reordered to preserve functionality. This is done automatically when the referenced table is found in the input code, as shown in MSCEWI2032.
CREATE TABLE FK3(COL1 INTEGER,COL2 INTEGER,COL3 INTEGER,FOREIGN KEY (COL1, COL2, COL3) REFERENCES FK4 (COL1, COL2, COL3));
CREATE TABLE DATAWAREHOUSE.PUBLIC.FK3 (COL1 INTEGER,COL2 INTEGER,COL3 INTEGER);/*** MSC-Low - MSCEWI2033 - REFERENCED TABLE NOT FOUND, REFERENCED COLUMNS MAY NEED TO BE REORDERED ***/ALTER TABLE DATAWAREHOUSE.PUBLIC.FK3 ADD CONSTRAINT COL1FOREIGN KEY (COL1, COL2, COL3) REFERENCES DATAWAREHOUSE.PUBLIC.FK4 (COL1, COL2, COL3) ;
Check if you are able to add the missing referenced table to your input code so that SnowConvert is able to automatically reorder the referenced columns.