Hi,
You can get frequently ” OGG-01296 Error mapping from OGG-01154 SQL error ” error from Goldengate.
OGG-01296 Error mapping from
Goldengate replicat is abended with ” OGG-01296 Error mapping from ” error like below.
GGSCI (MehmetSalih) 1> info REPDEV REPLICAT REPDEV Last Started 2019-02-28 10:03 Status ABENDED Checkpoint Lag 00:00:03 (updated 03:11:14 ago) Log Read Checkpoint File /data/Goldengate/dirdat/rt059801 2019-03-26 14:15:20.257167 RBA 11016012
I have checked replicat report file with following command.
GGSCI (MehmetSalih) 5> view report REPDEV
2019-03-26 17:26:54 WARNING OGG-00869 OCI Error ORA-20000:
ORA-06512: at "DEVECI.GG_TEST_TABLE", line 9
ORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL <INSERT INTO "DEVECI"."GG_TEST_TABLE2" ("ACCOUNTID","CREATETSTAMP","C
","EXTERNALID","BILLNUMBER","NAME","IPID","HEALTHPLANID","HEA>.
2019-03-26 17:26:54 WARNING OGG-01004 Aborted grouped transaction on 'DEVECI.GG_TEST_TABLE2', Database error 20000 (OCI Error ORA-20000:
***
ORA-06512: at "DEVECI.GG_TEST_TABLE", line 9
ORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL <INSERT INTO "DEVECI"."GG_TEST_TABLE2" ("ACCOUNTID","CREATETSTAMP","C
","EXTERNALID","BILLNUMBER","NAME","IPID","HEALTHPLANID","HEA>).
2019-03-26 17:26:54 WARNING OGG-01003 Repositioning to rba 11016012 in seqno 59801.
2019-03-26 17:26:54 WARNING OGG-01154 SQL error 20000 mapping DEVECI.GG_TEST_TABLE2 to DEVECI.GG_TEST_TABLE2 OCI Error ORA-20000:
ORA-06512: at "DEVECI.GG_TEST_TABLE", line 9
ORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL <INSERT INTO "DEVECI"."GG_TEST_TABLE2" ("ACCOUNTID","CREATETSTAMP","C
","EXTERNALID","BILLNUMBER","NAME","IPID","HEALTHPLANID","HEA>.
2019-03-26 17:26:54 WARNING OGG-01003 Repositioning to rba 11016012 in seqno 59801.
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/angorant/view_storage/angorant_ogg_12978807_x64/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [take_rep_err_action]
SourceLine : [16134]
ThreadBacktrace : [8] elements
: [/data1/Goldengate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f0516]]
: [/data1/Goldengate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e6fe2]]
: [/data1/Goldengate/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessag
: [/data1/Goldengate/replicat [0x83178f]]
: [/data1/Goldengate/replicat [0x90e282]]
: [/data1/Goldengate/replicat(main+0x84b) [0x507deb]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x31f261d9c4]]
: [/data1/Goldengate/replicat(__gxx_personality_v0+0x1da) [0x4e43ca]]
2019-03-26 17:26:54 ERROR OGG-01296 Error mapping from DEVECI.GG_TEST_TABLE2 to DEVECI.GG_TEST_TABLE2.
OGG-01154 SQL error
When you get ” OGG-01296 Error mapping from ” error, firstly check replicat table constraints and triggers.
You can also see that replicat report file says ” ORA-04088: error during execution of trigger ” error.
So when I check related table triggers and constraints, problem is occured because of trigger.
I have disabled triggers with following command.
alter trigger TRIGGER_NAME disable;
You can disabled all triggers with following command.
-- trigger enable / disable ALTER TRIGGER trigger_name ENABLE; ALTER TRIGGER trigger_name DISABLE;
-- enable / disable all triggers for a specific table ALTER TABLE table_name ENABLE ALL TRIGGERS; ALTER TABLE table_name DISABLE ALL TRIGGERS;
After disabling triggers I have started replicat and it is run and try to reduce lag.
GGSCI (MehmetSalih) 7> start REPDEV Sending START request to MANAGER ... REPLICAT REPDEV starting REPLICAT REP9 is already running. GGSCI (MehmetSalih) 8> info REPDEV REPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING Checkpoint Lag 00:00:03 (updated 03:14:13 ago) Log Read Checkpoint File /data/Goldengate/dirdat/rt059801 2019-03-26 14:15:20.257167 RBA 11016012 GGSCI (MehmetSalih) 35> ! info REPDEV REPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING Checkpoint Lag 02:49:31 (updated 00:00:00 ago) Log Read Checkpoint File /data/Goldengate/dirdat/rt059802 2019-03-26 14:52:53.259983 RBA 42593328 GGSCI (MehmetSalih) 36> ! info REPDEV REPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING Checkpoint Lag 02:49:24 (updated 00:00:00 ago) Log Read Checkpoint File /data/Goldengate/dirdat/rt059802 2019-03-26 14:53:03.259848 RBA 42958057