Skip to Main Content

GGS_EXCEPTIONS unique constraint

user10126973Sep 23 2022

HI All,
I am trying to implement exception handing into the separate table but it not giving complete info on the unique constraint, it's just giving like insert statement followed by bind variables values this column DBERRMSG, the size of the column is varaahar2(4000)
I am seeing the length of DBERRMSG 999, somehow it's trimming out, and tried with DBERRMSG as CLOB data type still trimming out,
Please share your thoughts on how to get the whole info of discarded file info exception table?
the below my replicate info.
REPLICAT r_rep
USERID ogg, PASSWORD ogg
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/product/gg/dirdat/r_rep.dsc, APPEND
REPERROR (DEFAULT, EXCEPTION)
MAP HR.COUNTRIES, TARGET HR.COUNTRIES;
map hr.jobs, target hr.jobs;

-- new exception handler
MACRO #exception_handler
BEGIN
-- Use the same Golden Gate Exceptions Table for all exception records
, TARGET OGG.GGS_EXCEPTIONS
, COLMAP ( rep_name = @GETENV('GGENVIRONMENT', 'GROUPNAME')
, TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME')
, ERRNO = @GETENV ('LASTERR', 'DBERRNUM')
, DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG')
, OPTYPE = @GETENV ('LASTERR', 'OPTYPE')
, ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE')
, LOGRBA = @GETENV ('GGHEADER', 'LOGRBA')
, LOGPOSITION = @GETENV ('GGHEADER', 'LOGPOSITION')
, COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')
, GGS_FILENAME = @GETENV('GGFILEHEADER', 'FILENAME')
, CDRFAIL = @GETENV('DELTASTATS','CDR_RESOLUTIONS_FAILED')
, CDRSUC = @GETENV('DELTASTATS','CDR_RESOLUTIONS_SUCCEEDED')
, CDRDETECT = @GETENV('DELTASTATS','CDR_CONFLICTS'))
, INSERTALLRECORDS
, EXCEPTIONSONLY;
END;
MAP HR.COUNTRIES #exception_handler();
map hr.jobs #exception_handler();

Comments
Post Details
Added on Sep 23 2022
1 comment
13 views