-
Title
Post errors out with “Poster: Missing keys.Please turn on PK/UK at the source” -
Description
The following errors are observed in event_log, typically when replicating from Oracle to an Open target environment:
sp_ctrl> show log reverse
Error 2017-10-19 14:09:24.651877 3613 2662365056 Poster killed due to SIGSEGV, core file = /vardir/dump/core.9070 was not generated, pid = 9070 (posting from SID1, queue queue_name, to SID2)
Error 2017-10-19 14:09:24.608612 9070 1174128576 Poster: Missing keys.Please turn on PK/UK at the source (posting from SID1, queue queue_name, to SID2) [module opx]
Info 2017-10-19 14:09:24.448568 9070 2662365056 Poster launched, pid = 9070 (posting from SID1, queue queue_name, to SID2) Error 2017-10-19 14:09:14.773480 3613 2662365056
-
Cause
The supplemental logging has not been enabled for PK/UK or, even if it is enabled, the parameter SP_OCT_USE_SUPP_KEYS has not been set to 1. -
Resolution
The requirement for SharePlex to replicate from Oracle to Open target are:
Enable supplemental logging (PK/UI) for the table in question on source database.
Set the Capture parameter SP_OCT_USE_SUPP_KEYS on source to enable capture to use the keys in the Oracle log:
On Source:
sp_ctrl> set param SP_OCT_USE_SUPP_KEYS 1.
Since the existing messages in Post queue will not drain due to the above requirements not met, one will need to shutdown SharePlex on both source and target, run ora_cleansp, activate afresh and then resync the target.
-
Additional Information
See article 224745 for details on steps involved in setting open target. For details on running ora_cleansp, please refer to SharePlex Administrator Guide.