1 Reply Latest reply: Jul 21, 2014 7:16 AM by drbiloukos RSS

    Help with exception table.

    drbiloukos

      Hello people,

      The below configuration I have used it many times in my REPLICAT processes.

       

      However I added it in a REPLICA where I had some unique constraint violation in order to continue replication, but I cannot make it write to the exception table TABLE_T_GG_EXC. Please for your help.

       

       

      GGSCI (server1) 57> view param REP1

       

       

      REPLICAT REP1

      SETENV (NLS_LANG="AMERICAN_AMERICA.UTF8")

      --USERID admin@DB1, PASSWORD xxxxxxxxxxxxxxxxxxxxxxxxxx, ENCRYPTKEY DEFAULT

      USERID admin@DB1, PASSWORD xxxxxxxxxxxxxxxxxxxxxxxxxx, ENCRYPTKEY DEFAULT

      ASSUMETARGETDEFS

      CHECKPOINTSECS 30

      GROUPTRANSOPS 2000

      --EXTTRAIL /GG/dirdat/tmp/pg

      DISCARDFILE ./dirrpt/disca.dsc, MEGABYTES 100, APPEND

      DISCARDROLLOVER AT 06:30 ON SUNDAY

      DDL INCLUDE MAPPED &

         EXCLUDE INSTR 'drop partition' &

         EXCLUDE INSTR 'merge partitions' &

         EXCLUDE INSTR 'rename partition' &

         EXCLUDE OBJTYPE 'TRIGGER' &

         EXCLUDE OBJTYPE 'INDEX' &

         EXCLUDE OBJTYPE 'CONSTRAINT' &

         EXCLUDE INSTRWORDS 'ALTER TABLE "DROP"' &

         EXCLUDE INSTR 'DROP TABLE'

      DDLERROR DEFAULT IGNORE RETRYOP

      DDLSUBST 'PIN00' WITH 'REP_TBL' INCLUDE INSTR 'partition'

      --include dirprm/HB_RBRM.inc

      BATCHSQL BATCHTRANSOPS 2000

      REPERROR (-1403 , IGNORE)

       

       

      REPERROR (-0001 , EXCEPTION)

      MAP SCH1.TABLE_T, TARGET REP.TABLE_T;

      INSERTALLRECORDS

      MAP SCH1.TABLE_T, TARGET REP.TABLE_T_GG_EXC,

      EXCEPTIONSONLY,

      COLMAP (USEDEFAULTS, optype = @GETENV ("lasterr", "optype"),

      dberr = @GETENV ("lasterr", "dberrnum"),

      dberrmsg = @GETENV ("lasterr", "dberrmsg"));

      REPERROR (-0001 , ABEND)