Handling Errors and Conflicts
Hello,
In my understanding there are 3 ways of handling errors/conflicts:
1 - dont do anything. Let replicat process abend and log the error in ggserr.log and report file. To resolve, correct the values or skip the dml and resume.
2 - configure reperror with discard or exceptions and allow the process to continue. Later, manually handle the dml or leave it as skipped.
3 - put in-built CDR and custom-built conflict resolution in place which is like auto-handling (for e.g. if ora-1403 no data found is encountered then convert to an insert or for unique constraint violation, convert to update).