October 16, 2009 at 6:06 am
Hi, I have another question I got the merge replication with pull subscription to work on some some in my tables in my data base and some other tables does not work is there a reason for that? The error that I am getting is "The schema script 'Flight_3.sch' could not be propagated to the subscriber." Also in the Log FIle Viewer it say "Message
The job failed. The Job was invoked by Schedule 3 (Replication agent schedule.). The last step to run was step 1 (Run agent.)." I have 20 tables with Merge and pull subscription 10 works and 10 of them does not work the same step I been doing for the other 10 that works. I am out of ideas is there a way I can make the other 10 work I am out of ideas please help !!!
October 16, 2009 at 6:46 am
Do you have foreign key constraints on the subscriber? That could be one reason why it cannot apply the script.
-Roy
October 16, 2009 at 6:59 am
Hi, Roy I think the tables does have Foreign key what should I do I am a bit lost.
October 16, 2009 at 7:09 am
Drop the foreign key constraints and then add it back with the option WITH NOCHECK. That would mean that it will not check for any existing data. That could probably work. I am not sure though. I have not worked much with Merge. In Transactional replication, I dont put the Constraints on the subscriber.
-Roy
October 16, 2009 at 11:24 pm
Hi, Roy I have try to delete the foreign key constraints and and to whack where is the NOCHECK options and I can't seem to find it. But when ran the agent it give me the same error.
October 18, 2009 at 9:08 pm
Hi, After I drop all the foreign key in the table the merge did work but the table is tied with other tables as well. Do you think that there is a step that one table comes before other table in order for the table to become active in the merge process?
October 21, 2009 at 8:41 pm
Hi, Roy thanks again for the tip of checking the Foreign Key. My problem was that there are tables being used by other tables and I have to droop them like you said. It took me a while to find out the order as well but thanks again for your help.
October 22, 2009 at 6:44 am
I am glad you were able to figure out. The foreign key constraint errors question keeps popping up all the time here in SSC.
-Roy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply