Solved

Rowguid not created on publishing a merge publication

Posted on 2004-04-08
7
294 Views
Last Modified: 2006-11-17
I have a problem creating new merge publication on my database. My database contains several tables that don't have keys, so when I create the publication it was prompted that a  unique rowguid column will be automatically added. But when the creation of publication completed successfully I didn't find any new column added in my tables, and the snapshot can't be created too, so it can't be replicated.
Can anybody help me to solve this problem?
0
Comment
Question by:yento
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:danblake
ID: 10782082
0
 

Author Comment

by:yento
ID: 10782091
Yes, I've applied SP1.
0
 
LVL 13

Expert Comment

by:danblake
ID: 10782114
We may have to create this manually,
  add a uniqueidentifier data-type to every table as required.
  Specify that this data-type is a ROWGUIDCOL,
  and specify newid() as the default value.

I've seen somebody else where the merge replication has not added the correct column as required.


I didn't find any new column added in my tables, and the snapshot can't be created too, so it can't be replicated.
--> Did the snapshot generate an error ?
What happens when you start the snapshot agent to generate a snapshot manually ?
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:yento
ID: 10804066
If I create the snapshot manually, it was done as if it has succeeded, but there was nothing created in the ReplData folder, and when I try to create a new subscription it was completed but with a message:
"Subscriptions were created successfully at the following Subscribers:
      MYSERVER
The subscription at Subscriber 'MYSERVER' cannot be initialized immediately because the snapshot for this publication is not yet available. To initialize the subscription, start the Merge Agent after the snapshot is available."

I've tried to create the rowguid manually, but the results are the same.
0
 
LVL 13

Accepted Solution

by:
danblake earned 125 total points
ID: 10804294
IF you create the rowguid manually (then it would not allow you to alter this unless replication/subscription was disabled on the tables you were looking at, so I'm presuming this has been done and then the publication/subscribers have been recreated).

The snapshot will not be created until a subscriber exists.  
(So I'm presuming here that you've now created a subscriber and havn't yet rerun the snapshot agent.  Try now rerunning the snapshot agent, and lets have a look at the logs then)

Can you also catch all the information of the agents for the moment:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;312292
This should allow us to debug what is going on.. (I am interested in the error msgs/output msgs from the snapshot agent in this instance).


Can you also let me know which version/edition of sql-server you are using.
0
 

Author Comment

by:yento
ID: 10820001
The problem is solved. When I use the replication logging, I found that the snapshot agent failed to access the ReplData folder. When I see the permission on the folder I found that the user had a read only permission. After I changed the permission to full access, the snapshot is created succesfully.
Thanks for the clue... :)
0
 
LVL 13

Expert Comment

by:danblake
ID: 10820815
No worries, glad to help.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now