Integrated Replicat Abends With ORA-00001: unique constraint (SYS.I_XSTREAM_REPERROR_HANDLER1) violated
(Doc ID 2746737.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
Integrated replicat abends with the error :
Source Context :
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
2021-01-22 10:56:50 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
).
2021-01-22 10:56:56 ERROR OGG-01668 PROCESS ABENDING.
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
2021-01-22 10:56:50 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
).
2021-01-22 10:56:56 ERROR OGG-01668 PROCESS ABENDING.
In DB trace file :
< It's failed at the SQL Statement : MERGE INTO ... USING DUAL ON ... >
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=4, mask=0x0)
----- 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
----- 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 |