golden_date_erroir

[Arsalan]

Hello Arslan

I configure oracle golden gate between oracle 11g and oracle 12  in bidirectional so

it was working for last 6 months, today i face below errore

please guide me why or when this error occured and what is the solution for next time to avoid error


Thanks a lot

2020-03-07 13:15:33  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Aborted grouped transaction on 'SIGTASAD.TAX_SUB_TRANS', Database error 1403 (OCI Error ORA-01403: no data found, SQL <DELETE /*+ RESTRICT_ALL_REF_CONS */ FROM "SIGTASAD"."TAX_SUB_TRANS"  WHERE "TAX_SUB_TRANS_NO" = :b0>).

[Arsalan]

see also below error


2020-03-07 13:15:33  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, REP2.prm:  Error mapping from SIGTASAD.TAX_SUB_TRANS to SIGTASAD.TAX_SUB_TRANS.
2020-03-07 13:15:33  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, REP2.prm:  PROCESS ABENDING.

[ErmanArslansOracleBlog]

First, verify that the table have primary and unique key. Ensure they are valid.
 select owner, constraint_name, constraint_type, status, validated from dba_constraints where owner='XXXXXXX' and TABLE_NAME = 'XXXXX';

[Arsalan]

Salam i have still error

and i checked no constraints is disables.

REPLICAT REP2
SETENV (ORACLE_SID= "ee")
SETENV (ORACLE_HOME = "C:\app\arsala\product\12.1.0\dbhome_1")
USERIDALIAS ogg
ASSUMETARGETDEFS
APPLYNOOPUPDATES
discardfile E:\FRA\OGGS\dirrpt\repl2.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER ON SUNDAY
GROUPTRANSOPS 2000
DBOPTIONS SUPPRESSTRIGGERS,DEFERREFCONST
MAP SIGTASAD.*,TARGET SIGTASAD.*;


NOTE: ON SOURCE AND TRAGET HAVE SAME PARAMETER

Source is 11g, and target is 12c DB

[ErmanArslansOracleBlog]

Did you enabled logging of supplemental redo data at a Database level?

[Arsalan]

SQL> SELECT supplemental_log_data_min "Minimum",
  2  supplemental_log_data_pk  "Primary key",
  3  supplemental_log_data_ui  "Unique Key",
  4  supplemental_log_data_fk  "Foregin Key",
  5  supplemental_log_data_all "All"
  6  FROM   v$database;

Minimum  Pri Uni For All
-------- --- --- --- ---
YES      YES YES YES YES

[ErmanArslansOracleBlog]

Okay. So the row to be deleted is not present in the target.
I don't know your environment. Is there anything that may cause this result?

For example : you have app1 and db1, and you have app2 and db2
suppose you have a bidirectional GG configuration between db1 <-> db2
So now suppose app2 delete a record in db2 and App1 deletes the same record in db1
Just after that, GG extracts from db1 and replicates to db2 and tries to do the same delete in db2.. Ofcourse it can not do that.. Because that record in db2 was already deleted by the relevant application (app2)

In such environments, we use the REPERROR parameter to control how Replicat responds to errors..

Please speak with the person who designed this GG configuration.
Please check how this row was deleted from the target..

Once you have the necessary information, update me..

There are also some specific cases like the following ..

A very specific case -> Replicat Abends with "OGG-01154 SQL error 1403 mapping" (Doc ID 1329189.1)