The following errors are observed in event log when Post stopped due to ORA-29876:
Error 2016-12-01 09:49:52.815730 103744 2039416576 s:9 Poster: que/seq = 9/ 868426269 seqno/offset = 25809/421625644 Unexpected Oracle error: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-13375: the layer is of type [2001] while geometry inserted has type [2002] ORA-06512: at "<method_name>", line 720 ORA-06512: at "<method_name>", line 225 (object name: "OWNER"."TABLE_NAME") (posting from name1, queue queue_name, to name2) [module opo]
There is a problem with the code in the procedural object on target.
Resolution 1:
Fix the procedural code and restart Post
Resolution 2:
If you wish to ignore posting for the time being on the problem table involved in the procedure, set the following on the target sp_ctrl:
sp_ctrl>set param SP_OPO_DISABLE_OBJECT_NUM <object id of the “OWNER"."TABLE_NAME” from source database>
sp_ctrl>start post
Once the error is bypassed you can either continue to ignore the posting on that table or undo the changes to the parameter SP_OPO_DISABLE_OBJECT_NUM subject to the underlying cause being addressed.
