REPERROR (-1, DISCARD)

Posted by Roshan on Oct 27, 2019; 12:24pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/REPERROR-1-DISCARD-tp7808.html

Oracle DB 12.1.0.2
Solaris 6.4

Hello Erman,

is it ok if I add the following parameter permanently

REPERROR (-1, DISCARD)

in my parameter file if ever I get the error below?

OCI Error ORA-00001: unique constraint (CBSOGG.WF_TODOITEM_WID_$PK) violated (status = 1), SQL <INSERT INTO "CBSOGG"."WF_TODOITEM" ("WORK_ID_N","WRKAGENT_ID_N","NOTES_V","EXPIRY_TIME_D","STATUS_V","ASSIGNMENT_DT_D","WORK_COMPLETION_DT_D","EVENT_TYPE_N","EVENT_REFNO_V","USER_ID_N","TIMES_DIFFERED_N","ACTIVITY_NAME_V","ASSIGNMENT_DT_D_1") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12)>
Operation failed at seqno 686 rba 182835455
Discarding record on action DISCARD on error 1
Problem replicating CLM_TT.WF_TODOITEM to CBSOGG.WF_TODOITEM.
Mapping problem with insert record (target format) SCN:29.29.51717...

or is it necessary to comment after replicat is resuming normally?

Regards,

Roshan