Forum Stats

  • 3,770,099 Users
  • 2,253,066 Discussions
  • 7,875,313 Comments

Discussions

GetBeforeCols extract parameter seems to be not capturing before image of specified columns.

User_JBMMB
User_JBMMB Member Posts: 7 Red Ribbon

I am using Oracle GoldenGate 19.1.0.0.4 to do replication between 19c and 11.2.0.4 database. Replication is happening fine between two databases but when I use GetBeforeCols extract parameter to capture before image of couple of columns of a certain table then replicate process abends on target system with below error.


OGG-01920 Oracle GoldenGate Delivery for Oracle, reprac.prm: Missing COMPARECOLS column "SAL" in before image, while mapping to target table "SCOTT.EMP". Add the column to GETBEFORECOLS.


where as on target replicat file column is present in ComapreCols

I am also share my source extract and traget replicat parameter files below.


=============

SOURCE

============


EXTRACT exrac

USERID c##[email protected], password ggs_owner

EXTTRAIL /u04/app/oracle/ogg/dirdat/rac/ex

TRANLOGOPTIONS EXCLUDEUSER rac_pdb1.c##ggs_owner

TRANLOGOPTIONS INTEGRATEDPARAMS (_LOGMINER_READ_BUFFERS 256, PARALLELISM 2)

LOGALLSUPCOLS

UPDATERECORDFORMAT FULL

SOURCECATALOG rac_pdb1

DDL INCLUDE ALL, EXCLUDE OBJTYPE 'SNAPSHOT', EXCLUDE OBJTYPE 'SNAPSHOT LOG'

SEQUENCE SCOTT.STUDENTS_ROLLNO_SEQ;

SEQUENCE SCOTT.SRNO_SEQ;

TABLE SCOTT.emp, GETBEFORECOLS(ON UPDATE KEYINCLUDING (SAL,COMM));

TABLE SCOTT.dept;

TABLE SCOTT.promotion;


==============

TARGET

==============


REPLICAT reprac

USERID [email protected], password ggs_owner

DBOPTIONS INTEGRATEDPARAMS(COMMIT_SERIALIZATION FULL, _ARRAY_OPERATION N, PARALLELISM 2, MAX_PARALLELISM 2) 

DBOPTIONS SUPPRESSTRIGGERS

--BATCHSQL

ASSUMETARGETDEFS

DISCARDFILE /u02/oracle/ogg/discards_reprac.dsc, PURGE

DBOPTIONS SETTAG 0123


MAP rac_pdb1.scott.emp, TARGET scott.emp, COMPARECOLS (ON UPDATE KEYINCLUDING (SAL,COMM));


MAP rac_pdb1.scott.dept, TARGET scott.dept;


MAP rac_pdb1.scott.promotion, TARGET scott.promotion;