为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：
之前全部迁移的时候外键就没建立

之后执行外键建立语句报 被引用表 引用索引不存在 是什么问题
一下是俩个表的建表语句 以及建立外键的 语句

CREATE TABLE "CMS"."TASK"
(
"GUID" VARCHAR(32) NOT NULL,
"CHANNELNO" INT,
"DOMAINID" INT DEFAULT 0 NOT NULL,
"GUNAME" VARCHAR(32) NOT NULL,
"GUFULLNAME" VARCHAR(256),
"GUTYPE" INT NOT NULL,
"RELATIONGUID" VARCHAR(32),
"PUID" VARCHAR(32),
"HASDOME" INT,
"STATE" INT DEFAULT 0,
"BYPASS" INT,
"WNDMODEID" INT,
"LONGITUDEMAP" VARCHAR(32),
"LATITUDEMAP" VARCHAR(32),
"LONGITUDEEARTH" VARCHAR(32),
"LATITUDEEARTH" VARCHAR(32),
"GUSCALE" VARCHAR(32) DEFAULT '0' NOT NULL,
"CLASSROOMID" INT,
"LEDDISPLAYTYPE" INT,
"LEDDISPLAYSEQ" INT,
"DESCRIPTION" VARCHAR(1024),
"ALARMTEXT" VARCHAR(512),
"TIME" VARCHAR(32),
"RESERVE1" INT,
"RESERVE2" VARCHAR(32),
"CREATEBY" VARCHAR(32),
"CREATETIME" VARCHAR(20),
"UPDATEBY" VARCHAR(32),
"UPDATETIME" VARCHAR(20),
"LOCKPOS" TINYINT DEFAULT 0,
"TASKTYPE" INT DEFAULT 1,
"LONGITUDEWGS84" VARCHAR(32),
"LATITUDEWGS84" VARCHAR(32),
"COORDINATE" VARCHAR(16) DEFAULT 'wgs84',
NOT CLUSTER PRIMARY KEY("GUID", "DOMAINID"),
CONSTRAINT "TASK_IBFK_1" FOREIGN KEY("PUID") REFERENCES "CMS"."EQUIP"("PUID") ON DELETE CASCADE  ON UPDATE CASCADE ,
CONSTRAINT "TASK_IBFK_2" FOREIGN KEY("DOMAINID") REFERENCES "CMS"."DOMAIN"("DOMAINID") ON DELETE CASCADE  ON UPDATE CASCADE ) STORAGE(ON "CMS", CLUSTERBTR) ;

COMMENT ON COLUMN "CMS"."TASK"."CREATEBY" IS '创建者';
COMMENT ON COLUMN "CMS"."TASK"."CREATETIME" IS '创建时间';
COMMENT ON COLUMN "CMS"."TASK"."UPDATEBY" IS '更新者';
COMMENT ON COLUMN "CMS"."TASK"."UPDATETIME" IS '更新时间';


CREATE  INDEX "IDX_RESERVE1" ON "CMS"."TASK"("RESERVE1" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "INDEX103697100285000" ON "CMS"."TASK"("PUID" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "IDX_TASK_GUID" ON "CMS"."TASK"("GUID" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "INDEX103697120622600" ON "CMS"."TASK"("DOMAINID" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "INDEX_CHANNELNO" ON "CMS"."TASK"("CHANNELNO" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "IDX_STATE" ON "CMS"."TASK"("STATE" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;

CREATE TABLE "CMS"."TASKINFO"
(
"GUID" VARCHAR(32) NOT NULL,
"PUID" VARCHAR(28),
"TASKTYPE" INT DEFAULT 1,
"REPORTPICSTATUS" INT DEFAULT 0,
"RESERVE1" INT,
"RESERVE2" VARCHAR(64),
"SNAPCOUNT" INT DEFAULT 0,
"ALARMCOUNT" INT DEFAULT 0,
"ENCODER" INT DEFAULT 0,
"PLANSNAPNUM" INT,
"SNAPNUM" INT DEFAULT 0,
"TIMINGSNAPNUM" INT DEFAULT 0,
"MANUALSNAPNUM" INT DEFAULT 0,
"ROBOTMACID" VARCHAR(64),
"CAPTURETIME" VARCHAR(32),
"PICID" INT,
"ALARMID" INT,
"ALARMTIME" VARCHAR(16),
"FAULTFLAG" TINYINT DEFAULT 0,
"ALTITUDE" REAL,
"ALARMNUM" INT DEFAULT 0,
"PICALARMNUM" INT DEFAULT 0,
"NOPICALARMNUM" INT DEFAULT 0,
"PICURL" VARCHAR(256),
"ALARMPICURL" VARCHAR(256),
"TEMPUNIT" TINYINT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("GUID")) STORAGE(ON "CMS", CLUSTERBTR) ;

COMMENT ON COLUMN "CMS"."TASKINFO"."ALARMCOUNT" IS '累计告警数';
COMMENT ON COLUMN "CMS"."TASKINFO"."REPORTPICSTATUS" IS '0:未上图  1：有上图 当天是否有上传图片状态';
COMMENT ON COLUMN "CMS"."TASKINFO"."RESERVE1" IS '保留以待扩展';
COMMENT ON COLUMN "CMS"."TASKINFO"."RESERVE2" IS '保留以待扩展';
COMMENT ON COLUMN "CMS"."TASKINFO"."SNAPCOUNT" IS '累计抓拍数';
COMMENT ON COLUMN "CMS"."TASKINFO"."TEMPUNIT" IS '温度单位：0:摄氏 1:华氏 默认:摄氏';


CREATE  INDEX "INDEX_PICID" ON "CMS"."TASKINFO"("PICID" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "IDX_REPORTPICSTATUS" ON "CMS"."TASKINFO"("REPORTPICSTATUS" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "INDEX103696820306000" ON "CMS"."TASKINFO"("ALARMTIME" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;
CREATE  INDEX "INDEX103696827896000" ON "CMS"."TASKINFO"("PUID" ASC) STORAGE(ON "CMS", CLUSTERBTR) ;

ALTER TABLE "CMS"."TASKINFO" ADD FOREIGN KEY("GUID") REFERENCES "CMS"."TASK"("GUID") ON DELETE CASCADE  ON UPDATE CASCADE ;