"Poster: ORA-00904: "column name": invalid identifier" (4301732)

event_log:

Notice   2013-02-18 09:45:30.203396 3038 1109395776 s:2 Poster: ORA-00904: "<NEW COLUMN NAME>": invalid identifier.  (posting from ORA11GR2, queue <name>, to ORA11GR2) [module osp]

opo log:

opo      2013-02-18 09:45:30.203920 3038 1109395776 s:2 Process_PER_Result: Unexpected PER_CHECK error(table:"<TARGET TABLE_OWNER>"."<TARGET TABLE NAME>")  oracle rc=904 ../src/opst_mt/sql.cpp:9877

Target table structure and post object cache structure mismatch.

WORKAROUND:

1. Compare source and target table structure and add column on target if missing

2. Compare post object cache dump with post table structure and make sure they are the same. See solution 17525 on how to dump post object cache.

https://support.quest.com/shareplex/kb/17525

3. If post object cache is missing information, then follow instruction in solution 125456 to copy object cache from source to target

https://support.quest.com/shareplex/kb/125456

4. Start post

STATUS:

ST107187 which may cause this error with adding column on vertically partitioned table (ddl replication off)  is resolved in 8.0.1.