The compare with force option results in error “Cannot compare owner.table_name, required information is missing” “Missing target host name” and “Missing target SID” (4296886)

The following errors are observed  “compare force” is issued on a table that exists in the source and target database and is not a part of replication:

sp_ctrl (source_server:5438)> compare sha90.table1e force

 Cannot compare "SHA90"."TABLE1E", required information is missing

  Missing target host name

  Missing target SID

  comparing 0 of 1 objects

  1 object(s) contain errors

 No objects to compare; no job started.

When running a compare with “force” option, it is imperative that at the very least the target routing info be provided.

If target table name is not provided, it is assumed that it is same name as that of the source table.

The “force” option is dealing with tables not forming part of the active config. So it is required to specify the route of the target table so that compare can correctly ascertain the target table. 

Here is the correct way to run compare with “force” option:

sp_ctrl (source_server:5438)> compare sha90.table1e at target_server@o.target_sid force

comparing 1 of 1 objects

compare started; job id 3

sp_ctrl (source_server:5438)> job status

Job ID    : 3

PID       : 13264

Host      : source_server

Started   : 14-JUL-17 19:16:03

Job Type  : Compare

Status    : Done - 1 object completed

ID     Tablename                            Status     Time       Total Rows %Comp Total Time

------ ------------------------------------ ---------- ---------- ---------- ----- ----------

1      "SHA90"."TABLE1E"                    Out Sync          N/A          2   100       0:05