The parameter sp_opo_disable_object_num is provided so that Post can be instructed to conveniently ignore posting on a specific object which would otherwise cause issues on target Shareplex. Such issues can range from Post stuck with some error condition, slowness of Post, etc. At times one may find that the setting of the parameter is not doing its task.
Incorrect setting or ignoring of posting is not helping in current situation
First one may want to look at the event log. If the messages similar to the following appear in the event log, then Post is indeed instructed by Shareplex to ignore the posting on the problem object:
[13] 01/06/08 02:45 Notice: Table "BOM"."CST_ITEM_COST_DETAILS" is being disabled for DELETE [sp_opst_mt (for o.ew03-o.rw03 queue CostQ)/29062]
[13] 01/06/08 02:45 Notice: Table "BOM"."CST_ITEM_COST_DETAILS" is being disabled for DELETE [sp_opst_mt (for o.ew03-o.rw03 queue CostQ)/29062]
If the issue still persists, then it could be a situation where disabling posting on one object does not bypass the issue. It has been observed in transactions involving multiple tables that includes the problem table.
If the event log does not show the message 'Table "owner"."name" is being disabled for <dml type>', then one may want to check if the correct procedure is used in configuring the parameter. The parameter is set as:
sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM objectid (replace objectid with the actual objectid of the source database table)
If the target object id is specified, then Shareplex will accept the command and will do nothing, while giving the user a false sense of complacency. Shareplex does not check the source or target database for the validity of the object id and simply looks at the queue messages (which have the source object id embedded in them) to decide whether to ignore any message. The same thing applies when replicating from one schema of a database (call it source) to another schema in the same database where one needs to specify the object id of the source schema.
Â
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center