Shulou(Shulou.com)06/01 Report--

After changing the table structure of the source side, the destination side ogg alarms.

2019-04-15 12:48:47 ERROR OGG-01163 Bad column length (21) specified for column CHANNEL_CODE in table MCS.T_MCS_REPAY_ORD_INF, maximum allowable length is 15.

After commenting out the parameters in the replication process:

-- ASSUMETARGETDEFS

Restart both processes and report the same error. You can't skip the transaction records easily. Regenerate the definition file.

GGSCI (essln1) 7 > edit params defgen

Defsfile / orabak01/ogg/dirprm/cb02.p

Userid ogg,password ogg

Table UCR_BUSI_91.TF_R_MPHONECODE_IDLE

Table UCR_BUSI_91.TF_R_MPHONECODE_USE

GGSCI (essln1) 8 > defgen paramfile / orabak01/ogg/dirprm/defgen.prm

Restart the replication process on the destination side, still report an error, and can't get up.

REPLICAT rep_sc

Userid ogg,password OGG_PROD

Discardfile. / dirdat/repsc_discard.txt,append, megabytes 10

SOURCEDEFS. / dirdef/cb02.p

-- ASSUMETARGETDEFS

-- traceId=defgen_sc

MAP MCS.T_XXX_REPAY_ORD_INF, TARGET FINx.T_BFW_REPAY_ORD_INF, filter (@ GETENV ('transaction',' csn') > 1060516)

In fact, in the table definition file, you need to add a keyword OVERRIDE

SOURCEDEFS. / dirdef/sc.def OVERRIDE

After adding, the process starts normally.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.