Merge Replication Internal Error when Filtering

Last Post 22 Nov 2011 02:43 PM by Clint Spann. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
Clint Spann
New Member
New Member

--
22 Nov 2011 08:08 AM
I have a merge publication on a SQL Server 2008 instance. The subscription exists on a SQL CE database. Everything works fine, until I try to add replication filters. If I add only one filter to the publication, I can create the subscription just fine. I can also go back and add new filters one-by-one, and everything works. However, if I create more than one filter at a time, no matter how many tables I include in the publication, I get the following error:

TITLE: Microsoft SQL Server Management Studio ------------------------------

The referenced table must have a primary or candidate key. [ FK Name = FK_Residents_ResidentStatus ] HRESULT 0x80004005 (28599) The SQL statement failed to execute. If this occurred while using merge replication, this is an internal error. If this occurred while using RDA, then the SQL statement is invalid either on the PULL statement or on the SubmitSQL statement. [ SQL statement = ALTER TABLE "Residents" ADD CONSTRAINT "FK_Residents_ResidentStatus" FOREIGN KEY ( "ResidentStatusKey" ) REFERENCES "ResidentStatus" ( "ResidentStatusKey" ) ON UPDATE CASCADE ] HRESULT 0x80004005 (28560).

Can someone please advise? I can give more detail if needed. Thanks in advance!
rm
New Member
New Member

--
22 Nov 2011 08:34 AM
If you didn't install sql2k8 sp3 yet, I'll say install it then try again. If still get same internal error, should open case to MS.
Clint Spann
New Member
New Member

--
22 Nov 2011 02:43 PM
Thanks for the reply.  Actually, we were running an older patch level, but installing SP3 didn't help.  Looks like I'll be on the horn with Microsoft...


Acceptable Use Policy
---