3 Replies Latest reply on Jul 25, 2014 5:05 AM by Annamalai A

    ERROR   OGG-01161  Oracle GoldenGate :  Bad column index (302) specified for table, max columns = 302.

    LazyOraDBA

      Hi Gurus,

       

      Env is as below:

       

      Primary site (source): This is production DB and up and running.

      RAC 2 nodes

      Oracle RAC 11.2.0.1.0

      Enterprise Linux Server release 5.5 (Carthage)

       

      target Site (destination):

       

      Standalone single server - Non RAC

      Oracle version 11.2.0.1.0

      Enterprise Linux Server release 5.5 (Carthage)

       

      Oracle GoldenGate Version 11.1.1.0.0

       

      I am facing below error and replicate abended.

       

      ERROR   OGG-01161  Oracle GoldenGate Delivery for Oracle, <replicat_name>.parm:  Bad column index (302) specified for table <table_name>, max columns = 302

       

      There is no difference in table definitions on both source and target.

       

      Please suggest a solution

       

       

      Thanks and Regards,

        • 2. Re: ERROR   OGG-01161  Oracle GoldenGate :  Bad column index (302) specified for table, max columns = 302.
          LazyOraDBA

          Hi kgronau,

           

          PFB report file.

           

          {code}

          GGSCI 1> view report <Replicat>

          ***********************************************************************

                           Oracle GoldenGate Delivery for Oracle

                               Version 11.1.1.0.0 Build 078

             Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 15:35:17

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

                              Starting at 2014-07-24 05:48:28

          ***********************************************************************

          Operating System Version:

          Linux

          Version #1 SMP Mon Mar 29 22:22:00 EDT 2010, Release 2.6.18-194.el5xen

          Node: xxx.in

          Machine: x86_64

                                   soft limit   hard limit

          Address Space Size   :    unlimited    unlimited

          Heap Size            :    unlimited    unlimited

          File Size            :    unlimited    unlimited

          CPU Time             :    unlimited    unlimited

          Process id: 23508

          Description:

          ***********************************************************************

          **            Running with the following parameters                  **

          ***********************************************************************

          --Replicat group --

          replicat <Replicat>

          --source and target definitions

          ASSUMETARGETDEFS

          --target database login --

          userid ggate, password *****

          APPLYNOOPUPDATES

          --file for dicarded transaction--

          discardfile /discard/<Replicat>_discard.txt, append, megabytes 10000

          REPERROR (1403, discard)

          REPERROR (DEFAULT, DISCARD)

          --ddl support

          DDL INCLUDE ALL

          DDLERROR DEFAULT IGNORE RETRYOP

          --MAXTRANSOPS 1000

          --Specify table mapping---

          MAPEXCLUDE <schema_name>.<table_name>;

          map <schema_name>.*, target <schema_name>.*;

          MAP <schema_name>.abc, TARGET <schema_name>.abc;

          CACHEMGR virtual memory values (may have been adjusted)

          CACHEBUFFERSIZE:                         64K

          CACHESIZE:                              512M

          CACHEBUFFERSIZE (soft max):               4M

          CACHEPAGEOUTSIZE (normal):                4M

          PROCESS VM AVAIL FROM OS (min):           1G

          CACHESIZEMAX (strict force to disk):    881M

          Database Version:

          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

          PL/SQL Release 11.2.0.1.0 - Production

          CORE    11.2.0.1.0      Production

          TNS for Linux: Version 11.2.0.1.0 - Production

          NLSRTL Version 11.2.0.1.0 - Production

           

           

          Database Language and Character Set:

          NLS_LANG environment variable specified has invalid format, default value will be used.

          NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.

          NLS_LANGUAGE     = "AMERICAN"

          NLS_TERRITORY    = "AMERICA"

          NLS_CHARACTERSET = "AL32UTF8"

           

           

          Warning: your NLS_LANG setting does not match database server language setting.

          Please refer to user manual for more information.

           

           

          ***********************************************************************

          **                     Run Time Messages                             **

          ***********************************************************************

           

           

          Opened trail file /gg/rt088760 at 2014-07-24 05:48:29

           

           

          Wildcard MAP resolved (entry <schema_name>.*):

            map <schema_name>.pqr, target <schema_name>.pqr;

          Using following columns in default map by name:

           

            CONSIDERINTPAID, STOPPAYCHG, STOPCHGCODE, LOANFORMINOR,

            MINDAYFRADINTAFTMAT, PROVISIONTYPE, AGENTCDREQUIRE, CUSTSANLMT

          Using the following key columns for target table <schema_name>.pqr:MODULE, SCHEME.

           

          MAP resolved (entry <schema_name>.pqr):

            MAP <schema_name>.pqr, TARGET <schema_name>.pqr;

          Detected duplicate MAP entry.  Using prior MAP specification.

          Source Context :

            SourceModule            : [ggstd.conv.endian]

            SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34086]/perforce/src/gglib/ggstd/lecnv.c

          ]

            SourceFunction          : [convCompSQL]

            SourceLine              : [528]

            ThreadBacktrace         : [9] elements

                                    : [/u01/app/ggate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5da0b6]]

                                    : [/u01/app/ggate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2)

          [0x5d0b52]]

                                    : [/u01/app/ggate/replicat(_MSG_ERR_MAP_COL_INDEX_INVALID(CSourceContext*, DBString<777> const&, int

          , int, CMessageFactory::MessageDisposition)+0xa6) [0x57b716]]

                                    : [/u01/app/ggate/replicat [0x8cacdc]]

                                    : [/u01/app/ggate/replicat(ggConvRecLE(char*, file_def*, int, char, char)+0x6d) [0x8cae1d]]

                                    : [/u01/app/ggate/replicat [0x8be525]]

                                    : [/u01/app/ggate/replicat(main+0x1d30) [0x4f5360]]

                                    : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3f2fc1d994]]

                                    : [/u01/app/ggate/replicat(__gxx_personality_v0+0x1da) [0x4d8e8a]]

           

           

          2014-07-24 05:48:29  ERROR   OGG-01161  Bad column index (302) specified for table <schema_name>.pqr, max columns =

          302.

          ***********************************************************************

          *                   ** Run Time Statistics **                         *

          ***********************************************************************

          Reading /gg/rt088760, current RBA 1789815, 0 records

           

           

          Report at 2014-07-24 05:48:29 (activity since 2014-07-24 05:48:29)

          DDL replication statistics:

           

                              Operations:         0

                       Mapped operations:         0

                     Unmapped operations:         0

                        Other operations:         0

                     Excluded operations:         0

                                  Errors:         0

                          Retried errors:         0

                        Discarded errors:         0

                          Ignored errors:         0

          No records were replicated.

           

          Last log location read:

               FILE:      /gg/rt088760

               SEQNO:     88760

               RBA:       1789815

               TIMESTAMP: 2014-07-19 21:21:13.058950

               EOF:       NO

               READERR:   0

          2014-07-24 05:48:29  ERROR   OGG-01668  PROCESS ABENDING.

           

           

          CACHE OBJECT MANAGER statistics

           

           

          CACHE MANAGER VM USAGE

          vm current     =      0    vm anon queues =      0

          vm anon in use =      0    vm file        =      0

          vm used max    =      0    ==> CACHE BALANCED

           

           

          CACHE CONFIGURATION

          cache size       = 512M   cache force paging = 881M

          buffer min       =  64K   buffer highwater   =   4M

          pageout eligible size =   4M

           

           

          CACHE Transaction Stats

          trans active   =      0    max concurrent =      0

          non-zero total =      0    trans total    =      0

           

           

          CACHE File Caching

          disk current   =      0    disk total  =      0

          disk caching   =      0    file cached =      0

          file retrieves =      0

           

           

          CACHE MANAGEMENT

          buffer links  =      0   anon gets   =      0

          forced unmaps =      0   cnnbl try   =      0

          cached out    =      0   force out   =      0

           

           

          Allocation Request Distribution

          < 128B:       0

          128B:        0         0     | 512B:        0         0

             2K:        0         0     |   8K:        0         0

            32K:        0         0     | 128K:        0         0

          512K:        0         0     |   2M:        0         0

             8M:        0         0     |  32M:        0         0

          128M:        0         0     | 512M:        0         0

             2G:        0         0     |   8G:        0

           

           

          Cached Transaction Size Distribution

              0:        0

          < 4K:        0

             4K:        0         0     |  16K:        0         0

            64K:        0         0     | 256K:        0         0

             1M:        0         0     |   4M:        0         0

            16M:        0         0     |  64M:        0         0

          256M:        0         0     |   1G:        0         0

             4G:        0         0     |  16G:        0         0

            64G:        0         0     | 256G:        0         0

             1T:        0         0     |   4T:        0         0

            16T:        0         0     |  64T:        0         0

          256T:        0         0     |1024T:        0         0

           

           

           

           

          QUEUE Statistics:

          num queues    =     15     default index =      0

          cur len       =      0     max len       =      0

          q vm current  =      0     vm max        =      0

          q hits        =      0     q misses      =      0

           

           

          queue size  q hits  curlen  maxlen     cannibalized

            0   64K      0       0       0       0

            1  128K      0       0       0       0

            2  256K      0       0       0       0

            3  512K      0       0       0       0

            4    1M      0       0       0       0

            5    2M      0       0       0       0

            6    4M      0       0       0       0

            7    8M      0       0       0       0

            8   16M      0       0       0       0

            9   32M      0       0       0       0

          10   64M      0       0       0       0

          11  128M      0       0       0       0

          12  256M      0       0       0       0

          13  512M      0       0       0       0

          14    1G      0       0       0       0

           

           

          ================================================================================

          CACHE POOL #0

          POOL INFO   group: <Replicat>  id: p23508_BLOB

          trans active  =       0   trans concurrent (max) =     0

          trans total   =       0   (0 )

          flag          = 0x00000000

          last error    = (0=<none>)

           

           

          Allocation Request Distribution

          < 128B:       0

          128B:        0         0     | 512B:        0         0

             2K:        0         0     |   8K:        0         0

            32K:        0         0     | 128K:        0         0

          512K:        0         0     |   2M:        0         0

             8M:        0         0     |  32M:        0         0

          128M:        0         0     | 512M:        0         0

             2G:        0         0     |   8G:        0

           

           

           

           

          QUEUE Statistics:

          num queues    =     15     default index =      0

          cur len       =      0     max len       =      0

          q vm current  =      0     vm max        =      0

          q hits        =      0     q misses      =      0

           

           

          queue size  q hits  curlen  maxlen     cannibalized

            0   64K      0       0       0       0

            1  128K      0       0       0       0

            2  256K      0       0       0       0

            3  512K      0       0       0       0

            4    1M      0       0       0       0

            5    2M      0       0       0       0

            6    4M      0       0       0       0

            7    8M      0       0       0       0

            8   16M      0       0       0       0

            9   32M      0       0       0       0

          10   64M      0       0       0       0

          11  128M      0       0       0       0

          12  256M      0       0       0       0

          13  512M      0       0       0       0

          14    1G      0       0       0       0

           

           

          ================================================================================

          CACHE POOL #0

          POOL INFO   group: <Replicat>  id: p23508_BLOB

          trans active  =       0   trans concurrent (max) =     0

          trans total   =       0   (0 )

          flag          = 0x00000000

          last error    = (0=<none>)

           

           

          Allocation Request Distribution

          < 128B:       0

          128B:        0         0     | 512B:        0         0

             2K:        0         0     |   8K:        0         0

            32K:        0         0     | 128K:        0         0

          512K:        0         0     |   2M:        0         0

             8M:        0         0     |  32M:        0         0

          128M:        0         0     | 512M:        0         0

             2G:        0         0     |   8G:        0

          {code}

          • 3. Re: ERROR   OGG-01161  Oracle GoldenGate :  Bad column index (302) specified for table, max columns = 302.
            Annamalai A

            Hi ,

             

            Recheck and make sure that the same table structure between two databases , The target table is match with source table, there is a mismatch on columns for source and target. In this case you can't use assumetargetdefs.  so recheck that particular table description on both side and compare the result.

             

            Hope this will help.