Compare does not run on horizontal partitioned replication table, no error, just show compare does not show any running compares.
Example:
Sp_ctrl> compare {source_owner}.{source_table}
sp_ctrl (<XX.XXX.XXX.X>:<PORT#>)> show compare
Host: <XX.XXX.XXX.X>
No active or completed comparisons to show.
Either the command never was issued, or the compare reports and log files
necessary to provide this information have been removed from the system.
SP_SYS_HOST_NAME is set but does not match the config
Example:
SP_SYS_HOST_NAME=XX.XXX.XXX.X
sp_ctrl (<hostname>:<port#>)
1. Shutdown shareplex
2. Export SP_SYS_HOST_NAME <hostname or IP that matches the config>
3. Start shareplex
4. Retry compare
Note:
The SP_SYS_HOST_NAME value should be consistant and not have IP and hostnames mixed, should be either one.
