Replicat abends with ORA-00001: unique constraint (SYS.I_XSTREAM_REPERROR_HANDLER1)
(Doc ID 2746740.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation 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 |