Post stopped due to Oracle error ORA-14251. The event_log indicates the following:
Notice 2013-06-08 21:39:41.226348 9039 1103595840 s:4 Poster: ORA-14251: Specified subpartition does not exist. (posting from ilp_splex, queue amgen, to ilp_splex) [module osp]
Notice 2013-06-08 21:39:41.241819 9039 1103595840 s:4 Poster: Oracle error: ORA-14251: Specified subpartition does not exist. rowid:N/A (posting from ilp_splex, queue amgen, to ilp_splex) [module opo]
Error 2013-06-08 21:39:41.248136 9039 1103595840 s:4 Poster: 15033 - Failed to execute SQL on table "XXX"."XXXXX_DATA": ORA-14251: Specified subpartition does not exist.
WorkAround:
Instruct Shareplex to ignore DDL errors.
On target (where the DDL error is occurring) set the following parameter to instruct Shareplex to ignore any DDL
sp_ctrl>set param SP_OPO_STOP_ON_DDL_ERR 0
sp_ctrl>start post
Shareplex does not support DDL on interval partitioning.
