ERROR OGG-01920
edited Oct 5, 2015 10:01AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hello Experts.
I need help.
I getting the below error :
2013-06-06 08:39:49 ERROR OGG-01920 Oracle GoldenGate Delivery for Oracle, rbowem_b.prm: Missing COMPARECOLS column DT_ATZ_RST_SEN in before image, while mapping to target table NPTCADM.PTC_ETD. Add the column to GETBEFORECOLS.
2013-06-06 08:39:49 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rbowem_b.prm: PROCESS ABENDING.
I checked the configuration for NPTCADM.PTC_ETD table, and, is correct.
Below is resolution conflict on replicat.
MAP NPTCADM.PTC_ETD, TARGET NPTCADM.PTC_ETD &
, COMPARECOLS (ON UPDATE KEYINCLUDING (DT_ATZ_RST_SEN)) &
, RESOLVECONFLICT (UPDATEROWEXISTS, (mps_mais_recente, USEMAX (DT_ATZ_RST_SEN), COLS (DT_ATZ_RST_SEN)), (default, ignore));
0