Solved

Rowguid not created on publishing a merge publication

Posted on 2004-04-08
7
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

762 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