Capture stopped with "Request for invalid column". (4369848)

Capture stopped with "Request for invalid column".

Capture stopped with following event_log entry:
   Capture: Request for invalid column 22, table TABLE_NAME; cannot continue (capturing from <name>) [module osp]
   Capture killed due to SIGSEGV, core file = /<path>/core.37601, pid = 37601 (capturing from <name>)

The Capture object cache has not updated for the problem table named above.

There may be issues with processing of DDL on a Source table whereby the object cache on Source is not getting details on some column.
To resolve the issue, carry out the following on Source:

1. Execute list config to note the current Activation ID as seen in the numbers following the ‘.conf’ in the output of the name of the active config file.
   Here is the example where the Activation ID is 11:

      sp_ctrl> list config

      File   Name                                                          State       Datasource
      --------------------------------------------------  ----------  ---------------
      config01                                                               Active      o.ORA11GR2

      Last Modified At: 05-Sep-19 21:01    Size: 85      Internal Name: .conf.11  

2. Go to the /vardir/state directory and issue 'ls -l *objcache_sp_ocap*' to find out the name of the latest object cache file for Capture.

      [ORA11GR2@splexserver]/home/splex/var/state> ls -l *objcache_sp_ocap*
      -rw-r--r-- 1 paul dba 600 Sep  5 21:04 o.ORA11GR2-objcache_sp_ocap.11

3. Make a copy of the currently active config file and activate the copy.

      sp_ctrl> copy config config01 to config02
      sp_ctrl> activate config config02

4. Execute list config to note the current Activation ID which should be one number higher than the output in step 1.
    e.g. it will now be 12 instead of 11.

5. Go to the /vardir/state directory and issue 'ls -l *objcache_sp_conf*' to find out the name of the latest object cache file for activation.

      [ORA11GR2@splexserver]/home/splex/var/state> ls -l *objcache_sp_conf*
      -rw-r--r-- 1 paul dba 600 Sep  5 21:04 o.ORA11GR2-objcache_sp_conf.12

6. Take a backup of the existing Capture object cache file for the previous actid as below:

      [ORA11GR2@splexserver]/home/splex/var/state> cp o.ORA11GR2-objcache_sp_ocap.11 o.ORA11GR2-objcache_sp_ocap.11.bak

7. Recreate it from the activation object cache for the current Activation ID as below:

      [ORA11GR2@splexserver]/home/splex/var/state> cp o.ORA11GR2-objcache_sp_conf.12 o.ORA11GR2-objcache_sp_ocap.11

8. Start Capture.

      sp_ctrl> start capture

If the above does not resolve the issue then contact Support for further investigation.