Error: "ORA-00904 invalid column name" and Post stops. (4211208)

Error received during Post:

"ORA-00904 invalid column name"

A column name was changed on source and the target. Post failed on the table with the new column name. The object cache on the target does not have the changed column name for the table.

1. Compare the table structure between the Source and Target. If it different, correct it on Target.

2. Stop post on Target and on <vardir>/state, rename the latest object cache.

ls -ltr *objcache*opst*

Pick the latest/ with highest actid.

On Source:

3. Activate the current configuration again.

4. Copy the new Capture obj cache created on the source to the target and rename it to the post object cache.

5. Start post on Target.

From SharePlex Version 8.5 and above, use "copy cache" command to copy the Source Object cache to the Post object cache on target.

The command is:

sp_ctrl (spdl02:8567)> help copy cache
copy cache -
Copy a cache file to the target
Usage: copy cache
[actid {actid} ]
[at {target_host} [@o.{target_sid}]]
[on {host}] | [on {host}:{port}] |
[on {login}/{password} @ {host}] | [on {login}/{password} @ {host} :{port} ]

sp_ctrl> start post queue <qname>