call sp_MSmakegeneration (?)

Hi ,
I have set up merge replication between two servers. The process goes
through all the
bulk copying and applying of some scripts and then end on the error:
The process could not make a generation at the 'Subscriber'.
Last Command {call sp_MSmakegeneration (?)}
I have no idea why this is happening. Any ideas?
Regards,
Swati
1. Run DBCC CHECKDB('dbname')
against the publisher and subscriber db to check for corruption.
2. Also, the results of sp_helpserver should show a serverid of 0 for the
local server, is this what you are seeing?
For example if my SQL server name is "ABC\inst1", sp_helpserver should show:
name id
-- --
ABC\inst1 0
3. Are you running other merge agents simultaneously? If so, try stopping
all other agents and sqlagent jobs, and see if that alleviates the issue.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||On publisher
sp_helpserver is showing as serverid = 0 and on subscriber it is 1 , now
what should I do ?
dbcc checkdb doesnot shows any corrupted table
Regards,
Swati
"Fany Vargas [MSFT]" <fanyv@.online.microsoft.com> wrote in message
news:l#$TqRj4EHA.3512@.cpmsftngxa10.phx.gbl...
> 1. Run DBCC CHECKDB('dbname')
> against the publisher and subscriber db to check for corruption.
> 2. Also, the results of sp_helpserver should show a serverid of 0 for the
> local server, is this what you are seeing?
> For example if my SQL server name is "ABC\inst1", sp_helpserver should
show:
> name id
> -- --
> ABC\inst1 0
>
> 3. Are you running other merge agents simultaneously? If so, try stopping
> all other agents and sqlagent jobs, and see if that alleviates the issue.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Pls help ! It's quiet urgent .. i am unable to replicate any data..
Regards,
Swati
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:#lWC3gy4EHA.1596@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> On publisher
> sp_helpserver is showing as serverid = 0 and on subscriber it is 1 , now
> what should I do ?
> dbcc checkdb doesnot shows any corrupted table
> Regards,
> Swati
>
> "Fany Vargas [MSFT]" <fanyv@.online.microsoft.com> wrote in message
> news:l#$TqRj4EHA.3512@.cpmsftngxa10.phx.gbl...
the[vbcol=seagreen]
> show:
stopping[vbcol=seagreen]
issue.[vbcol=seagreen]
> rights.
Protection
>
|||I want to confirm that what you mean is that on the subscriber you do not
see a SRVID of 0 for the subscriber server when running sp_helpserver on
the subscriber. So for example if my subscriber server is called
SUBSCRIBER1\INST1, and sp_helpserver on this subscriber shows:
name id
-- --
SUBSCRIBER1\INST1 0
nameofpublisherserver 1
then there is no problem, however if you see something like:
name id
-- --
SUBSCRIBER1\INST1 2
nameofpublisherserver 1
then there is a problem because you should have server ID 0 for the local
server. If that is the case you run the following to correctly set the
local server name :
-- Drop the server with incorrect name
EXEC sp_dropserver @.server='SUBSCRIBER1\INST1'
-- Add the correct server as a local server
EXEC sp_addserver @.server='SUBSCRIBER1\INST1', @.local='local'
Reference:
PRB: Replication setup is not successful when SQL Server 2000 is - ID:
818334
http://support.microsoft.com/?id=818334
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Fany,
These are the following steps I have performed for changing the values srvid
to zero on subscriber
use master
sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE
update sysservers set srvid = 0 where srvname='subscriber_name'
sp_configure 'allow updates', 0
RECONFIGURE
It worked fine , and I am able to use merge replication properly now , pls
tell me if this way is correct if I face the same problem again ?
Regards,
Swati
"Fany Vargas [MSFT]" <fanyv@.online.microsoft.com> wrote in message
news:8DyA6M44EHA.3696@.cpmsftngxa10.phx.gbl...
> I want to confirm that what you mean is that on the subscriber you do not
> see a SRVID of 0 for the subscriber server when running sp_helpserver on
> the subscriber. So for example if my subscriber server is called
> SUBSCRIBER1\INST1, and sp_helpserver on this subscriber shows:
> name id
> -- --
> SUBSCRIBER1\INST1 0
> nameofpublisherserver 1
> then there is no problem, however if you see something like:
> name id
> -- --
> SUBSCRIBER1\INST1 2
> nameofpublisherserver 1
> then there is a problem because you should have server ID 0 for the local
> server. If that is the case you run the following to correctly set the
> local server name :
> -- Drop the server with incorrect name
> EXEC sp_dropserver @.server='SUBSCRIBER1\INST1'
> -- Add the correct server as a local server
> EXEC sp_addserver @.server='SUBSCRIBER1\INST1', @.local='local'
> Reference:
> PRB: Replication setup is not successful when SQL Server 2000 is - ID:
> 818334
> http://support.microsoft.com/?id=818334
>
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||This is the 'standard' way to reset the name in
sysservers:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||You should stay away from directly modifying the system stored procedures.
Is there a particular reason why you could not run sp_dropserver +
sp_addserver (execute permissions?)?
a restart of the SQL Server service is necessary.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I made a typo I meant you should stay away from directly modifying system
tables. Especially if there is an interface provided to do the same (in
this case sp_dropserver,sp_addserver)
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I will tk care hence forth , I was doing this exercise on test database
..Thanks for your help.
Regards
Swati
"Fany Vargas [MSFT]" <fanyv@.online.microsoft.com> wrote in message
news:K99KRPs5EHA.2600@.cpmsftngxa10.phx.gbl...
> I made a typo I meant you should stay away from directly modifying system
> tables. Especially if there is an interface provided to do the same (in
> this case sp_dropserver,sp_addserver)
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>