My Oracle Support Banner

Replicat abends with ORA-00001: unique constraint (SYS.I_XSTREAM_REPERROR_HANDLER1) (Doc ID 2746740.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Replicat process is abended with the error :

Source Context :
  SourceModule            : [ggdb.ora.ocicpp.err]
  SourceID                : [ggdbora/ocicpp/OCIErrorHandler.cpp]
  SourceMethod            : [dpiErr]
  SourceLine              : [121]

2021-01-22 08:56:44  ERROR   OGG-00664  OCI Error ORA (status = 1-ORA-00001: unique constraint (SYS.I_XSTREAM_REPERROR_HANDLER1) violated
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 803
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 2563
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 2523
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 794
ORA-06512: at line 1
).

 

In DB trace file :

----- Error Stack Dump -----
<error barrier> at 0xffffffff7ffede18 placed dbkda.c@296
ORA-00001: unique constraint (SYS.I_XSTREAM_REPERROR_HANDLER1) violated
<error barrier> at 0xffffffff7fff2b80 placed updexe.c@4637
----- Current SQL Statement for this session (sql_id=0j3ncrwvnxatc) -----
MERGE INTO XSTREAM$_REPERROR_HANDLER EH USING DUAL ON (EH.APPLY_NAME = :B6 AND EH.SCHEMA_NAME = :B5 AND EH.TABLE_NAME = :B4 AND EH.SOURCE_SCHEMA_NAME = :B3 
AND EH.SOURCE_TABLE_NAME = :B2 AND EH.ERROR_NUMBER = :B1 ) WHEN NOT MATCHED THEN INSERT (APPLY_NAME, SCHEMA_NAME, TABLE_NAME, SOURCE_SCHEMA_NAME,
SOURCE_TABLE_NAME, ERROR_NUMBER, METHOD, MAX_RETRIES, DELAY_MSECS, SET_BY) VALUES(:B6 , :B5 , :B4 , :B3 , :B2 , :B1 , :B9 , :B8 , :B7 , :B10 )
WHEN MATCHED THEN UPDATE SET METHOD = :B9 , MAX_RETRIES = :B8 , DELAY_MSECS = :B7
----- PL/SQL Stack ----- ----- PL/SQL Call Stack -----   object      line  object   handle    number  name 470e77398      2523  package body SYS.DBMS_APPLY_ADM_INTERNAL.SET_REPERROR_HANDLER 442664c98       794  package body SYS.DBMS_XSTREAM_GG_ADM.SET_REPERROR_HANDLER 465248870         1  anonymous block

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.