Goldengate OGG-01296 Error mapping from OGG-01154

Hi,

You can get frequently ” OGG-01296 Error mapping from ” error from Goldengate.

 

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.

 

 

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

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *