Replicat Doesn't Handle CDR Collision And Abends (Doc ID 1503789.1)

Last updated on MARCH 05, 2019

Applies to:

Symptoms

Replcat abends with below error, however it should not. Instead, it has to proceed for exception and continue.

2012-09-24 20:37:06 WARNING OGG-01431 Aborted grouped transaction on 'OWNER.TABLENAME_EXC', Mapping error.

2012-09-24 20:37:06 WARNING OGG-01003 Repositioning to rba 4616 in seqno 37.

2012-09-24 20:37:06 WARNING OGG-01151 Error mapping from OWNER.TABLENAME to OWNER.TABLENAME.

In parameter file you have mapping such as

REPERROR (DEFAULT, EXCEPTION)
REPERROR (DEFAULT2, ABEND)
REPERROR (-1,ABEND)
MAP OWNER.TABLENAME , TARGET OWNER.TABLENAME , COLMAP(USEDEFAULTS) , COMPARECOLS(ON UPDATE ALL),
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX(LAST_UPDATE_DATE))),
RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, DISCARD)),
 RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)),
RESOLVECONFLICT (INSERTROWEXISTS,  (DEFAULT, USEMIN(LAST_UPDATE_DATE)));

MAP OWNER.TABLENAME, TARGET OWNER.TABLENAME_EXC,
INSERTALLRECORDS,
EXCEPTIONSONLY,
SQLEXEC(<ID> <logical_name> , QUERY "select * from OWNER.TABLENAME where col1 = :p1 and col2 = :p2 and col3 = :p3", PARAMS (p1=col1,p2=col2,p3=col3)),
COLMAP (
<EXC_COL1> = @GETVAL(<logical_name>.COL1),
<EXC_COL2> = @GETVAL(<logical_name>.COL2),
<EXC_COL3> = @GETVAL(<logical_name>.COL3),
EXEC_TIMESTAMP = @GETENV ("GGHEADER", "COMMITTIMESTAMP"),
LOGPOSITION = @GETENV ("GGHEADER", "LOGPOSITION"),
LOGRBA = @GETENV ("GGHEADER", "LOGRBA"),
OPERATION_TYPE = @GETENV ("LASTERR", "OPTYPE"),
ERROR_NO = @GETENV ("LASTERR", "DBERRNUM"),
RECORD_IMAGE = @GETENV ("GGHEADER", "BEFOREAFTERINDICATOR"));

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.