-
Title
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” -
Description
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.
-
Cause
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.
-
Resolution
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
-
Additional Information
In case of compare without force option, the later versions of SharePlex never require specifying the target route if source table is replicating to one target only and the route is inferred from the active config. But with the “force” option, the target route has to be specified.