Return
-
Title
Post Notice "Incomplete key set" -
Description
Post Notice:
Notice 2010-12-16 19:01:28.238015 456 6 s:11 Poster: 11009 - Incomplete key set (probably truncated/dropped) objnum=1455307 (posting from SPLEX_MASTER, queue P_QUE02, to PBISDS) [module opo]
-
Cause
Reader cannot find complete key information through query on the source database
-
Resolution
Please upgrade Shareplex to 7.5.2.10 or use the following workaround to turn on supplemental log group for the object. Here is an example:
ALTER TABLE POSSPLEX.TBSP_M22_CROL220 ADD SUPPLEMENTAL LOG GROUP L_TBSP_M22_CROL220_N1 (LAST_UPDATE_TIMESTAMP);
ALTER TABLE POSSPLEX.TBSP_M22_CROL220 ADD SUPPLEMENTAL LOG GROUP L_TBSP_M22_CROL220_N2 (MTL_NO);