call sp_MSmakegeneration (?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

swati - 14 Dec 2004 09:09 GMT

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

Reply to this Message

Fany Vargas [MSFT] - 14 Dec 2004 23:26 GMT

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

Signature

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

Reply to this Message

swati - 16 Dec 2004 04:35 GMT

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

> 1. Run DBCC CHECKDB('dbname')
> against the publisher and subscriber db to check for corruption.
[quoted text clipped - 24 lines]
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx

Reply to this Message

swati - 16 Dec 2004 05:38 GMT

Pls help ! It's quiet urgent .. i am unable to replicate any data..

Regards,
Swati

> On publisher
> sp_helpserver is showing as serverid = 0 and on subscriber it is 1 , now
[quoted text clipped - 34 lines]
> > http://www.microsoft.com/protect
> > http://www.microsoft.com/security/guidance/default.mspx

Reply to this Message

Fany Vargas [MSFT] - 16 Dec 2004 15:21 GMT

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

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

swati - 17 Dec 2004 13:17 GMT

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

> 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
[quoted text clipped - 31 lines]
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Paul Ibison - 17 Dec 2004 16:03 GMT

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)

Reply to this Message

Fany Vargas [MSFT] - 17 Dec 2004 19:04 GMT

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

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Fany Vargas [MSFT] - 17 Dec 2004 19:05 GMT

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

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

swati - 21 Dec 2004 05:40 GMT

I will tk care hence forth :), I was doing this exercise on test database
.Thanks for your help.

Regards
Swati

> 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
[quoted text clipped - 3 lines]
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message