Friday, July 22, 2016

GoldenGate Error OGG-01161 Bad column index


Replicat Abended with Error # Error   OGG-01161  Bad column index
Replicat abended when it is mapping both source and target tables.

  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 delta.flight1,  max columns = 17.


Potential Fix # 
when definition ( structure ) of table is different from source to target, replicat unable to map the source and target table. Replicat abends with error  "Error   OGG-01161  Bad column index". Create New Definition file from primary and place it on target side # 

Reference #
http://www.oracleinmemory.com/2015/10/ogg-defgen-utility.html

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...