-
Title
Post stops with " Poster:../src/opst_mt/syncop.cpp:222: SyncOp: Unknown op=UNKNOWN" -
Description
When replicating from 7.5 to a lower version, the DDL show as UNKNOWN operation on target.
Event log has following entry
Error 2010-07-08 14:33:24.696970 16725 1 Poster:../src/opst_mt/syncop.cpp:222: SyncOp: Unknown op=UNKNOWN. (posting from XXX, queue YYY to ZZZ) [module opo]
Error 2010-07-08 14:33:24.701804 16725 1 Poster stopped: Internal error encountered; cannot continue (posting from XXX, queue YYY to ZZZ)
Info 2010-07-08 14:33:24.719562 15540 1 Poster exited with code=1, pid = 16725 (posting from XXX, queue YYY to ZZZ)
-
Cause
Incorrect setting on SP_OCT_TARGET_COMPATIBILITY
-
Resolution
Resolution :
1 . Set the compatitbility on the source to the target version by setting the parameter SP_OCT_TARGET_COMPATIBILITY to the target version.
On source:
Sp_ctrl> set param SP_OCT_TARGET_COMPATIBILITY {Range of valid values: 6.0, 6.1, or 7.0}
Sp_ctrl> stop capture
Sp_ctrl> start capture
2. Contact Quest Support to assist on removing the 'unknown' message from the post queue
Starting with SharePlex 9, the parameter SP_OCT_TARGET_COMPATIBILITY has been deprecated and is replaced by a new parameter SP_SYS_ TARGET_COMPATIBILITY. Here is the description of the new parameter from the SharePlex Reference Guide:
SP_SYS_TARGET_COMPATIBILITY
This parameter enables you to preserve compatibility between different versions of SharePlex to allow for
smoother migrations and upgrades. As SharePlex continues to evolve to satisfy new user requirements,
features or functionality added in a new version are not always compatible with previous versions. This
parameter enables replication from a higher version of SharePlex on the source system to a lower version on a
target system.
By default, this parameter is set to the version of the installed SharePlex software.
l When replicating from a higher version on a source system to a lower version of SharePlex on a target,
set this parameter to a value that most closely matches the version of SharePlex on the target. For
example, if SharePlex is version 8.6.3 on the source and 8.6.2 on the target, set this parameter to 8.6.2.
l When replicating between identical versions, leave this parameter set to the default on both systems.
Default: The version of the installed SharePlex software
Range of valid values: SharePlex release versions from 6.0.0 to the current version, up to three numbers long
(for example 8.6.3).
Takes effect: when Capture is restarted