merge replication error

Hi All,
I,m trying to pull a suscription for the first time so I create the database
when I create the suscription but I'm getting this error.
could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
Unable to replicate a view or function because the referenced objects or
columns are not present on the Subscriber.
(Source: SQLServer (Agent); Error number: 0)
Invalid object name 'dbo.Clients'.
(Source: SQLServer (Data source); Error number: 208)
Invalid object name 'dbo.EmailJobReports'.
(Source: SQLServer (Data source); Error number: 208)
Invalid object name 'dbo.EmailLinks'.
(Source: SQLServer (Data source); Error number: 208)
Invalid object name 'dbo.Employees'.
(Source: SQLServer (Data source); Error number: 208)
Why is not creating this tables?
Tks in advance for you help..
Johnny
Tks Paul,
I will put my views in a separate publication.
Johnny
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:044401c4d7c8$5d17d310$a601280a@.phx.gbl...
> JFB,
> on SQL Server 2005 you can specify the article processing
> order, but not on SQL Server 2000. To avoid this type of
> issue, you could put the views into a separate
> publication or use sp_addscriptexec to send over
> separately (not forgetting the permissions though).
> Rgds,
> Paul Ibison
>
|||Are these object present on the subscriber? Are these objects part of your
publication?
If they are not present on your subcsriber and are not part of your
publication you will have to manually script them out and deploy them to
your subscriber. Possibly by using sp_addscriptexec if all of your
subscriptions were deployed using a UNC.
you could also use a pre snapshot script to deploy these objects.
If they are not present on your subscriber and are part of your publication
they are not being created in the correct order.
Replication does order the article creation scripts correctly, however it
depends on sysdepends on the publisher which can be inacurate. Your best
option again is a pre snapshot command containing a script which will
precreate these objects for you.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"JFB" <jfb@.newSQL.com> wrote in message
news:OyqGUZ81EHA.3820@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I,m trying to pull a suscription for the first time so I create the
> database when I create the suscription but I'm getting this error.
> could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
> Unable to replicate a view or function because the referenced objects or
> columns are not present on the Subscriber.
> (Source: SQLServer (Agent); Error number: 0)
> ----
> Invalid object name 'dbo.Clients'.
> (Source: SQLServer (Data source); Error number: 208)
> ----
> Invalid object name 'dbo.EmailJobReports'.
> (Source: SQLServer (Data source); Error number: 208)
> ----
> Invalid object name 'dbo.EmailLinks'.
> (Source: SQLServer (Data source); Error number: 208)
> ----
> Invalid object name 'dbo.Employees'.
> (Source: SQLServer (Data source); Error number: 208)
> ----
> Why is not creating this tables?
> Tks in advance for you help..
> Johnny
>
|||Tks for reply Hilary,
These objects are not in the suscriber and are part of the publication.
How can i create it in the correct order?
can you show me how to use a pre snapshot command?
Sorry but I'm new in replication.
Also Paul tell me that I can include the views in a different publication,
because I soon I get out the views the replication works but of course my
database is not complete.
Tks again
Johnny
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OhWVHs81EHA.3504@.TK2MSFTNGP12.phx.gbl...
> Are these object present on the subscriber? Are these objects part of your
> publication?
> If they are not present on your subcsriber and are not part of your
> publication you will have to manually script them out and deploy them to
> your subscriber. Possibly by using sp_addscriptexec if all of your
> subscriptions were deployed using a UNC.
> you could also use a pre snapshot script to deploy these objects.
> If they are not present on your subscriber and are part of your
> publication they are not being created in the correct order.
> Replication does order the article creation scripts correctly, however it
> depends on sysdepends on the publisher which can be inacurate. Your best
> option again is a pre snapshot command containing a script which will
> precreate these objects for you.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "JFB" <jfb@.newSQL.com> wrote in message
> news:OyqGUZ81EHA.3820@.TK2MSFTNGP11.phx.gbl...
>
|||Note that in my case I don't have inter-view
dependencies, so this is possible. If you have views that
query other views, then the same issue may arise. In that
case you'll need to consider sp_addscriptexec.
Rgds,
Paul Ibison
|||Tks for u reply Paul,
How can I use sp_addscriptexec in my snapshot or publication?
You know I'm new and I dont know how to use this... I create the script for
the views in a sql file..
Regards
Johnny
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:082701c4d865$fbb42440$a601280a@.phx.gbl...
> Note that in my case I don't have inter-view
> dependencies, so this is possible. If you have views that
> query other views, then the same issue may arise. In that
> case you'll need to consider sp_addscriptexec.
> Rgds,
> Paul Ibison
>
|||The details are in BOL
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_sp_repl_6qzn.asp). It isn't
really added to the publication, but is a way of using
the replication 'plumbing' to run a script (using osql).
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)