Addresses the cause of Sql cache bug in Shareplex
Disable SQL cache & bounce post
sp_ctrl> set param SP_OPO_SQL_CACHE_DISABLE 1
sp_ctrl> stop post
sp_ctrl> start post
This parameter enables or disables the SQL Cache feature. By default, SQL Cache is on,
and this parameter is set to 0; this means that if we already encountered this sql for a previous operation, poster will not have to parse and bind the sql statement again. A setting of 1 disables SQL caching. If you disable SQL
caching, SharePlex prints the following message to the Event Log: SQL Cache disabled.
For more information about SQL Cache, see Chapter 5 of the SharePlex Administrator's
Default: 0 (on)
Range of valid values: 0 or 1 (flag)
Takes effect: when Post is restarted
Addresses the cause Bad record
Discard or read release offending messages refer to solution 24445
Addresses the cause Missed DDL not posted or object not updated
Manual intervention needed please call support for help.