-
Title
A table fails to activate in Vertical Partitioning with error “Skipping duplicate entry for -
Description
A table fails to activate in Vertical Partitioning environment with error “Skipping duplicate entry for <owner.table_name>” as shown below:
oconf 2014-02-11 23:35:35.072001 21528 1 Processing the configuration entries
oconf 2014-02-11 23:35:35.315959 21528 1 Skipping duplicate entry for "OWNER"."TABLE_NAME" in line nnn - Source is defined in line nnn1 to same target
The following are the config file entries for the problem table (which is being routed to two targets in Vertical Partitioned manner:
OWNER.TABLE_NAME (c1,c2) OWNER.TABLE_NAME (c1,c2) targsysB@o.targSID
OWNER.TABLE_NAME (c1,c2) OWNER.TABLE_NAME (c1,c2) targsysC@o.targSID
-
Cause
A vertically partitioned source table cannot be listed more than once in a configuration. -
Resolution
Use compound routing map for the table so that only one entry is used in the config file for both targets. To accomplish this:
- Make a copy of the currently active config file
- Edit the copy to either remove the existing entries for the problem table or comment them out by putting the pound sign (# sign) as the first character in the entry.
- Replace it with the following entry in the copy of the config file:
OWNER.TABLE_NAME (c1,c2) OWNER.TABLE_NAME (c1,c2) targsysB@o.targSID + targsysC@o.targSID
- Activate the copy
-
Additional Information
See Shareplex Administrator Guide Chapter titled "Preparing for SharePlex Replication" section titled "Replication to multiple target systems": A vertically partitioned source table cannot be listed more than once in a configuration. Therefore, replication of a vertically partitioned table to multiple target systems requires a compound routing map. To use a compound routing map, all of a source table’s target tables must have the same owners and names. Permissible: scott.emp (c1,c2) scott.sal (c1,c2) targsysB@o.targSID + targsysC@o.targSID Not permissible: scott.emp (c1,c2) scott.sal (c1,c2) targsysB@o.targSID scott.emp (c1,c2) scott.sales (c1,c2) targsysC@o.targSID