The "copy table" or "append table" with "force" option results in error "Specify correct target tablename" (4292102)

copy table command is issued to copy a source table in replication to the target table, though the source table is not replicating to the target table specified in copy command. The copy table errors out as below:

sp_ctrl (source_server:port_num) > copy owner.TABLE1 to owner.TABLE1 force

Cannot copy "OWNER"."TABLE1"
Table "OWNER"."TABLE1" is in replication, but not to tablename specified
Specify correct target tablename or use the force option to copy

The config file illustrates the fact that the source table is replicating to a table other than the one specified in the copy table:


sp_ctrl (source_server:port_num)> view config config_name

datasource:o.SID1

#source tables target tables routing map
owner.TABLE1 owner.TABLE2 target_server@o.SID2