oracle数值插入空值,OGG 报插入空值错误（其实根本就没有插入空值）

2011-06-06 13:58:42  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  REPLICAT RTAB02 starting.

2011-06-06 13:58:42  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  REPLICAT RTAB02 started.

2011-06-06 13:58:42  WARNING OGG-01396  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  A complete after image is not available in HYDEE.U_CUSTOM_DEPT at rba 4949 in file ./dirdat/bb000000, while inserting a row into HYDEE.U_CUSTOM_DEPT due to missing target row for a key update operation. NOCOMPRESSUPDATES or FETCHOPTIONS FETCHPKUPDATECOLS may be specified in the EXTRACT parameter file to include a complete image for key update operations.

2011-06-06 13:58:42  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  OCI Error ORA-01400: cannot insert NULL into ("HYDEE"."U_CUSTOM_DEPT"."CUSTOMID") (status = 1400), SQL .

2011-06-06 13:58:42  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  Aborted grouped transaction on 'HYDEE.U_CUSTOM_DEPT', Database error 1400 (ORA-01400: cannot insert NULL into ("HYDEE"."U_CUSTOM_DEPT"."CUSTOMID")).

2011-06-06 13:58:42  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  Repositioning to rba 4949 in seqno 0.

2011-06-06 13:58:42  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  SQL error 1400 mapping HYDEE.U_CUSTOM_DEPT to HYDEE.U_CUSTOM_DEPT OCI Error ORA-01400: cannot insert NULL into ("HYDEE"."U_CUSTOM_DEPT"."CUSTOMID") (status = 1400), SQL .

2011-06-06 13:58:43  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  Repositioning to rba 4949 in seqno 0.

2011-06-06 13:58:43  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  Error mapping from HYDEE.U_CUSTOM_DEPT to HYDEE.U_CUSTOM_DEPT.

2011-06-06 13:58:43  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, RTAB02.prm:  PROCESS ABENDING.

2011-06-06 17:14:47  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (Administrator): edit params rtab02.

---接受进程的配置文件

REPLICAT rtab02

SETENV (NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK)

USERID hydee@ORCL,password hydeepwd#ta

DDL INCLUDE ALL

DDLERROR DEFAULT IGNORE RETRYOP

HANDLECOLLISIONS

ASSUMETARGETDEFS

CHECKSEQUENCEVALUE

DISCARDFILE ./dirrpt/rtab02.dsc,PURGE

MAP hydee.u_ware, TARGET hydee.u_ware;

MAP hydee.u_ware_q, TARGET hydee.u_ware_q;

MAP hydee.u_ware_ext, TARGET hydee.u_ware_ext;

MAP hydee.u_ware_stall, TARGET hydee.u_ware_stall;

MAP hydee.u_ware_class, TARGET hydee.u_ware_class;

MAP hydee.c_class_group, TARGET hydee.c_class_group;

MAP hydee.c_class, TARGET hydee.c_class;

MAP hydee.c_whlprice_group, TARGET hydee.c_whlprice_group;

MAP hydee.u_ware_whlprice, TARGET hydee.u_ware_whlprice;

MAP hydee.u_store_i, TARGET hydee.u_store_i;

MAP hydee.u_store_c, TARGET hydee.u_store_c;

MAP hydee.u_store_m, TARGET hydee.u_store_m;

MAP hydee.u_store_bak, TARGET hydee.u_store_bak;

MAP hydee.C_USER, TARGET hydee.C_USER;

MAP hydee.C_USER_ORG, TARGET hydee.C_USER_ORG;

MAP hydee.C_USER_FUNC_EXT, TARGET hydee.C_USER_FUNC_EXT;

MAP hydee.C_USER_DEPT, TARGET hydee.C_USER_DEPT;

MAP hydee.C_USER_FUNC, TARGET hydee.C_USER_FUNC;

MAP hydee.U_CUSTOM, TARGET hydee.U_CUSTOM;

MAP hydee.U_CUSTOM_DEPT, TARGET hydee.U_CUSTOM_DEPT;

MAP hydee.U_CUSTOM_RANGE, TARGET hydee.U_CUSTOM_RANGE;

MAP hydee.u_custom_contact, TARGET hydee.u_custom_contact;

MAP hydee.U_CUSTOM_SUBITEM, TARGET hydee.U_CUSTOM_SUBITEM;

MAP hydee.c_custom_class, TARGET hydee.c_custom_class;

MAP hydee.c_custom_class_group, TARGET hydee.c_custom_class_group;

MAP hydee.c_custom_class_list, TARGET hydee.c_custom_class_list;

---抽取进程的

EXTRACT tabdml02

USERID hydee@LISTENER_ORCL,password hydeepwd#ta

EXTTRAIL ./dirdat/bb

DDL

TABLE hydee.u_ware;

TABLE hydee.u_ware_q;

TABLE hydee.u_ware_ext;

TABLE hydee.u_ware_stall;

TABLE hydee.u_ware_class;

TABLE hydee.c_class_group;

TABLE hydee.c_class;

TABLE hydee.c_whlprice_group;

TABLE hydee.u_ware_whlprice;

TABLE hydee.u_store_i;

TABLE hydee.u_store_c;

TABLE hydee.u_store_m;

TABLE hydee.u_store_bak;

TABLE hydee.C_USER;

TABLE hydee.C_USER_ORG;

TABLE hydee.C_USER_FUNC_EXT;

TABLE hydee.C_USER_DEPT;

TABLE hydee.C_USER_FUNC;

TABLE hydee.U_CUSTOM;

TABLE hydee.U_CUSTOM_DEPT;

TABLE hydee.U_CUSTOM_RANGE;

TABLE hydee.u_custom_contact;

TABLE hydee.U_CUSTOM_SUBITEM;

TABLE hydee.c_custom_class;

TABLE hydee.c_custom_class_group;

TABLE hydee.c_custom_class_list;

---投递进程的

EXTRACT tabdml02

USERID hydee@LISTENER_ORCL,password hydeepwd#ta

EXTTRAIL ./dirdat/bb

DDL

TABLE hydee.u_ware;

TABLE hydee.u_ware_q;

TABLE hydee.u_ware_ext;

TABLE hydee.u_ware_stall;

TABLE hydee.u_ware_class;

TABLE hydee.c_class_group;

TABLE hydee.c_class;

TABLE hydee.c_whlprice_group;

TABLE hydee.u_ware_whlprice;

TABLE hydee.u_store_i;

TABLE hydee.u_store_c;

TABLE hydee.u_store_m;

TABLE hydee.u_store_bak;

TABLE hydee.C_USER;

TABLE hydee.C_USER_ORG;

TABLE hydee.C_USER_FUNC_EXT;

TABLE hydee.C_USER_DEPT;

TABLE hydee.C_USER_FUNC;

TABLE hydee.U_CUSTOM;

TABLE hydee.U_CUSTOM_DEPT;

TABLE hydee.U_CUSTOM_RANGE;

TABLE hydee.u_custom_contact;

TABLE hydee.U_CUSTOM_SUBITEM;

TABLE hydee.c_custom_class;

TABLE hydee.c_custom_class_group;

TABLE hydee.c_custom_class_list;

上面是错误 各位大神帮看看 我都困扰了一天了 还没有解决呀

目标端的接受进程就是报错

[本帖最后由 wkc168 于 2011-6-6 17:25 编辑]