Field changes cause the Ogg process to stop the workaround

Receiving a change mail request from a developer requires adding fields to a table because our environment DDL is not turned on. Use the message middleware Kafka to do the transmission consumption, apply to the target library. For urgent changes, make the field changes first.

After the change is complete, view the Ogg status;
[Email protected] ggs12]$./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on 7 2014 09:14:25
Operating system Character set identified as UTF-8.

Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

Ggsci (BAPDB1) 2> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING
Jagent RUNNING
EXTRACT RUNNING extdmq 00:00:03 00:00:07
EXTRACT RUNNING EXTNEWP 00:00:04 00:00:09
EXTRACT RUNNING Ext_kaf 00:00:03 00:00:00
EXTRACT RUNNING ext_kaf2 00:00:03 00:00:03
EXTRACT RUNNING ext_kaf4 00:00:03 00:00:03
EXTRACT RUNNING ext_kaf5 00:00:01 00:00:04
EXTRACT RUNNING Ext_kaf6 00:00:02 00:00:01
EXTRACT RUNNING ext_kaf7 00:00:03 00:00:08
EXTRACT RUNNING Ext_kaf8 00:00:03 00:00:06
EXTRACT RUNNING Pmp_kaf 00:00:00 00:00:04
EXTRACT RUNNING pmp_kaf2 00:00:00 00:00:08
EXTRACT RUNNING pmp_kaf4 00:00:00 00:00:10
EXTRACT RUNNING pmp_kaf5 00:00:03 00:00:06
EXTRACT RUNNING Pmp_kaf6 00:00:04 00:00:02
EXTRACT RUNNING pmp_kaf7 00:00:03 00:00:03
EXTRACT RUNNING Pmp_kaf8 00:00:04 00:00:05
EXTRACT RUNNING pudmq 00:00:00 00:00:04
EXTRACT RUNNING PUMPNEWP 00:00:00 00:00:01
Replicat RUNNING REPZW1 00:00:00 00:00:01

Manually stop the use of the table process, extraction and delivery are stopped, waiting for an error message, to find the corresponding target machine;

Locate the address of the Kafka address 10.1.x.9, log on to the machine

[email protected] ~]$ sudo su-app
[[email protected] ~]$ ls
Data datalogs GLT jdk1.8.0_101 jdk1.8.0_25 kafka_2.12-1.0.0 logs nohup.out ogg scripts shell tools zookeeper-3.4.11
[Email protected] ~]$ Ps-ef |grep Mgr
Root 2 0 Mar19? 00:00:00 [Async/mgr]
App 11451 1 0 Mar22? 00:43:43./mgr PARAMFILE/HOME/APP/OGG/GGS12/DIRPRM/MGR.PRM reportfile/home/app/ogg/ggs12/dirrpt/mgr.rpt PROCESSID MGR
App 71909 71834 0 17:36 pts/0 00:00:00 grep Mgr
[Email protected] ~]$ pwd
/home/app
[Email protected] ~]$ CD ogg/ggs12/
[Email protected] ggs12]$./ggsci
Oracle GoldenGate for Big Data
Version 12.3.1.1.1

Oracle GoldenGate Command Interpreter
Version 12.3.0.1.0 oggcore_oggadp.12.3.0.1.0ga_platforms_170828.1608
Linux, x64, 64bit (optimized), Generic on 28 2017 17:13:45
Operating system Character set identified as UTF-8.

Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.

Ggsci (pbsdataskafkagroup2-1) 1> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING
Replicat RUNNING rep_75 00:00:00 00:00:06
Replicat RUNNING rep_75_2 00:00:03 00:00:04
Replicat abending Rep_75_3 00:00:03 00:00:02
Replicat RUNNING rep_90 00:00:00 00:00:00
Replicat RUNNING rep_90_1 00:00:05 00:00:08
Replicat RUNNING rep_90_2 00:00:00 00:00:00
Replicat RUNNING rep_90_3 00:00:00 00:00:01

2018-05-31 17:04:28 ERROR OGG-01161 Bad column index (to) specified for table CFS. T_cfs_acct_item, max columns = 31.

2018-05-31 17:04:28 ERROR OGG-01668 PROCESS abending.

The source side of the operation, the original Defgen file is transferred to a time and date.
[[email protected] ggs12] $CD dirdef/
[[email protected] ggs12] $MV defgen75_3.def defgen75_3.def_0531
[Email protected] ggs12]$ pwd
/ggs/ggs12
[[email protected] ggs12] $defgen paramfile./DIRPRM/DEFGEN75_3.PRM
Generate a new Defgen75_3.def file and transfer it to the target Kafka server.

Target-side operation:
[[email protected] ggs12] $CD dirdef/
[Email protected] dirdef]$ MV Defgen75_3.def defgen75_3.def_0531

Then Kafka the target machine to start the Ogg process,
Ggsci (pbsdataskafkagroup2-1) 1> info All

Program Status Group lags at chkpt time Since chkpt

MANAGER RUNNING
Replicat RUNNING rep_75 00:00:05 00:00:01
Replicat RUNNING rep_75_2 00:00:03 00:00:02
Replicat RUNNING Rep_75_3 00:00:04 00:00:05
Replicat RUNNING rep_90 00:00:00 00:00:00
Replicat RUNNING rep_90_1 00:00:05 00:00:05
Replicat RUNNING rep_90_2 00:00:00 00:00:05
Replicat RUNNING rep_90_3 00:00:00 00:00:07

Field changes cause the Ogg process to stop resolving