OGG Replication Abended: OGG-01334 Error mapping data ... in function COMPUTE. (Doc ID 1577963.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.1.2 version, 1 - Oracle DB backend

When attempting to run the replicat,
the following error occurs.

ERROR
-----------------------


MAP resolved (entry BOXV2.FT_T_ISSU):
table BOXV2.FT_T_ISSU, target GIMS_TEMP.FT_T_ISSU COLMAP ( ACCESS_AUTH_TYP = ACCESS_AUTH_TYP ISS_ACTVY_STAT_TYP = ACTVY_STAT_TYP DENOM_CURR_CDE = DENOM_CURR_CDE END_TMS = END_TMS INSTR_ID = INSTR_ID INSTR_ISSR_ID = INSTR_ISSR_ID ISS_ALPH_SRCH_TXT = ISS_ALPH_SRCH_TXT ISS_OBJ_TYP = ISS_OBJ_TYP ISS_RATE_TXT = ISS_RATE_TXT ISS_TMS = ISS_TMS ISS_TYP = ISS_TYP ISS_UT_AMT = ISS_UT_AMT ISS_UT_DEC_AMT = ISS_UT_DEC_AMT ISS_UT_MEAS_TYP = ISS_UT_MEAS_TYP LAST_CHG_TMS = LAST_CHG_TMS LAST_CHG_USR_ID = LAST_CHG_USR_ID MAT_EXP_TMS = MAT_EXP_TMS NOM_VAL_UT_AMT = NOM_VAL_UT_AMT NOM_VAL_UT_DEC_AMT = NOM_VAL_UT_DEC_AMT ISS_UT_CQTY = @COMPUTE (ISS_UT_AMT + ISS_UT_DEC_AMT ) NOM_VAL_UNIT_CAMT = @COMPUTE (NOM_VAL_UT_AMT + NOM_VAL_UT_DEC_AMT ) PREF_ID_CTXT_TYP = PREF_ID_CTXT_TYP START_TMS = START_TMS TRDG_RST_TYP = TRDG_RST_TYP DEC_PREC_NUM = @NUMSTR ( 0 ) ) ;
The following target columns were not mapped:
WHEN_ISSUED_IND
SEC_FORM_TYP
INDIV_CERTIF_IND
PRC_MLTPLR_RTE
PRC_MLTPLR_DEC_RTE
PRC_QT_METH_TYP
PRIN_NOTL_IND
EURO_CNVR_TYP
DFLT_STAT_TYP
DFLT_TMS
CL_TYP
SERIES_TYP
MKT_INDX_DEF_ID
PART_FULL_PD_TYP
PREF_ISS_ID
PREF_ISS_NME
PREF_ISS_DESC
DATA_STAT_TYP
DATA_SRC_ID
PAR_VALUE_TYP
LIQUID_RIGHT_RANK_TYP
ISS_ACTVY_STAT_REAS_TYP
DLV_IND
DLV_REAS_CDE
MONITOR_RESTRICTION_CDE
DISTRIBUTION_CURR_CDE
INC_BAS_TYP
PRIN_BAS_TYP
WTHHLD_TAX_IND
WTHHLD_TAX_LEVIED_SRC_IND
TYP_EARN_FOR_LIFE_CDE
PRC_MLTPLR_CRTE
ISCD_OID
EIST_OID
ILLIQUIDITY_IND

Using the following key columns for target table GIMS_TEMP.FT_T_ISSU: INSTR_ID.


2013-08-15 07:00:07 WARNING OGG-01503 Aborting BATCHSQL transaction. Mapping error.

2013-08-15 07:00:07 WARNING OGG-01137 BATCHSQL suspended, continuing in normal mode.

2013-08-15 07:00:07 WARNING OGG-01003 Repositioning to rba 4972786 in seqno 8.

2013-08-15 07:00:07 WARNING OGG-01431 Aborted grouped transaction on 'GIMS_TEMP.FT_T_ISSU', Mapping error.

2013-08-15 07:00:07 WARNING OGG-01003 Repositioning to rba 4972786 in seqno 8.

2013-08-15 07:00:07 WARNING OGG-01335 Error mapping data from BOXV2.FT_T_ISSU to GIMS_TEMP.FT_T_ISSU.NOM_VAL_UNIT_CAMT in function COMPUTE.

2013-08-15 07:00:07 WARNING OGG-01003 Repositioning to rba 4972786 in seqno 8.

Source Context :
SourceModule : [er.main]
SourceID : [/scratch/mmar/view_storage/mmar_stath08_tiers/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [take_rep_err_action]
SourceLine : [16144]

2013-08-15 07:00:07 ERROR OGG-01334 Error mapping data from BOXV2.FT_T_ISSU to GIMS_TEMP.FT_T_ISSU.NOM_VAL_UNIT_CAMT in function COMPUTE.

 

Discard file shows:

Oracle GoldenGate Delivery for Oracle process started, group R_GSTEST discard file opened: 2013-08-15 07:00:07

Mapping error to target column: NOM_VAL_UNIT_CAMT
Mapping error to target column: NOM_VAL_UNIT_CAMT
Mapping error to target column: NOM_VAL_UNIT_CAMT
Current time: 2013-08-15 07:00:07
Discarded record from action ABEND on error 0

Aborting transaction on /data/goldengate/dirdat/ft/01/ft beginning at seqno 8 rba 4972786
error at seqno 8 rba 4972786
Problem replicating BOXV2.FT_T_ISSU to GIMS_TEMP.FT_T_ISSU
Mapping problem with insert record (source format)...
*
INSTR_ID = .967030910
ACCESS_AUTH_TYP = PUBLIC
ACTVY_STAT_TYP = ACTIVE
DENOM_CURR_CDE =
END_TMS = NULL
INSTR_ISSR_ID = 0001w0jqhg
ISS_TMS = 2012-02-14:00:00:00
ISS_OBJ_TYP =
ISS_TYP = B
ISS_UT_AMT = 0
ISS_UT_DEC_AMT = 0
ISS_UT_MEAS_TYP =
MAT_EXP_TMS = 2013-08-30:00:00:00
MN_RTE = 0
MN_DEC_RTE = 0
MX_RTE = 0
MX_DEC_RTE = 0
POOL_ID =
PREF_ID_CTXT_TYP =
RATE_BAS_TYP =
SINKING_FUND_IND =
START_TMS = 2013-07-22:09:13:08
LAST_CHG_TMS = 2013-07-22:09:17:49
LAST_CHG_USR_ID = reddsrb
DTED_TMS = 2012-02-14:00:00:00
FIRST_SETTLE_TMS = NULL
NOM_VAL_UT_AMT = 1000000
NOM_VAL_UT_DEC_AMT = 0
TRANCHE_ID =
PARI_PASSU_DTE = NULL
TRDG_RST_TYP = NULL
CL_SERIES_TYP = NULL
POOL_TYP = NULL
ISS_RATE_TXT = F
ISS_ALPH_SRCH_TXT =
*



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms