我这里有个ogg同步,从库经常报如下错误，网上搜了很多解决办法，都没有解决，不知道什么原因
OCI Error ORA-01400: cannot insert NULL into
环境：
主库操作系统是:hp-unix
从库的操作系统是:Centos 6
主库和从库的版本都是11.2.0.4
ogg的版本是:Version 11.2.1.0.27 19591627 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_141006.1156_FBO
ogg从库的配置如下:
replicat repep
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
DiscardFile ./dirrpt/repep.dsc, append, Megabytes 200
gettruncates
AllowNoopUpdates
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DBOPTIONS DEFERREFCONST
HANDLECOLLISIONS
MAP EPI_SZ.SYS_AREA,TARGET EPI_SZ.SYS_AREA;
MAP EPI_SZ.SYS_STATION,TARGET EPI_SZ.SYS_STATION;
MAP EPI_SZ.SYS_BACTINFO,TARGET EPI_SZ.SYS_BACTINFO;
MAP EPI_SZ.SYS_BACTZQINFO,TARGET EPI_SZ.SYS_BACTZQINFO;
MAP EPI_SZ.EPI_CHILDINFO,TARGET EPI_SZ.EPI_CHILDINFO;
MAP EPI_SZ.EPI_CHILDPRE,TARGET EPI_SZ.EPI_CHILDPRE;
MAP EPI_SZ.EPI_JZJL,TARGET EPI_SZ.EPI_JZJL;
DDLERROR 10655 IGNORE
DDLERROR 10636 IGNORE
错误信息如下,这个表EPI_CHILDINFO的主键是FCHILDNO
OCI Error ORA-01400: cannot insert NULL into ("EPI_SZ"."EPI_CHILDINFO"."FCHILDNO") (status = 1400). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "EPI_SZ"."EPI_CHILDINFO" ("UNITCODE","UNITNAME","SUPCODE","CHILDNO","IMUNO","PWD","NAME",
"BIRTH","SEX","BLOODTYPE","REGTYPE","DWELLADDR","COMADDR","FATHERNAME","MOTHERNAME","FATHERUNIT","MOTHERUNIT","MOBPHONE","OTHERPHONE","BIRTHHOS","BIRTHDR","CARDUNITCODE","CARDDATE","BOOKINGDATE","CARDSUMNO","INSMONEY","MHBSAG","FHBSAG",
"MHBEAG","BCGSCAR","ALLERGY","TABU","SMSTAG","PHONETAG","STATUS","TRANSCOUNT","TRANSTIME","REMARK","UPDATETIME","B001","B002","B003","B004","B005","B006","B007","B008","B009","B010","B011","B012","B013","B014","B015","B016","B017","B018
","B019","B020","B021","B022","B023","B024","B025","B026","B027","B028","B029","B030","B031","B032","B033","B034","B035","B036","B037","B038","B039","B040","B041","B042","B043","B044","B045","B046","B047","B048","B049","B050","B051","B0
52","B053","B054","B055","B056","B057","B058","B059","B060","B061","B062","B06
Aborting transaction on ./dirdat/ep beginning at seqno 9405 rba 17711302
error at seqno 9405 rba 17718274
Problem replicating EPI_SZ.EPI_CHILDINFO to EPI_SZ.EPI_CHILDINFO
Mapping problem with insert record (target format)...
评论
有用 0出错的表FCHILDNO只有该字段是主键非空约束，其他的都是可为空
而且我从dsc文件中检查发现FCHILDNO具体的记录在主从库是存在的，
HANDLECOLLISIONS 参数的场景我知道是更新的记录从库不存在就会转换成insert，但是我这里查看更新的记录从库都是存在的。
评论 有用 0
