You see the following error when activating a config that has tables in vertically partitioned replication:
sp_ctrl > activate config <name>
Error: SharePlex does not support multiple vertical partitions for the same table, and it does not support vertically partitioned and full-table replication for the same table. Please remove one of the configuration entries for the table <tablename>
The config file violates the guidelines for vertical paritioning
A table cannot be configured to replicate some columns to a target (vertical partitioning) and all columns to another target (regular replication). If you want to achieve this, you may have to replicate to the second target vide another port. Or else you may want to remove the conflicting entries from the config file before activating the config again. This restriction has been clearly spelt out in the Admin Guide Chapter titled Preparing for Shareplex Replication section Configuration for vertically partitioned replication as follows:
A table cannot be configured to replicate some columns to one target system and all
columns to another (combination of vertically partitioned replication and full-table
replication).
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy