Return
-
Title
The second colunmn condition not replicating in the horizontal partition for multiple targets -
Description
Replication is from one source to two targets for the horisontal partition setting. There are two different colunmn conditions for each target. Shareplex only replicate data with the first column condition for all target. It happens in Shareplex 7.5.2 up
-
Cause
When parameter SP_ORD_FIRST_FIND set to 1, it only checks the first condition
-
Resolution
SP_ORD_FIRST_FIND needs to be set to 0.
sp_ctrl > set param SP_ORD_FIRST_FIND 0
sp_ctrl > stop read
sp_ctrl > start read