Return
-
Title
Show post OR show post detail gives error -
Description
You issue show post or show post detail and receive the following error message (replication is working):
sp_ctrl (abcdefg01avip:2310)> show post detail
Error in sp_cnc
No process found for poster service or invalid datasrc-datadst
or invalid quename -
Cause
The queuename and/or queue username is exactly the limit of 63 characters long.
-
Resolution
WORKAROUND:
Use named export or named post queues:
1. deactivate config <configname>
2. edit the config and insert a named post queue, use a short name.
Here an example:
Datasource:o.sourceSID
source_owner.table target_owner.table targetsys:POST1@o.targetSID
3. activate the config
STATUS:
Waiting for fix in a future release of Shareplex