| Groups | Blog | Home |
sql server replication : Unable to create Merge subscription
http://support.microsoft.com/default.aspx?scid=kb;en-us;308743&Product=sql2k -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message news:OqqZ11TpEHA.3716@TK2MSFTNGP10.phx.gbl... > Publisher: SQL 7 SP2 > Subscriber: SQL 2000 SP3 > > Both in same Domain running Win 2K svr > > I have transactional working fine with the above servers pulling from the > subscriber. > > Have added a Merge publication. > > If I try to set up a pull subscription the Merge one doesn't appear in the > list of available publications. > > If I try to push from the publisher, the data copies across but at the end I > get the following error > > The process could not query row metadata at the Subscriber. > > Could not find stored procedure ''. > (Source: DESTSVR (Data source); Error number: 2812) > -------------------------------------------------------------------------- -- > ----------------------------------- > >
Publisher: SQL 7 SP2
Subscriber: SQL 2000 SP3 Both in same Domain running Win 2K svr I have transactional working fine with the above servers pulling from the subscriber. Have added a Merge publication. If I try to set up a pull subscription the Merge one doesn't appear in the list of available publications. If I try to push from the publisher, the data copies across but at the end I get the following error The process could not query row metadata at the Subscriber. Could not find stored procedure ''. (Source: DESTSVR (Data source); Error number: 2812) ---------------------------------------------------------------------------- -----------------------------------
how are you connecting to your subscriber? Are you using SQL Authentication
or windows authentication? Confirm this by connecting to your publisher in EMl, clicking Tools, Pointint to replication, configure publisher, susbcribers and distributor, and click the subscribers tab, click on the browse button to the right of your publisher. Then check on the authentication mechanism you have selected in the Agent Connection to the publisher. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message news:uSVC$nWpEHA.3244@tk2msftngp13.phx.gbl... > switched on logging and got this at the end of the log....... > > --------- snip --------------------------------------- > Processing article 'tbl_WEB_SEARCH_LOG_METHOD' > Percent Complete: 73 > Processing article 'tbl_WEB_SEARCH_LOG' > Percent Complete: 0 > The process could not query row metadata at the Subscriber. > Percent Complete: 0 > Category:COMMAND > Source: Failed Command > Number: > Message: {call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_M > Percent Complete: 0 > Category:SQLSERVER > Source: FALSTAGE1 > Number: 2812 > Message: Could not find stored procedure ''. > Could not find stored procedure ''. > Disconnecting from Publisher 'WEBSQL01' > Disconnecting from Subscriber 'FALSTAGE1' > Disconnecting from Publisher 'WEBSQL01' > Disconnecting from Distributor 'WEBSQL01' > > > > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:uzHfihVpEHA.3392@TK2MSFTNGP15.phx.gbl... > > did you consult this kb article? > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;308743&Product=sql2k > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > > > "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message > > news:OqqZ11TpEHA.3716@TK2MSFTNGP10.phx.gbl... > > > Publisher: SQL 7 SP2 > > > Subscriber: SQL 2000 SP3 > > > > > > Both in same Domain running Win 2K svr > > > > > > I have transactional working fine with the above servers pulling from > the > > > subscriber. > > > > > > Have added a Merge publication. > > > > > > If I try to set up a pull subscription the Merge one doesn't appear in > the > > > list of available publications. > > > > > > If I try to push from the publisher, the data copies across but at the > end > > I > > > get the following error > > > > > > The process could not query row metadata at the Subscriber. > > > > > > Could not find stored procedure ''. > > > (Source: DESTSVR (Data source); Error number: 2812) > > > > -------------------------------------------------------------------------- > > -- > > > ----------------------------------- > > > > > > > > > > > >
Yes, seen that. Adding the -PublisherLogin parameter made no difference. Can there still be a perm problem when transactional repl is working in both directions? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uzHfihVpEHA.3392@TK2MSFTNGP15.phx.gbl... > did you consult this kb article? > > http://support.microsoft.com/default.aspx?scid=kb;en-us;308743&Product=sql2k > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > > "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message > news:OqqZ11TpEHA.3716@TK2MSFTNGP10.phx.gbl... > > Publisher: SQL 7 SP2 > > Subscriber: SQL 2000 SP3 > > > > Both in same Domain running Win 2K svr > > > > I have transactional working fine with the above servers pulling from the > > subscriber. > > > > Have added a Merge publication. > > > > If I try to set up a pull subscription the Merge one doesn't appear in the > > list of available publications. > > > > If I try to push from the publisher, the data copies across but at the end > I > > get the following error > > > > The process could not query row metadata at the Subscriber. > > > > Could not find stored procedure ''. > > (Source: DESTSVR (Data source); Error number: 2812) > > -------------------------------------------------------------------------- > -- > > ----------------------------------- > > > > > >
switched on logging and got this at the end of the log.......
--------- snip --------------------------------------- Processing article 'tbl_WEB_SEARCH_LOG_METHOD' Percent Complete: 73 Processing article 'tbl_WEB_SEARCH_LOG' Percent Complete: 0 The process could not query row metadata at the Subscriber. Percent Complete: 0 Category:COMMAND Source: Failed Command Number: Message: {call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_M Percent Complete: 0 Category:SQLSERVER Source: FALSTAGE1 Number: 2812 Message: Could not find stored procedure ''. Could not find stored procedure ''. Disconnecting from Publisher 'WEBSQL01' Disconnecting from Subscriber 'FALSTAGE1' Disconnecting from Publisher 'WEBSQL01' Disconnecting from Distributor 'WEBSQL01' [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uzHfihVpEHA.3392@TK2MSFTNGP15.phx.gbl... > did you consult this kb article? > > http://support.microsoft.com/default.aspx?scid=kb;en-us;308743&Product=sql2k > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > > "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message > news:OqqZ11TpEHA.3716@TK2MSFTNGP10.phx.gbl... > > Publisher: SQL 7 SP2 > > Subscriber: SQL 2000 SP3 > > > > Both in same Domain running Win 2K svr > > > > I have transactional working fine with the above servers pulling from the > > subscriber. > > > > Have added a Merge publication. > > > > If I try to set up a pull subscription the Merge one doesn't appear in the > > list of available publications. > > > > If I try to push from the publisher, the data copies across but at the end > I > > get the following error > > > > The process could not query row metadata at the Subscriber. > > > > Could not find stored procedure ''. > > (Source: DESTSVR (Data source); Error number: 2812) > > -------------------------------------------------------------------------- > -- > > ----------------------------------- > > > > > >
Have tried both integrated and standard security, doesn't make any
difference. As Transactional rep is working fine both ways I don't think this is a security issue. I have found a KB article, 283034 that seems to describe the problem. So I'll try to reapply SP3 and see if that helps. Thanks for your suggestions Hilary. [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O6k0NEYpEHA.3728@TK2MSFTNGP09.phx.gbl... > how are you connecting to your subscriber? Are you using SQL Authentication > or windows authentication? Confirm this by connecting to your publisher in > EMl, clicking Tools, Pointint to replication, configure publisher, > susbcribers and distributor, and click the subscribers tab, click on the > browse button to the right of your publisher. Then check on the > authentication mechanism you have selected in the Agent Connection to the > publisher. > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > > "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message > news:uSVC$nWpEHA.3244@tk2msftngp13.phx.gbl... > > switched on logging and got this at the end of the log....... > > > > --------- snip --------------------------------------- > > Processing article 'tbl_WEB_SEARCH_LOG_METHOD' > > Percent Complete: 73 > > Processing article 'tbl_WEB_SEARCH_LOG' > > Percent Complete: 0 > > The process could not query row metadata at the Subscriber. > > Percent Complete: 0 > > Category:COMMAND > > Source: Failed Command > > Number: > > Message: {call sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call > > sp_MSgetrowmetadata(?,?,?,?,?,?,?)}{call sp_M > > Percent Complete: 0 > > Category:SQLSERVER > > Source: FALSTAGE1 > > Number: 2812 > > Message: Could not find stored procedure ''. > > Could not find stored procedure ''. > > Disconnecting from Publisher 'WEBSQL01' > > Disconnecting from Subscriber 'FALSTAGE1' > > Disconnecting from Publisher 'WEBSQL01' > > Disconnecting from Distributor 'WEBSQL01' > > > > > > > > > > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > > news:uzHfihVpEHA.3392@TK2MSFTNGP15.phx.gbl... > > > did you consult this kb article? > > > > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;308743&Product=sql2k > > > > > > -- > > > Hilary Cotter > > > Looking for a SQL Server replication book? > > > http://www.nwsu.com/0974973602.html > > > > > > > > > "Nick Horrocks" <nickhorrocks@hotmail.com> wrote in message > > > news:OqqZ11TpEHA.3716@TK2MSFTNGP10.phx.gbl... > > > > Publisher: SQL 7 SP2 > > > > Subscriber: SQL 2000 SP3 > > > > > > > > Both in same Domain running Win 2K svr > > > > > > > > I have transactional working fine with the above servers pulling from > > the > > > > subscriber. > > > > > > > > Have added a Merge publication. > > > > > > > > If I try to set up a pull subscription the Merge one doesn't appear in > > the > > > > list of available publications. > > > > > > > > If I try to push from the publisher, the data copies across but at the > > end > > > I > > > > get the following error > > > > > > > > The process could not query row metadata at the Subscriber. > > > > > > > > Could not find stored procedure ''. > > > > (Source: DESTSVR (Data source); Error number: 2812) > > > > > > > -------------------------------------------------------------------------- > > > -- > > > > ----------------------------------- > > > > > > > > > > > > > > > > > > > >
I am struggling with exactly the same problem as Nick. I
think the key is SQL Server 7 replicating to 2000. I have a merge replication to another vs. 7 installation that works fine, but going to 2000, I get the same results. I can repeat the behavior attempting to replicate to 2 different 2000s. I looked at the KB article, but don't think it applies, since merge works fine to vs. 7. Any ideas? Thanks,
Nick,
please see my reply to George's post on 30th Sep. You can look at this reference if you like : http://msdn.microsoft.com/library/default.asp? url=/library/en-us/replsql/replimpl_4joy.asp. Basically the problem you have is that the setup you want is not supported - Merge from SQL 7.0 can only go to a SQL 7.0 subscriber. HTH, Paul Ibison (recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |