Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle GoldenGate for Big Data - UPDATEDELETES not working

Douglas KeiMay 22 2017 — edited May 31 2017

I tried to use UPDATEDELETES on replicat and the UPDATE operation (converted from DELETE) just not getting fired to the Java Adapter layer (verify by enabling TRACE level logging). Checked with logdump that the DELETE operation successfully routed to the trail file, and the full before image has been logged. The replicat process also has gone through that RBA.

Anyone did tried successfully on OGG for Big Data / Java Adapter? Thanks!

Configuration details as below:

Extract configuration (Oracle XE)

Extract ej

SETENV (ORACLE_SID='xe')

UserIdAlias ogg_user

Exttrail ./dirdat/ij

LOGALLSUPCOLS

Table OGGSRC.T2;

(Remarks: LOGALLSUPCOLS takes precedence over NOCOMPRESSDELTES)

Replicat configuration (MongoDB)

REPLICAT rj

TARGETDB LIBFILE libggjava.so SET property=dirprm/mongo.props

REPORTCOUNT EVERY 60 MINUTES, RATE

GROUPTRANSOPS 1000

ALLOWDUPTARGETMAP

ALLOWNOOPUPDATES

IGNOREDELETES

MAP OGGSRC.T2, TARGET OGGTRG.T2;

IGNOREINSERTS

IGNOREUPDATES

GETDELETES

UPDATEDELETES

MAP OGGSRC.T2, TARGET OGGTRG.T2, COLMAP(USEDEFAULTS, "delInd" = 'Y');

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2017
Added on May 22 2017
8 comments
1,066 views