Oracle Database 12.2.0
RHEL 7.4
Hello Team,
kindly note that I am getting error below whenever I am replicating table 'CB_SUBS_OFFER_DETAILS'.
Extract from discard file:
Oracle GoldenGate Delivery for Oracle process started, group REPLOGGT discard file opened: 2019-07-15 17:54:18.821785
Current time: 2019-07-16 09:51:09
Discarded record from action ABEND on error 1403
OCI Error ORA-01403: no data found, SQL <UPDATE "CBSOGG"."CB_SUBS_OFFER_DETAILS" x SET x."ACCOUNT_LINK_CODE_N" = :a27,x."OFFER_CODE_V" = :a28,x."START_DATE_D" = :a29,x."END_DATE_D" = :a30,x."CANCEL_DATE_D" = :a31,x."USER_CODE_N" = :a32,x."STATUS_OPTN_V" = :a33,x."REQUESTED_DATE_D" = :a34,x."SCHEME_REF_CODE_N" = :a35,x."FACILITY_REF_ID_V" = :a36,x."NARRATION_V" = :a37,x."TARIFF_FLAG_V" = :a38,x."MOVE_CHARGE_TO_ACC_V" = :a39,x."ORDER_REF_NO" = :a40,x."ADDNL_OFFER_FLG_V" = :a41,x."EXTENDED_COUNT_N" = :a42,x."EXTENSION_DATE_D" = :a43,x."LAST_EXTENDED_DATE_D" = :a44,x."QUANTITY_N" = :a45,x."LAST_MODIFIED_DATE_D" = :a46,x."ADDN_ATTR_V_1" = :a47,x."ADDN_ATTR_V_2" = :a48,x."TECH_ATRIBUTE_V" = :a49,x."EXPIRY_DATE_D" = :a50,x."SERIAL_NUM_V" = :a51,x."AUTO_RENEW_V" = :a52,x."CONTRACT_END_DT_D" = :a53 WHERE x."ACCOUNT_LINK_CODE_N" = :b0 AND x."OFFER_CODE_V" = :b1 AND x."START_DATE_D" = :b2 AND x."END_DATE_D" = :b3 AND x."CANCEL_DATE_D" is NULL AND x."USER_CODE_N" = :b5 AND x."STATUS_OPTN_V" = :b6 AND x."REQUESTED_DATE_
Aborting transaction on /u01/app/oracle/OGG/dirdat/cd beginning at seqno 89 rba 300,648,474
error at seqno 89 rba 300648474
Problem replicating CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS.
Record not found
Mapping problem with unified PK update record (target format) SCN:114.9.2452512...
*
ACCOUNT_LINK_CODE_N = 23479593
000000: 32 33 34 37 39 35 39 33 |23479593 |
OFFER_CODE_V = O162979
000000: 4f 31 36 32 39 37 39 |O162979 |
START_DATE_D = 2019-06-25 00:00:00.000000000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 30 30 3a 30 30 |2019-06-25 00:00|
000010: 3a 30 30 2e 30 30 30 30 30 30 30 30 30 20 49 6e |:00.000000000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
END_DATE_D = 2063-11-23 17:31:44.000000000 Indian/Mauritius
000000: 32 30 36 33 2d 31 31 2d 32 33 20 31 37 3a 33 31 |2063-11-23 17:31|
000010: 3a 34 34 2e 30 30 30 30 30 30 30 30 30 20 49 6e |:44.000000000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
CANCEL_DATE_D = NULL
USER_CODE_N = 345
000000: 33 34 35 |345 |
STATUS_OPTN_V = A
000000: 41 |A |
REQUESTED_DATE_D = 2019-06-25 14:21:06.222354000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2019-06-25 14:21|
000010: 3a 30 36 2e 32 32 32 33 35 34 30 30 30 20 49 6e |:06.222354000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
SCHEME_REF_CODE_N = 162979
000000: 31 36 32 39 37 39 |162979 |
FACILITY_REF_ID_V = 1
000000: 31 |1 |
NARRATION_V = NULL
TARIFF_FLAG_V = N
000000: 4e |N |
MOVE_CHARGE_TO_ACC_V = NULL
ORDER_REF_NO = 19190722
000000: 31 39 31 39 30 37 32 32 |19190722 |
ADDNL_OFFER_FLG_V = NULL
EXTENDED_COUNT_N = NULL
EXTENSION_DATE_D = NULL
LAST_EXTENDED_DATE_D = NULL
QUANTITY_N = 1
000000: 31 |1 |
LAST_MODIFIED_DATE_D = 2019-06-25 14:21:06.222354000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2019-06-25 14:21|
000010: 3a 30 36 2e 32 32 32 33 35 34 30 30 30 20 49 6e |:06.222354000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
ADDN_ATTR_V_1 = NULL
ADDN_ATTR_V_2 = NULL
TECH_ATRIBUTE_V = NULL
EXPIRY_DATE_D = NULL
SERIAL_NUM_V = NULL
AUTO_RENEW_V = NULL
CONTRACT_END_DT_D = 2020-06-25 14:21:06.000000000 Indian/Mauritius
000000: 32 30 32 30 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2020-06-25 14:21|
000010: 3a 30 36 2e 30 30 30 30 30 30 30 30 30 20 49 6e |:06.000000000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
ACCOUNT_LINK_CODE_N = 23479593
000000: 32 33 34 37 39 35 39 33 |23479593 |
OFFER_CODE_V = O162979
000000: 4f 31 36 32 39 37 39 |O162979 |
START_DATE_D = 2019-06-25 00:00:00.000000000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 30 30 3a 30 30 |2019-06-25 00:00|
000010: 3a 30 30 2e 30 30 30 30 30 30 30 30 30 20 49 6e |:00.000000000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
END_DATE_D = 2019-07-16 09:50:55.492694000 +04:00
000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 30 |2019-07-16 09:50|
000010: 3a 35 35 2e 34 39 32 36 39 34 30 30 30 20 2b 30 |:55.492694000 +0|
000020: 34 3a 30 30 |4:00 |
CANCEL_DATE_D = 2019-07-16 09:50:55.492694000 +04:00
000000: 32 30 31 39 2d 30 37 2d 31 36 20 30 39 3a 35 30 |2019-07-16 09:50|
000010: 3a 35 35 2e 34 39 32 36 39 34 30 30 30 20 2b 30 |:55.492694000 +0|
000020: 34 3a 30 30 |4:00 |
USER_CODE_N = 345
000000: 33 34 35 |345 |
STATUS_OPTN_V = V
000000: 56 |V |
REQUESTED_DATE_D = 2019-06-25 14:21:06.222354000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2019-06-25 14:21|
000010: 3a 30 36 2e 32 32 32 33 35 34 30 30 30 20 49 6e |:06.222354000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
SCHEME_REF_CODE_N = 162979
000000: 31 36 32 39 37 39 |162979 |
FACILITY_REF_ID_V = NULL
NARRATION_V = NULL
TARIFF_FLAG_V = N
000000: 4e |N |
MOVE_CHARGE_TO_ACC_V = NULL
ORDER_REF_NO = 19190722
000000: 31 39 31 39 30 37 32 32 |19190722 |
ADDNL_OFFER_FLG_V = NULL
EXTENDED_COUNT_N = NULL
EXTENSION_DATE_D = NULL
LAST_EXTENDED_DATE_D = NULL
QUANTITY_N = 1
000000: 31 |1 |
LAST_MODIFIED_DATE_D = 2019-06-25 14:21:06.222354000 Indian/Mauritius
000000: 32 30 31 39 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2019-06-25 14:21|
000010: 3a 30 36 2e 32 32 32 33 35 34 30 30 30 20 49 6e |:06.222354000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
ADDN_ATTR_V_1 = NULL
ADDN_ATTR_V_2 = NULL
TECH_ATRIBUTE_V = NULL
EXPIRY_DATE_D = NULL
SERIAL_NUM_V = NULL
AUTO_RENEW_V = NULL
CONTRACT_END_DT_D = 2020-06-25 14:21:06.000000000 Indian/Mauritius
000000: 32 30 32 30 2d 30 36 2d 32 35 20 31 34 3a 32 31 |2020-06-25 14:21|
000010: 3a 30 36 2e 30 30 30 30 30 30 30 30 30 20 49 6e |:06.000000000 In|
000020: 64 69 61 6e 2f 4d 61 75 72 69 74 69 75 73 |dian/Mauritius |
*
Process Abending : 2019-07-16 09:51:15
Extract from Report file:
From Table CBS_CORE.CB_SUBS_OFFER_DETAILS to CBSOGG.CB_SUBS_OFFER_DETAILS:
# inserts: 77
# updates: 82
# deletes: 0
# discards: 1
Kindly advise if the below parameters may solve the error
DYNAMICRESOLUTION - enables fast process startup when there are numerous tables specified in TABLE or MAP statements
WILDCARDRESOLVE IMMEDIATE - objects are processed at startup
Output for trandata for above table:
GGSCI (RH-DATWHSE-DEV.mtg.local as extractogg@cbs) 7> ADD TRANDATA CBS_CORE.CB_SUBS_OFFER_DETAILS ALLCOLS
2019-07-16 10:08:16 INFO OGG-06441 Unique key CB_SUBS_OFFER_DTL$1 for table CB_SUBS_OFFER_DETAILS cannot be used due to the inclusion of virtual columns, or user-defined datatypes, or extended long varchar columns, or function-based index columns.
2019-07-16 10:08:16 INFO OGG-15130 No key found for table CBS_CORE.CB_SUBS_OFFER_DETAILS. All viable columns will be logged.
2019-07-16 10:08:16 INFO OGG-15131 Logging of supplemental redo log data is already enabled for table CBS_CORE.CB_SUBS_OFFER_DETAILS.
2019-07-16 10:08:16 INFO OGG-15134 TRANDATA for all columns has been added on table CBS_CORE.CB_SUBS_OFFER_DETAILS.
2019-07-16 10:08:16 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table CBS_CORE.CB_SUBS_OFFER_DETAILS.
Regards,
Joe