mssql-->ogg-->oracle

mssql 2008-->ogg11.1-->oracle11.2

问题：

2016-05-17 11:01:34  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repma.prm:  REPLICAT REPMA starting.
2016-05-17 11:01:34  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, repma.prm:  REPLICAT REPMA started.
2016-05-17 11:01:35  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repma.prm:  Aborted grouped transaction on 'test9.table1', Database error 1403 ().
2016-05-17 11:01:35  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repma.prm:  Repositioning to rba 963 in seqno 0.
2016-05-17 11:01:36  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repma.prm:  SQL error 1403 mapping test0.table1 to test9.table1.
2016-05-17 11:01:36  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repma.prm:  Repositioning to rba 963 in seqno 0.
2016-05-17 11:01:36  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repma.prm:  Error mapping from test0.table1 to test9.table1.
2016-05-17 11:01:36  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repma.prm:  PROCESS ABENDING.
  
2016-05-18 09:22:13  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repmb.prm:  PROCESS ABENDING.
2016-05-18 09:22:14  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repma.prm:  OCI Error ORA-01400: cannot insert NULL into ("test9"."TESTDEPTCIRCULATION"."CATEGORYITEMCODE") (status = 1400), SQL <INSERT INTO "test9"."TESTDEPTCIRCULATION" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","CIRCULATIONMODECODE") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2016-05-18 09:22:14  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repma.prm:  Aborted grouped transaction on '9960.TBDEPTCIRCULATION', Database error 1400 (OCI Error ORA-01400: cannot insert NULL into ("test9"."TESTDEPTCIRCULATION"."CATEGORYITEMCODE") (status = 1400), SQL <INSERT INTO "test9"."TESTDEPTCIRCULATION" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","CIRCULATIONMODECODE") VALUES (:a0,:a1,:a2,:a3,:a4)>).
2016-05-18 09:22:14  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repma.prm:  Repositioning to rba 1127 in seqno 1.
2016-05-18 09:22:14  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repma.prm:  SQL error 1400 mapping 000.TBDEPTCIRCULATION to 9960.TBDEPTCIRCULATION OCI Error ORA-01400: cannot insert NULL into ("test9"."TESTDEPTCIRCULATION"."CATEGORYITEMCODE") (status = 1400), SQL <INSERT INTO "test9"."TESTDEPTCIRCULATION" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","CIRCULATIONMODECODE") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2016-05-18 09:22:14  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repma.prm:  Repositioning to rba 99797 in seqno 1.
2016-05-18 09:22:14  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repma.prm:  Error mapping from 000.TBDEPTCIRCULATION to 9960.TBDEPTCIRCULATION.
 
2016-05-18 09:25:27  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repma.prm:  OCI Error ORA-01400: cannot insert NULL into ("test9"."TESTDEPTWORKSTATE"."CATEGORYITEMCODE") (status = 1400), SQL <INSERT INTO "test9"."TESTDEPTWORKSTATE" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","WORKSTATECODE","TEMPBEGINDATE","TEMPENDDATE","TEMPWORKSTATECODE","DEPTREMARK") VALUES (:a0,:a1,:a2,:a3,:a4,:>.
2016-05-18 09:25:27  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repma.prm:  Aborted grouped transaction on '9960.TBDEPTWORKSTATE', Database error 1400 (OCI Error ORA-01400: cannot insert NULL into ("test9"."TESTDEPTWORKSTATE"."CATEGORYITEMCODE") (status = 1400), SQL <INSERT INTO "test9"."TESTDEPTWORKSTATE" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","WORKSTATECODE","TEMPBEGINDATE","TEMPENDDATE","TEMPWORKSTATECODE","DEPTREMARK") VALUES (:a0,:a1,:a2,:a3,:a4,:>).

解决：

MAP test0.tb1, TARGET test9.tb2, KEYCOLS (xx1, ed, bd); 

map test0.dd, target test9.adf,colmap (usedefaults, DEPT=0);

NODYNSQL
SHOWSYNTAX
NOBINARYCHARS

@IF (@COLTEST (CATEGORYITEMCODE, NULL), @COLSTAT(' '), CATEGORYITEMCODE)
map test0.dd, target test9.dd, COLMAP (CATEGORYITEMCODE=' ');
MAP TEST.T54 TARGET TEST.T55, COLMAP (col1=c1, col3=c2, col4=c3, col2=@CASE(c4,"CAR","1car1",c4));
 

INSERT INTO "test9"."dd" ("GOODSCODE","DEPTTYPE","CATEGORYITEMCODE","DEPTCODE","CIRCULATIONMODECODE")
VALUES ('223975','1','','0000','0080').