ERROR OGG-01161 Bad column index (17)

Scenario # Replicat got abended with "ERROR   OGG-01161  Bad column index (17) " 

Source Context :

SourceModule   : [ggstd.conv.endian]

SourceID           : [/scratch/aime1/adestore/views/aime1_staxj04/oggcore/OpenSys/src/gglib/ggstd/lecnv.c]

SourceFunction  : [convCompSQL(char *, file_def *, rowlen_t)]

SourceLine         : [533]

2016-07-13 06:48:42  ERROR   OGG-01161  Bad column index (17) specified for table world.andhra_pradesh, max columns = 17.

Last log location read:

     FILE              :     /opt/ggs/trails/yn000063

     SEQNO         :     63

     RBA               :     93183

     TIMESTAMP  :     2016-07-09 05:06:28.026375

     EOF               :      NO

     READERR     :       0

Resolution #  

create definition file using defgen utility, definition of source table is loaded into .def file and place definition file on target

Steps to create definition file
Step1: Create .prm file in dirprm directory under golden gate home

vi  /opt/app/db11g/ggs/dirprm/world.prm
defsfile ./dirdef/def-world.def
userid ggsuser password xxxxxx
table world.andhra_pradesh

Step2:  Run the defgen file from goldengate home 

./defgen paramfile /opt/app/db11g/ggs/dirprm/world.prm 

when you run defgen utility, .def file is created in dirdef directory under goldengate home. after scp or sftp .def file created under dirdef directory from source to target golden gate home /dirdef directory and add parameters in replicat paramfile as follows

Replicat param file with definition file:

-- GGSCI> add replicat rnlggsm1, exttrail /opt/ggs/trails/yn, checkpointtable ggsuser.nspckpt
replicat rnlggsm1
SETENV (ORACLE_HOME="/usr/local/opt/oracle/product/11204")
SETENV (ORACLE_SID="db11g")
userid ggsuser, password xxxxxx
sourcedefs ./dirdef/def-world.def
reperror (default, discard)
discardfile /opt/app/ggs/dsc/rnlggsm1.dsc, megabytes 200, append
discardrollover at 21:00
---REPERROR (1403, DISCARD)
---BATCHSQL BATCHERRORMODE, BATCHTRANSOPS 100000
map world.andhra_pradesh, target india.andhra_pradesh;

Issue is resolved --

--Nikhil Tatineni--

--GoldenGate--