Oracle Database 12.1.0.2(source+target)
Oracle Golden Gate 18.0
Hi,
replicat process has abended with error below for a few tables. Replication was working fine previously.
2019-10-25T19:09:31.758+0400 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Aborted grouped transaction on CBSOGG.WF_TODOITEM, Database error 1 (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)>).
2019-10-25T19:09:31.767+0400 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Repositioning to rba 182835455 in seqno 686.
2019-10-25T19:09:31.771+0400 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, reploggt.prm: SQL error 1 mapping CLM_TT.WF_TODOITEM to CBSOGG.WF_TODOITEM 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)>.
2019-10-25T19:09:31.773+0400 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error mapping from CLM_TT.WF_TODOITEM to CBSOGG.WF_TODOITEM.
2019-10-25T19:09:35.621+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /ogg/ora12c/dirdat/cd000000686, current RBA 182,835,455, 0 records, m_file_seqno = 686, m_file_rba = 182,835,821.
2019-10-25T19:09:35.638+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.
2019-10-25T19:25:36.046+0400 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, reploggt.prm: SQL error 1 mapping CBS_CUST.FXL_RATED_CDRS to CBSOGG.FXL_RATED_CDRS OCI Error ORA-00001: unique constraint (CBSOGG.FXL_RATED_CDRS$UI) violated (status = 1), SQL <INSERT INTO "CBSOGG"."FXL_RATED_CDRS" ("TYPE_OF_CALL_V","SWITCH_CALL_TYPE_V","RECORD_TYPE_V","PROMOTION_CODE_V","IN_OUT_V","TARF_TYPE_V","CALL_CHRG_TYPE_V","FAX_DATA_VOICE_V","CALC_ON_V","PERCENTAGE_VAL_N","INTERIM_CALL_INDICATOR_V","CALL_SEQ_NUM_N","ACCOUNT_LINK_CODE_N","CHRONO_NUM_N","CALL_DATE_DT","CALL_DURATION_N","SUMMARY_SEQ_NUM_N","ARTICLE_CODE_V","NETWORK_ELEMENT_V","TELEPHONE_NUMBER_V","MSC_NUM_V","IN_TRUNK_V","OUT_TRUNK_V","CALLED_CALLING_NUM_V","ACTUAL_NUM_IF_FRWD_V","DIALED_DIGIT_V","ICSRV_PROVIDER_CODE_V","IC_RATE_ZONE_V","IC_CONCT_ZONE_V","COUNTRY_CODE_V","STATE_CODE_V","CITY_CODE_V","TARIFF_CODE_V","RATING_FILE_ID_N","DAY_CODE_V","TIME_BAND_V","IC_RATE_PLAN_CODE_N","IC_VOICE_FRML_N","IC_VOICE_UNIT_RATE_N","IC_UNITS_N","IC_VOICE_AMT_N","IC_TAX_CODE_V","IC_TAX_AMT1_N","IC_TAX_AMT2_N","IC_TAX_AMT3_N","ORIG_LOCATION_ZONE_CODE_V","TERM_LOCATION_ZONE_CODE_V","RATING_ZONE_CODE_V","CALL_TYPE_FLAG_V","OPERATOR_ASST_CALL_FRML_N","OPERATOR_ASST_AMT_N","AIRTM_RATE_PLAN_CODE_N","AIRTM_FRML_N","AIRTM_VOICE_UNIT_RATE_N","AIRTM_VOICE_UNITS_N","AIRTM_AMT_N","AIRTM_TAX_CODE_V","AIRTM_TAX_AMT1_N","AIRTM_TAX_AMT2_N","AIRTM_TAX_AMT3_N","RATE_ON_V","DISC_TYPE_V","DISC_UNITS_N","DESTINATION_TYPE_V","DEST_SERVICE_TYPE_CODE_V","CHARGED_DURATION_N","DISC_QTM_TYPE_V","DISCOUNTED_VALUE_N","DISCOUNTED_AMOUNT_N","OUTPUT_DISC_ARTICLE_V","CHARGE_BEFORE_DISC_N","PROCESSED_DATE_D","SUB_SERVICE_CODE_V","BILL_CYCL_FULL_CODE_N","EXTN_NUMBER_V","ACCOUNT_CODE_N","OMR_N","CMR_N","INFLATION_FLAG","INFLATED_AMOUNT_N","OMR_DATE_D","DISC_CODE_V","EXTERNAL_SWITCH_CODE_V","SWITCH_CODE_V","INTERCONNECTION_TYPE_V","OPERATOR_AUTOMATIC_V","USAGE_RECORD_V","CALLING_NO_AREA_CODE_V","CALLED_NO_AREA_CODE_V","PAYING_THIRD_PARTY_NO_V","SWITCH_SERVICE_CODE_V","SEQ_NUM_V","TAXABLE_FLAG_N","MSG_TYPE_N") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:.
2019-10-25T19:25:36.046+0400 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Error mapping from CBS_CUST.FXL_RATED_CDRS to CBSOGG.FXL_RATED_CDRS.
2019-10-25T19:25:40.719+0400 INFO OGG-02333 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Reading /ogg/ora12c/dirdat/cd000000686, current RBA 182,839,650, 0 records, m_file_seqno = 686, m_file_rba = 182,840,873.
2019-10-25T19:25:40.728+0400 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, reploggt.prm: PROCESS ABENDING.
Is it ok if I use REPERROR?
(Doc ID 2074852.1)
Regards,
Joe