Site icon IT Tutorial

OGG-01296 Error mapping from OGG-01154 SQL error in Goldengate

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

 

Do you want to learn Oracle Goldengate, then read the following articles.

Oracle Goldengate Tutorials for Beginners

Exit mobile version