Poster failing due to error:Poster: Unexpected Oracle error: ORA 00957: duplicate column name. (4335493)

After changing one of the table definitions, the following error occurs on target:

Error 2015-02-01 22:04:34.695847 26496 3967600960 s:2 Poster: Unexpected Oracle error: ORA-00957: duplicate column name. (object name: "TIAACREF_REPORTING"."U_LDAP_EMP_CW_USER_LOAD") (posting from db162088, queue ora162088, to db24850) [module opo]

DDL sequence

1. alter table add column NEW_COLUMN

2. update PROBLEM_TABLE set NEW_COLUMN = WILL_BE_DROPPED_COLUMN;

3. commit;

4. alter table drop column WILL_BE_DROPPED_COLUMN

5. alter table rename NEW_COLUMN to DROPPED_COLUMN_NAME

Target failed to update object cache with the latest information.

   8   4000   VARCHAR2 u_memberof                     Nullable
          Destination column name: u_memberof

  23      0       CLOB u_memberof                     Nullable
          Destination column name: u_memberof
  24      0       CLOB u_memberof_temp                Nullable
          Destination column name: u_memberof_temp

Column #8 has the same name as column #23, and temp column was not dropped from it.

manually update object cache.

From source:

1. sp_ctrl>stop capture

2. sp_ctrl>show

>> to make sure capture stop

3. sp_ctrl>start capture

4. cd $SP_SYS_VARDIR/state

copy the latest ocap objcache to target

From target

1. sp_ctrl>stop post queue <queue_name> (if it is still running)

2. cd $SP_SYS_VARDIR/state

3. backup the current object cache for that queue

4. replace the current object cache for that queue with the copied of capture object cache

5. sp_ctrl>start post