Error setting up filter in merge replication

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Error setting up filter in merge replication

Author

Topic

natrio
Starting Member

7 Posts

Posted - 2002-02-14 : 00:27:56

Hi group,
I'm trying to setup filtering in merge replication.
I've setup full merge replication and it works fine, but when I tried to
filter the data horizontally using the wizard (when generating filters
popup), it gave me error messages:

--Error Message--
SQL Server could not extend the filter to other tables based on defined
relationships.

Error 208: Invalid object name 'PARTNER ADDRESS'.
Invalid object name 'PARTNER'.
A column used in filter clause '[PARTNER_ADDRESS].[PAR_ID] =
[PARTNER].[PAR_ID] and [PARTNER_ADDRESS].[BRC_ID] =
[PARTNER].[BRC_ID]' either does not exist in the table 'PARTNER_ADDRESS' or
cannot be excluded from the current partition.
--Error Message--

I'm trying to filter table PARTNER based on branch id using "WHERE
BRC_ID='62011'" and then it will (theoretically) filter the rows in
PARTNER_ADDRESS.
FYI, in the article defaults for the table articles I uncheck all the
options under 'Copy objects to destination'. Is this affecting the error
message?

Anyone know how to solve this problem? Or is there something that I miss?
Please advise.

Thanks

samrat
Yak Posting Veteran

94 Posts

Posted - 2002-02-14 : 05:25:25

Could you please provide more info on database structure of the both the table.

Regards

Samrat Valani

Edited by - samrat on 02/14/2002 05:25:51

natrio
Starting Member

7 Posts

Posted - 2002-02-14 : 21:38:13

Hi,
these are the schemas for PARTNERS and PARTNER_ADDRESS

Table PARTNERS:
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_DN_CN_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[DN_CN] DROP CONSTRAINT FK_DN_CN_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_EXP_REF_10360_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[OBJ_EXP] DROP CONSTRAINT FK_EXP_REF_10360_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_OBJ_EXP_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[OBJ_EXP] DROP CONSTRAINT FK_OBJ_EXP_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_OBJ_SHR_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[OBJ_SHR] DROP CONSTRAINT FK_OBJ_SHR_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_OBJ_SHR_REF_14251_PARTNER]') and
OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[OBJ_SHR] DROP CONSTRAINT FK_OBJ_SHR_REF_14251_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_ORDER_INSURED_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[ORDER_INSURED] DROP CONSTRAINT
FK_ORDER_INSURED_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_ORDERS_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[ORDERS] DROP CONSTRAINT FK_ORDERS_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_ORDERS_PARTNER2]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[ORDERS] DROP CONSTRAINT FK_ORDERS_PARTNER2
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_PARTNER_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[PARTNER] DROP CONSTRAINT FK_PARTNER_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_PARTNER__REF_235_PARTNER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[PARTNER_ADDRESS] DROP CONSTRAINT
FK_PARTNER__REF_235_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_PARTNER__REF_2335_PARTNER]') and
OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[PARTNER_MOU] DROP CONSTRAINT
FK_PARTNER__REF_2335_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[FK_USER_LOG_REF_2344_PARTNER]') and
OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [corsadm].[USER_LOGIN] DROP CONSTRAINT
FK_USER_LOG_REF_2344_PARTNER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[PARTNER]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [corsadm].[PARTNER]
GO
CREATE TABLE [corsadm].[PARTNER] (
[PAR_ID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BRC_ID] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[PAR_NM] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[PAR_TTL] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_OID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_EML] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_YR] [datetime] NULL ,
[PAR_RMK] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_LOB] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_LOB_DSC] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_TYP1] [int] NULL ,
[PAR_TYP2] [int] NULL ,
[PAR_PAR_ID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_BRC_ID] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_REF_TYP] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PAR_REF_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]
GO

TABLE PARTNER_ADDRESS:
if exists (select * from dbo.sysobjects where id =
object_id(N'[corsadm].[PARTNER_ADDRESS]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [corsadm].[PARTNER_ADDRESS]
GO

CREATE TABLE [corsadm].[PARTNER_ADDRESS] (
[PAR_ID] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ADT_ID] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BRC_ID] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ADR_LN1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_LN2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_CTY] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_ZIP] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_RGN] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_PHN] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_FAX] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PHN_ALT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FAX_ALT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_CTC] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADR_NM] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources