ogg同步报ORA-01400错误

我来答

Asky

2019-10-16

ogg同步报ORA-01400错误

oracle

我这里有个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

我来答

添加附件

问题补充

4条回答

默认

最新

杨德龙

cannot insert NULL into ？

后面接着是啥？没有了吗

有用 0

墨天轮

首先，既然加了下面的参数，数据肯定就会不同步。

HANDLECOLLISIONS

ASSUMETARGETDEFS

至于NULL，看下目标端是不是多了约束。

有用 0

Asky

错误信息如下,这个表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

Asky

出错的表FCHILDNO只有该字段是主键非空约束，其他的都是可为空

而且我从dsc文件中检查发现FCHILDNO具体的记录在主从库是存在的，

HANDLECOLLISIONS 参数的场景我知道是更新的记录从库不存在就会转换成insert，但是我这里查看更新的记录从库都是存在的。

有用 0

回答交流

提交

问题信息

请登录之后查看

邀请回答

暂无人订阅该标签，敬请期待~~

墨值悬赏