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').