OGG Integrated Extract ORA-00001: unique constraint (SYSTEM.LOGMNRC_INDCOL_GG_PK) violated (Doc ID 2375737.1)

Last updated on JUNE 05, 2019

Applies to:

Symptoms

                 Oracle GoldenGate Capture for Oracle
 Version 12.2.0.1.170221 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_170123.1033_FBO
   Linux, x64, 64bit (optimized), Oracle 12c on Jan 23 2017 23:31:40
 

OGG IE abends with below error

2017-11-06 10:55:19  ERROR   OGG-02077  Extract encountered a read error in the asynchronous reader thread and is abending: Error code 1, error message: ORA-00001: unique constraint (.) violated.

Trace shows following messages

Trace file /ficdbp1/oracle/diag/rdbms/trace/ficdbcp11_ms01_12951.trc
krvxats(builder): Attaching to SessionId 1
krvxrgp: process 815, role builder
...
*** 2017-11-06 13:30:30.810
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-00001: unique constraint (SYSTEM.LOGMNRC_INDCOL_GG_PK) violated
----- Current SQL Statement for this session (sql_id=5snjz9078ndan) -----
INSERT INTO SYSTEM.LOGMNRC_INDCOL_GG ( LOGMNR_UID, OBJ#, INTCOL#, POS#, SPARE1, COMMIT_SCN ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
----- PL/SQL Stack -----

Cause

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