Replication Monitor Bug - Subscription Names Suddenly Not Displaying?
This is strange.
We use Merge (pull) replication to get data from the "mother ship" updated to the laptops of 15 sales reps before they head out into the field, where they work disconnected. At end of day, they all reconnect and all the data is once again shared.
We've been having problems with the replication, but that's another topic.
This morning, I logged onto the server to check the replication monitor, and found that all of the subscriber names for that particular subscription are blank! They show the open/close bracket ( [] ) followed by the database name. This is under the My Publishers >> [server name] >> [publication name] node in the explorer tree. If I try to double-click on one of the subscribers to get their detail, I get tne message, "Replication Monitor could not open the Detail Window." and "Specified cast is not valid".
If I look at the publication in SQL Server Management Studio, all of the subscriber names show up just fine. But they do NOT show up under Replication Monitor.
No one touched the database over the weekend, and this was working just fine on Friday afternoon.
Has anyone seen this before? What to do?
View Complete Forum Thread with Replies
Related Forum Messages:
All Replication Publications Suddenly Disappear
Hi: Did you have any experience that all publications and their related jobs suddenly disappear? I had a transactional pull replication between two servers, and distributor and subscriber in the same box; publisher was an AA cluster server. The schedule of pulling was once a week. Last Friday morning everything was working perfectly, but I found all publications and their related jobs disappear around 5pm I checked with the sysadmin and he said nothing was changed on that period. Did you have any idea about it? Did you have any idea that I can prevent this happen again or any alert I can set up to monitor who drop it, when it was dropped and so on? It is a SQL 2000 box and system table doest not take trigger. Thanks in advance Theresa
View Replies !
Subscription With Table Filter Using User!UserID Not Displaying All Data
Hey, Microsoft....is this a bug? We have SSRS 2005 SP1. The result set returns data for 50 employees. I use a table filter: User!UserID = Fields!NtUserName.Value. I substituted my NtUsername for Fields!NtUserName.Value. When I generate the report all is well - I can see the data on all of the employees. From prior testing, I know that when I use the table filter 'User!UserID = Fields!NtUserName.Value' each employee will see only their data. I want to send a link to all of the employees that will open the last history record. In Report Manager... report Properties tab....History Window..I have checked 'Allow report history to be created manually' and 'Store all report execution snapshots to report history.' In the Execution window I selected 'Render this report form a report execution snapshot" and am using a Shared schedule. I created a Subscription to email me the link. When I select 'Create a report snapshot when you click the Apply button on this page' in the Execution tab, all is well - an email is sent and when I click the link I can see the data for all 50 of the employees (I use a page-break by Employee group so there are 50 pages). However, when the report is generated using the shared schedule, only the first record in the report is displayed and it shows there is only 1 page in the report; and the size of the report is slightly smaller (292 KB vs. 536 KB). If I create a 'New Snapshot' from the History tab, I can see the data on all of the employees, however, using the link that was emailed when I executed the schedule, I again only see the first employee in the report (perhaps the email does not link back to the history record created in this manner?). Additionally, when I create a linked report and manually generate it, again only the 1st employee in the result set is in the report. I've tried many things, including using the NtUsername of 'dbo' and the NtUsername of the account the DataSource is using, but no luck. Any suggestions??? I am tired of manually executing this report twice a week, but thankful I don't have to do this every hour of the business week!!!
View Replies !
Replication Monitor
I'm experiencing some very odd behavior in Enterprise Manager.I have a process that performs the following:1.) Restores a published database from Server A onto Server B. Thedatabasesare identical and they are both published.2.) I run a script that then deletes the subscriptions to thepublication onServer B. I do this via SP_DROPSUBSCRIPTION.3.) I run a script that then deletes the publication. I do this viaSP_DROPPUBLICATION.4.) Deletes the distribution database.5.) Deletes the old jobs.6.) Creates the publication from pregenerated scripts.7.) Adds the subscriber.8.) Adds the subscription.9.) Generates the snapshot and applies it.What's happening is that I'm seeing the job name that's assigned to thedistribution job increment by 1 each time this process is run. Also,I'mseeing ten instances of the publication showing up in the tree view.Everything appears to be rtunning just fine, transactions beingreplicated,etc. I'm just wondering is there something I'm missing in my steps.Plus,after two or three months of this, might not look so good having 90publications showing up in the tree view.Thanks!
View Replies !
Replication Monitor Bug?
There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema. Here is my setup: Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name() When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says: Applying Database Schema - 0% complete (approzimately 00:00:00 remaining) If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete. If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know. You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg Thanks In Advance. Martin
View Replies !
Monitor Replication With Vb Code
I have to write a little vb6 app to monitor sql 2000 replication. The app must run on the same desktop as the subscriber. I've tried the samples that comes with sql (replsampl) but that is to do the replication, I need to just monitor replication that was set up in sql 2000. With monitor I mean to show a red light when replication is busy, so that the user doesn't disconnect from the network while replication is in progress. Any ideas?
View Replies !
Replication Monitor Problem
When I launch Replication Monitor, the publisher is marked with an "X". I right-click, select "Connect to Distributor" and then I can see the publications. 10 seconds later, I get the red "X" again and have to "connect to distributor". Why is this happening? And how can I stop it? The publisher used to stay connected. It started doing this when I added another publisher to the distributor. I'm not sure if that's the reason why??????
View Replies !
Replication Monitor SqlServerCE
I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?
View Replies !
Replication Monitor Question
Hello, We have some mobile devices that are setup to replicate with our sql 2005 server via web sync. It seems that the devices are added multiple times within replication monitor. Is there a way to purge the bogus items. For example we have a mobile unit labeled as Device12 we have it listed under the subscriptions 5x. I would like to purge four of them as they are not currently being the replicated one. Device12-A6EE69A0944 is the valid subscription Device12-EE44D1EF3E24 is an invalid one. Thanks in advance. John
View Replies !
Replication Monitor Error
When Replication monitor shows an error icon, I removed all the publication jobs completedly. After I reconfigured publishing, subscriber,Distribution, why the replication monitor still shows an error icon even though there is no replication job scheduled? Thank you!
View Replies !
Publisher Is Empty Under Replication Monitor - Publisher.! But Replication Is Still Running Fine..
I have a wired situation..!I set up transactional replication on one of my development server (SQL2000 Dev Edition with sp4).It is running fine without any issues and all of a sudden, i noticed inmy repication monitor tab under Publisher where I usually see thepublication is empty now.I do see the snapshot agent, log reader and distribution agent under myagents inside the replication Monitor. But its usefull to see all 3agents in one window under publisher before. What happend? Is there anyway to get that inside that monitor? Has someone encountered thissitation before? Please advise....After that I tried to create a new set of replication on differentdatabase on the same server and i dont see those either underReplication Monitor - Publishers....All it says is (No Items)....I would appreciate any help to correct this issue... Thanks in advance..
View Replies !
Sending Replication Monitor Data
We have a database on the live server which powers a website. Then our client has a copy of the database at their office. Their is Merge replication set up between the two running every half a hour. Now they want to be able to look at the merge replication history. With my little knowledge, I believe that the place to get this data from is the distribution database on the publishing machine which is the live server. Now for obvious reasons we cannot replicate the distrubution database to their side so we need to come up with some way of giving them the data. They also want a history of replication. So the way I was thinking of fixing it was to have a job that copies some of the last days data from the distrubution database onto the main database and add that table to the replication so they got it every day. Also writing a ASP page so they can look at the last days data straight from the distrubution database. Here are my questions: Question 1: How long does the replication store history for? Question 2: Is thier any simpler way of allowing them to see the replication history? Question 3: Are their any other things I should be worried about? Thanks for any feedback, Nixies
View Replies !
Replication Monitor Playong Jokes On Me.
Hi, I have configured my server to begin replicating. When I forst set it up, I was transactionally replicating a restored copy of a database, and had problems with the replication. I then cleared out the tran log, disabled replication, and set it up again. Now i can replicate just fine, but the Replication monitor continues to show the little red "x" in it, suggesting that there are errors/problems. None of the agents show errors in their history, het my snapshot agent folder shows a red "x" as well as the pubications folder. I got upset. I went in, disabled publication, and truncated all of the tables in the DISTRIBUTION database, and then re-enabled publication. That didn't help. I disabled replication (completely dropping the DISTRIBUTIN database) and this didn't clear it up either. Can anyone tell me how to get rid of the little red "x" so I can get an accurate picture of what's going on on my server? I know I can monitor it other ways, but I need to have this part of it be reliable for everyone to buy into the fact that it's working. Thanks! Joe
View Replies !
Replication Monitor Undistributed Commands Tab
Hi, We're testen a simple lan SQL 2005 SP2 one way transactional replication config. Data is replicated ok, but in the Replication Monitor we found some strange issues: - The subscription is giving a latency warning. When we insert a tracer tocken the total latency is 5 secs. Is there a way to alter the warning level for a subscription?? - Undistributed Commands tab Changes do arrive at the client, but the distributed commands counter shows an increase in value for every (as far as we can tel succesfull) change If we do insert a tracer token -wich arrives within 5secs.- the the counter is reset to zero. thank you very much for any feedback Derk Jan
View Replies !
Replication Monitor Could Not Connect To Distributor
Hello Guys, I have the following scenario: PC1 : located in Dubai representing my laptop PC2: located in Denver , Both pcs are connected to each other via the internet as i am using Aliases ,they can both access and see each other using SQL Auth. I want to implement Merge Replication to Synchronize TestDB , I have NO DOMAIN connnecting them. I Created a new publication ,under security i asked the agent to use the Sa account to connect When launching the rep monitor i get the following error: "Replication Monitor could not connect to Distributor 'laptop'." "Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)" Both Publisher and Distributer are on my Laptop ,why cant they connect to each other? Another Question : could i implement Traditional Merge replication to synchronize my DBs or do i need to configure Web Synch in Merge rep to enable connecting via the internet?! Thanks Guys! Moodi
View Replies !
Smart Device Replication Monitor
Is there any way how to monitor Subscription to SQL Server 2005 from a smart device application? Something like MS sample application at http://msdn2.microsoft.com/fr-fr/library/ms146899.aspx Replication monitor is monitoring subscriptions, but when I replicate etc. 20 000 updates made on SQL Server to SQL Server CE on the device it returns that they were send in etc. 5 seconds, but the whole process with initialization takes 4 minutes. I dont think that this process would take 5 secs. I know there is a way how to monitor subscription from Subscriber (T-SQL, RMO) but these are for windows app not for smart device. Please help.
View Replies !
Sql2005 - Replication Monitor Issue HELP
Hello, I have setup sql 2005 transactional replication system with three machines (publisher, distributor and subscriber). Couple weeks later, publisher with publications is disconnected from replication monitor (under My Publishers €“ show X on the publisher machine name). I didn€™t change any things. Can you help for this please? Thank you for any help!!
View Replies !
How To Use TSQL To Monitor Replication Status
To monitor the status of replication in SQL 2000 we insert the resuts of sp_MShelp_replication_status into a temp table and review the status. In SQL 2005 this stored procedure has changed and now does it's own insert into execute command. Since insert execute commands can not be nested we must find another way to programically monitor replication using TSQL. We could call sys.sp_replmonitorhelppublisherhelper but we can't seem to find it in the distribution database. It must be hidden somehow. Any ideas? Thanks, Danny
View Replies !
Monitor Transactional Replication Latency
CREATE PROCEDURE [dbo].[proc_replication_latency_monitor] AS -- Procedure created by Henning Frettem (Lumbago), www.sqlteam.com, 12th of June 2008 BEGIN SET NOCOUNT ON DECLARE @PublishedDBName varchar(200), @SQL nvarchar(2000), @PublicationPK int, @PublicationName varchar(200), @PublicationDatabase varchar(200), @TracerTokenID int, @Parmameters nvarchar(500) DECLARE @Publications table ( PublicationPK int IDENTITY(1, 1) PRIMARY KEY CLUSTERED, PublicationDatabase varchar(200), PublicationName varchar(200), TracerTokenID int, TracerTokenPostTime datetime ) DECLARE @Latency table ( PublicationPK int, DistributorLatency bigint, Subscriber sysname, SubscriberDB sysname, SubscriberLatency bigint, OverallLatency bigint ) --> Cursor for fetching all publications in all databases DECLARE curPublishedDatabases CURSOR LOCAL FAST_FORWARD FOR SELECT [name] FROM sys.databases WHERE is_published > 0 OPEN curPublishedDatabases FETCH curPublishedDatabases INTO @PublishedDBName WHILE @@FETCH_STATUS = 0 BEGIN SET @SQL = N'SELECT ''' + @PublishedDBName + ''', [name] FROM ' + @PublishedDBName + '.dbo.syspublications' INSERT INTO @Publications (PublicationDatabase, PublicationName) EXEC sp_executesql @SQL FETCH NEXT FROM curPublishedDatabases INTO @PublishedDBName END CLOSE curPublishedDatabases DEALLOCATE curPublishedDatabases --> Cursor for posting tracer tokens DECLARE curPublications CURSOR LOCAL FAST_FORWARD FOR SELECT PublicationPK, PublicationDatabase, PublicationName FROM @Publications OPEN curPublications FETCH curPublications INTO @PublicationPK, @PublicationDatabase, @PublicationName WHILE @@FETCH_STATUS = 0 BEGIN SET @Parmameters = N'@PublicationName varchar(200), @TracerTokenID_OUT int OUTPUT'; SET @SQL = N'EXEC ' + @PublicationDatabase + '.sys.sp_posttracertoken @publication = @PublicationName, @tracer_token_id = @TracerTokenID_OUT OUTPUT' EXEC sp_executesql @SQL, @Parmameters, @PublicationName = @PublicationName, @TracerTokenID_OUT = @TracerTokenID OUTPUT UPDATE @Publications SET TracerTokenID = @TracerTokenID, TracerTokenPostTime = GETDATE() WHERE PublicationPK = @PublicationPK FETCH NEXT FROM curPublications INTO @PublicationPK, @PublicationDatabase, @PublicationName END CLOSE curPublications DEALLOCATE curPublications --> Wait two minutes for all tokens to be commited at all subscribers WAITFOR DELAY '000:02:00.000' --> Then check the results for each posted token DECLARE curTokens CURSOR LOCAL FAST_FORWARD FOR SELECT PublicationPK, PublicationDatabase, PublicationName, TracerTokenID FROM @Publications OPEN curTokens FETCH curTokens INTO @PublicationPK, @PublicationDatabase, @PublicationName, @TracerTokenID WHILE @@FETCH_STATUS = 0 BEGIN --> Insert token history for each token SET @SQL = N'EXEC ' + @PublicationDatabase + '.dbo.sp_helptracertokenhistory @publication = ''' + @PublicationName + ''', @tracer_id = ' + CAST(@TracerTokenID AS VARCHAR(50)) + '' INSERT INTO @Latency (DistributorLatency, Subscriber, SubscriberDB, SubscriberLatency, OverallLatency) EXEC sp_executesql @SQL --> Make sure that the PublicationPK is added to the token history UPDATE @Latency SET PublicationPK = @PublicationPK WHERE PublicationPK IS NULL --> Clean up the tracer token SET @SQL = N'EXEC ' + @PublicationDatabase + '.sys.sp_deletetracertokenhistory @publication = ''' + @PublicationName + ''', @tracer_id = ' + CAST(@TracerTokenID AS VARCHAR(50)) + '' EXEC sp_executesql @SQL FETCH NEXT FROM curTokens INTO @PublicationPK, @PublicationDatabase, @PublicationName, @TracerTokenID END CLOSE curTokens DEALLOCATE curTokens SELECT b.PublicationDatabase, b.PublicationName, a.Subscriber, a.SubscriberDB, a.OverallLatency, b.TracerTokenPostTime FROM @Latency a INNER JOIN @Publications b ON a.PublicationPK = b.PublicationPK END -- Lumbago
View Replies !
Delete Entries In Replication Monitor
Hi everybody, when I look into the replication monitor of our sql 2005 server I see a lot of subscriptions that are no longer used. I wrote a program for a smartphone using the sql compact edition (sql ce db). Just in case there are some problems i do not want to mentioned here, i use an preconfigured sql ce db, reinitialize it and afterwards synchronize it. Then the old subscription is no longer used. The problem is that up to now I did find a way to delete this unused subscriptions at the publisher database. As a hint: there is no way to get access to the old sql ce db for removement issues. The dbs are gone. So, is there a way to solve my problem? We are using sql 2005 server as publisher and are using merge replication. Thanks for help in advanced Garfield
View Replies !
Unable To See Tracer Token Tab On Replication Monitor
We are using SQL Server 2005 64 bit standard edition on both ends (subscriber distributor and publisher ) publisher is its own distributor. Now i want to investigate the replication performance and delayed in replication for this purpose i found that tracer tokens can be settedup but when i open replication monitor but unable to see tracer token tab. Plz let me know something.why i am unable to see this tab, is there some problem of rights ? , permission, or installtion.
View Replies !
Error Icon On Replication Monitor And Sub Items
Hi, Have two servers, one production server and one backup server. Both are Windows 2003 Server having SQL Server 2000 installed. I have created replication on these servers using a wizard. I then generated SQL scripts to delete and create the replication. These scripts work well, but to test to remove the replication on both servers I used sp_removedbreplication 'DBNAME' on both servers. Not all were removed and on Replication Monitor and sub items plus Log Reader Agent there were added an icon, a red 'X' as in error. The replication seems to work. Does anyone have any idea on why this happened and what I can do about it. It is not very nice to have errors in replication on a customers servers. Grateful for answers Best, /M
View Replies !
Removed Publisher Stays In Replication Monitor.
We have a publisher that got red-crossed(Run to problem). I decide to remove and recreate it. However, after remove it, the publisher still stays in Replication Monitor. The remain thing has no distributor and logreader, but only snapshot agent. When to check the property of the agent, we got a error message basically say the job does not exist, which makes sense. Now, it does not show up in any places, except Replication Monitor. Well, it cannot be removed from Replication Monitor. Can any one tell us how to clear it from Replication Monitor? Thank you. More Infor: The replication was set up on 2000.(2000 pub, 2000 dis and 2000 sub) with 2005 Management Studio, and the publication was removed with 2005 Management Studio.
View Replies !
Agents Not Appearing In Replication Monitor (SQL 2000)
During an upgrade, we had problems with PK errors on sp_MSget_repl_commands. I recreated the SP with the varbinary characteristic as we have seen in many posts and it was sucessful in starting. However, the sp now appears as a 'user' sp, not a 'system' sp, however I an not sure that is a real issue. The problem I am seeing is that none of the agents are appearing in replication monitor under their agent folders. Replication appears to be working fine and the publications are showing on the distributor in the Replication Monitor - Publication folder under the appropriate publisher. But all of the agent specific folders (i.e. Snapshot agent, distribution agent, etc) are empty. Another interesting point, is that if replication fails, the failure 'X' shows up on the Agents folder as well as the publisher, but again, no sign of the agent in the folder. Thoughts?
View Replies !
Replication Monitor Reveals Poor Performance - But What To Do To Fix It?
The client production server CPU starts thrashing. Task manager indicates that SQL server is gobbling CPU cycles. Having a look at the replication monitor, it is obvious that indivual synchronisations to the mobile devices are taking significantly longer expected. Observing an indivual synchronisation attempt, the Upload changes to Publisher rows are very quickly resolved. The Download changes to Subscriber seems to take up a very long time. Along the way, the estimated completion does a few interesting things, like going from 100% complete with no estimated time to complete, back to seomthing like 77% with 2 minutes left to complete. This sort of behaviour occurs when there are only a hundred rows to download. Synchronisations for minimal amounts of data suddenly taking anywhere from 2 to 15 minutes. Totally unacceptable form the client perspective but seems that 2005 behaves quite different from 2000 and the tricks are yet to reveal themselves. Note - It is a server hardware issue as there is in excess of 3 GB ram, the database is on a SAN and there are 4 3Ghz CPUS in operation. Any possible help appreciated as this issue is beginning to drag on.
View Replies !
Replication - Subscription
Hi, I am doing a repl.in SQL7/NT. At time of 'Push Subscription wizard' - I used the option "Yes,Initialize the schema and data......" whereas I already had data and schema at the subscriber. Now my question is what will happen now and how long will this process take(for approx5GB of DAta). OR should I stop the process - it's already an hour when I started the process. Any suggestion appreciated.
View Replies !
Replication - Subscription Inactive, Why ?
I have a snapshot & a transcation publication on Server A, and a pull subscription for each on Server B. The distribution agent on ServerA has the error: "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." Any idea what caused this ..... Everything was fine for a week or so. Does anyone know of any good books or publications on Replication ? I've got some DBA books that cover the basics, but I'd like something that helps explain the oddball situations. SQL 2K
View Replies !
Pull Subscription For Transactional Replication
I have setup a pull subscription on the subscriber for transactional replication. The distribution job continues to run, but doesn't do anything because it says: The initial snapshot for publication 'man4' is not yet available. How can I tell if the snapshot is running, and can I see the snapshot where it was created?
View Replies !
Anonymous Pull Subscription Replication
Hi, We are trying to setup replication in sql server 2000 environment.We are trying to transactional replicate across 2 sql server 2000 databases in different data centres through VPN. Is anyone aware of what ports the distribution agent uses that needs to be opened for firewall? What would be the best way to pull the initial schema and data snapshot across non trusted data centres through VPN and firewall? Your help is very much appreciated. Thanks for your time. Vivek
View Replies !
Replication Question - Updatable Subscription?
Hi all, I am planning replication around a large SQL Database Server; 3 databases need to be replicated for reporting purposes. My plan was to use Transaction Replication, as the Reporting database will be mostly read-only. However, we must add a whole bunch of additional, historical data to some of the tables of the reporting database that does not exist in the Publisher. I understand that changes can be made to subscriptions in Transaction Replication scenarios, ideally when the changes are few and far between. (Merge replication is excessive for our purposes.) I don't want the additional historical data to be propagated back to the publisher. Is it possible that data is written to a subscriber in a Transactional Replication scenario without writing these updates to the Publisher? Given the nature of the data, there will not be conflicts between the historical data and the new changes applied from the publisher. Any help would be much appreciated! Thanks, Faraz
View Replies !
Replication - Merge Vs Updateable Subscription
Does anyone have advice as choosing between merge replication and updatable subscriptions? I've read the documentaion, they seem to offer the same functionality, and I don't see any clear guidelines as to why to pick one over the other...any suggestions would be appreciated! Ed
View Replies !
Transactional Replication With UPDATEABLE SUBSCRIPTION
Hi, I've previously posted this on another forum and had no replies. Hopefully with this forum dealing with REPLICATION then I will get the answers I need. I can succesfully setup a normal Transactional Publication but when I attempt to setup a Transactional Publication with Updateable Subscriptions I get an error message. The RPC SECURITY information for the publisher is missing or Invalid I used the example for setting up users for a transactional publication from the MSDN site. Therefore I have users REPL_PUBLICATION, REPL_SNAPSHOT, REPL_LOGREADER and REPL_MERGE. The PUBLISHER is running SQL SERVER 2005 Developer. Whilst the SUBSCIBER is running SQL SERVER 2005 Express Edition. Even if I setup the SUBSCIBER on another SQL SERVER 2005 Developer I get the same message. Does anyone know how to setup this SECURITY ? Thanks Ray
View Replies !
Replication Error With Updateable Subscription
I have the following setup of sql server 2005 instances: ServerA ( developer edition, SP2 installed ), ServerB ( enterprise edition ), ServerC ( enterprise edition). All of them have the latest SP2 applied. ServerB is the publisher with a Publication of type Transaction replication with updateable subscriptions (push type). ServerA and ServerC are updateable subscribers. The subscriptions gets initialized successfully and I am able to insert/update/delete anywhere and the changes get propagated to the other 2 sites. However, serverA seems to be a problem sometimes. I have a process that runs on ServerA that applies new rows and updates other tables based on the new rows. The new rows get applied successfully. When the update runs, I get this error: Msg 20515, Level 16, State 1, Procedure sp_MSreplraiserror, Line 9 Updateable Subscriptions: Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber. Msg 20512, Level 16, State 1, Procedure sp_MSreplraiserror, Line 8 Updateable Subscriptions: Rolling back transaction. Msg 3609, Level 16, State 1, Line 1 The transaction ended in the trigger. The batch has been aborted. I know that insertion of new rows has propagated to other sites ( the publisher and the other subscriber ). I can't figure out why it thinks that the rows are out of sync. When I run the update from ServerC, it does not give any error. The latest SP2 that I applied has the fix for bugid 50000353. Maybe, its not a complete fix. or is it bcoz I have the developer edition on serverA. Any ideas ? thx, -chiraj
View Replies !
Merge Replication With Push Subscription
Vipin writes "This question for my current project regarding replication i realy new to sql server DBA ,this project about MLM ,in this they want weekly procssing for calculating each members income in their current postion in 'network'(4 matix tree style), , after processing they want take income statements for each user and also they provide income statement to each members through thier web site with member login but they only accept online registration through their web site ,'Weekly proccesing' that i said will take minimum 1 hour ,so i decide to implement merge replication ,but went through web i didn't get clear solution , normaly i connect sql server in web hosting meachine through Client Network Utility with TCP/IP protocol ,i decide to configre local meachine's sql server instance as publisher and distributer ,web hosting meachine's as subscriber using merge replication with push subscription, please tel how i can implement this solution i have no idea about this so tel with example, steps and also requrements what is your opinion about this solution,if it is bad solution or there other better solution and also tel how i can apply this too."
View Replies !
Merge Replication - Uninitialized Subscription
I have created a Merge Subscription between two databases. I have set the security setting in the UNC folder of the publisher to allow 'Full Control' for 'Everyone'. I have done various searches, google, here, etc. But cant seem to find much information to help me out. When I create the subscription it says it was a success, but when I launch the replication monitor and click the publication it says its subscribers are uninitialized. Can anyone help? Cheers
View Replies !
Disappearing Parameterised Filters And Filter Joins In Publication Properties Page Of Replication Monitor
Hi, We have an issue with our replication configuration when viewed through replication monitor. Parameterised Filters and joined filters don't appear in the gui. However, when we script the publication all the filters are present. This issue only seems to occur when we have a remote distributor. I should also point out that we have a merge push topology that uses a custom RMO synchronisation component on a separate server to either the publisher or the distributor. Also all the databases in the topology are called the same name. This has caused us other issues relating to this topology in particular so I raise it here as well although I don't expect it to be the case in this instance. Any help would be greatly appreciated in clarifying this matter.
View Replies !
Merge Replication Through Internet , Cannot Update Subscription
i'm trying to replicate data between two servers on internet using Merge Replication. My server(sql server 7.0) is publisher and distributor and i'm using push subscription. i'm getting error - 'the merge process could not update the list of subscriptions' , full error detail is - 'Only members of the sysadmin role may set server options.' pls help me to resolve the problem. thanks sumit sumitj@ebotsoft.com
View Replies !
Replication Error: "21074: Subscription Expired..."
Our replication worked well for weeks and suddendly we got the error message 21074: The subscription has expired and must be reinitialized at the publisher The strange thing is: we did NOT gave any expiration date (at least to our knowledge). After Re-Initialization we got a follow-up error 21075: The initial snapshot for publication xyz is not yet available What'S going wrong here? Ricardo Beck
View Replies !
SQL Server Replication Push Subscription Issues
Hi There, I wonder if anyone has run into this problem before. I have inherited a SQL Server 2000 box with what appears to be a push subscription set up on it. However, the original Subscription database has long since been removed, leaving that box with what is essentially an orphaned push subscription. We are trying to remove the subscription, but do not understand how. All documentation I have found keeps insisting that this be done at the subscriber database (which is for all effective purposes, destroyed). How do I get rid of it? Any ideas would be dearly appreciated. Thanks.
View Replies !
Trigger In The Subscription Database - Transactional Replication...
Hi, We are Using Transactional Replication with Updatable Subscription in SQL Server 2005 SP1. Subscription Type : Pull Subscription Mode : Continuous Running Mode Conflict Resolution Policy : Publisher Wins. I have a table "Sample" (which is part of replication) and it has got 3 triggers. All the triggers are set NOT FOR REPLICATION. The first trigger Updates a column of the "Sample" table in which i inserted a record. The second trigger inserts record in to another database table and also updates a column of the table "Sample". The third trigger does not affect any tables, it is written for some manipulations with variables. In this scenario when I insert a record in the Sample table of the subscription database, that record is visible in the table. But during replication, it shows conflict in the Conflict Viewer and removes the record from the Sample table of the subscription database. The record is not replicated to the publisher and the other Subscriber also. But when I comment any one update in either the first or second trigger, the insert works fine without any conflict. Is there any issue with firing two triggers in replication which is updating the same table? I also suspect the Order of Commands moving to the Publisher from the MSReplication_Queue table, becoz the conflict viewer shows the subscriber as the Conflict loser. Is there any issue with msrepl_tran_version, Since the conflict is decided based on this id?? It would be helpful if u could reply soon. Thanks and Regards, Swapna.B.
View Replies !
|
TRACKER
