Error in Event Log: "Internal error: Poster exit on 9i ddl error due to ORA-00942: table or view (4256339)

Post stops due to error and Event log has the following error:

"Internal error: Poster exit on 9i ddl error due to ORA-00942: table or view does not exist. on ALTER TABLE "FTPROD"."EID_COMPARE_RESPONSE" MODIFY("RULE_ID"... [sp_opst (for o.YEN10DB-o.YEN7DB queue yen10vip)/10514]
Process exited sp_opst (for o.YEN10DB-o.YEN7DB queue yen10vip) [pid = 10514] - exit(1)
Notice: ORA-00942: table or view does not exist. [sp_opst(osp)/10513]
Internal error: Poster exit on 9i ddl error due to ORA-00942: table or view does not exist. on ALTER TABLE "FTPROD"."OAO_PERSON_CROSS_SELL_PRODUCT" ADD("CR... [sp_opst (for o.YEN9DB-o.YEN6DB queue yen9vip)/10513]"

Post executes a DDL on a table that does not exist or the data structure is different.

Identify the problem table and verify that the source and target DDL are the same (Data Structure) and that it exists on the target.

Once you have identified the problem you can set the SP_OPO_CONT_ON_ERR parameter and ignore the ORA-00942 error so post continues posting on the target. Once the messages have been posted then you can unset this parameter.

SP_OPO_CONT_ON_ERR parameter controls whether or not Post stops when it encounters Oracle errors that can be corrected. It can be changed from the default of 0 (stop on Oracle errors) to 1, which instructs SharePlex to ignore the error messages and continue posting. Before changing the setting to 1, you need to add the Oracle messages that you do not want Post to stop for to the oramsglist file on the target system. This file is in the data sub-directory in the SharePlex variable-data directory.

To set up the parameter, follow these steps:

1. Stop Post.
sp_ctrl> stop post

2. Open the oramsglist file on the target system and increase the number on the first line by one
(This number tells SharePlex how many error messages are in the file).

3. At the end of the file, add the message number of the Oracle error 942 that you do not want Post to stop for.

4. sp_ctrl>set param SP_OPO_CONT_ON_ERR 1
sp_ctrl>set param SP_OPO_STOP_ON_DDL_ERR 0

5. Start Post.
Post will not stop when it encounters ORA-00942.

6. Once the error has been bypassed, you can unset by (sp_ctrl> reset param SP_OPO_CONT_ON_ERR & sp_ctrl> reset param SP_OPO_STOP_ON_DDL_ERR ).