GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

replicat is issuing "transaction rolled back" warning messages in report file

edited Nov 27, 2017 4:01AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered

Source is an 'IBM for i on POWER' legacy DDS defined file with multiple members, but only one primary key. 

My Extract mapping looks like:  TABLE INPRDDTA2/INJLIRP(*ALL);

My Pump mapping looks like:  TABLE INPRDDTA2/INJLIRP(*ALL), TARGET INPRDDTA2/INJLIRP(*ALL);

My Replicat mapping looks like: 

MAP INPRDDTA2/INJLIRP(*ALL), TARGET INA400_LANDING.INJLIRP,

KEYCOLS (JLCMPY, JLAWH5, JLDEPT, JLVEND, JLSUFF, JLITEM) ,

COLMAP (USEDEFAULTS,

JLYTD_DOLLAR = JLYTD$ ,

JLADDD_JLADDT_ISO = ~TO_ISO_TIME (JLADDT, ~TO_ISO_DATE(JLADDD)),

SOURCE_MEMBER_NAME = @STRSUB(@STRSUB(@STREXT(@GETENV ('GGHEADER', 'TABLENAME'), 19,28),')',''),'(',''));

On the target we added the 'SOURCE_MEMBER_NAME' column to help make the data unique.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center