Please check ggerror.log file :-- UNIQUE Constraint Violation issue in Oracle Golden Gate
WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, st3_rep1.prm: OCI Error ORA-00001: unique constraint (NIM.SYS_C0074582) violated (status = 1), SQL <INSERT INTO "NIM"."MCWARNING" ("ACTIVITYDEFINITIONID","WARNINGMESSAGE") VALUES (:a0,:a1)>.
WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, st3_rep1.prm:
Aborted grouped transaction on 'NIM.MCWARNING', Database error 1 (ORA-00001: unique constraint (NIM.SYS_C0074582) violated).
To FIX:
Step 1:
edit param st3_rep1
Step2 :
Uncomment the HANDLECOLLISIONS parameter then restart. To uncomment take out the two dashes in front of the parameter.
Once the lag is dimished, again comment this out and restart the thread i.e. restart the process.
WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, st3_rep1.prm: OCI Error ORA-00001: unique constraint (NIM.SYS_C0074582) violated (status = 1), SQL <INSERT INTO "NIM"."MCWARNING" ("ACTIVITYDEFINITIONID","WARNINGMESSAGE") VALUES (:a0,:a1)>.
WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, st3_rep1.prm:
Aborted grouped transaction on 'NIM.MCWARNING', Database error 1 (ORA-00001: unique constraint (NIM.SYS_C0074582) violated).
To FIX:
Step 1:
edit param st3_rep1
Step2 :
Uncomment the HANDLECOLLISIONS parameter then restart. To uncomment take out the two dashes in front of the parameter.
Once the lag is dimished, again comment this out and restart the thread i.e. restart the process.
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Golden Gate.kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Oracle Golden Gate. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Free Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com