OGG Integrated Extract ORA-00001: unique constraint (SYSTEM.LOGMNRC_INDCOL_GG_PK) violated
(Doc ID 2375737.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
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 -----
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 |