Return
-
Title
After adding one more target for CDC (change tracking) using + sing, got error "Cannot define compound route when target is table with tracking columns." -
Description
Trying to add 2nd target to shareplex CDC replication, but got error" : oconf 2015-10-22 14:22:49.731738 16790 3805149024 Invalid route: Cannot define compound route when target is table with tracking columns. Skipping ("SYSADM"."PS_STDNT_CAREER"). -
Cause
For CDC, we do not support compound route (using + for more then one targets in the config file). -
Resolution
Each target should have its own line in the config file instead of using “+” sign for multiple targets in one line.
For example, following will work:
SYSADM.PS_STDNT_CAREER SYSADM.PS_STDNT_CAREER sys1@o.SID
SYSADM.PS_STDNT_CAREER SYSADM.PS_STDNT_CAREER sys2@o.SID