Hello Group,
(I have posted this query in Microsoft Newsgroup also, but I did not get any response. Please respond. Thanx)
I have setup a Merge Replication between two
servers. (SERVER_PUBLISH is the Publisher and
SERVER_SUBSCRIBE is the Subscriber).
I was periodically getting Network errors, I tried looping
step 3 (both on success and failure) of the job back to
step 1. I have also given a higher number of retry
attempts and interval, but still at times I get this error
(mentioned below) and my replication stops. Is there a
way to automatically resume replication after such errors
occurs.
Please Help. This is very urgent.
Thanks in advance
Anand
Part of the error log is mentioned below =>
Downloading data changes to the Subscriber
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Uploading data changes to the Publisher
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Downloading data changes to the Subscriber
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Uploading data changes to the Publisher
The merge process could not apply the replication metadata.
The process could not enumerate changes at
the 'Subscriber'.
The process could not enumerate changes at
the 'Subscriber'.
The merge process encountered an unexpected network error.
The connection to Subscriber 'SERVER_SUBSCRIBE' is no
longer available.
Percent Complete: 0
The merge process could not apply the replication metadata.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147200968
Message: The merge process could not apply the replication
metadata.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSproxiedmetadata(?,?,?,?)}{call
sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
(?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}{call
sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
(?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}
Percent Complete: 0
Category:SQLSERVER
Source: SERVER_SUBSCRIBE
Number: 11
Message: General network error. Check your network
documentation.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147199469
Message: The process was successfully stopped.
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Distributor 'SERVER_PUBLISH'Try setting up the Merge Agent to run on a schedule of every one minute. That way, it will start up again even if it has failed. Also, please do not say your request is "urgent". All of us that ask for help feel our requests are "urgent".
Showing posts with label newsgroup. Show all posts
Showing posts with label newsgroup. Show all posts
Wednesday, March 21, 2012
Monday, March 12, 2012
Merge Replication is Broken
I have scanned this newsgroup for similar postings, but came up empty.
My problem is this: I had set up merge replication between SQL Server
2000 (publisher) and several MSDE SP3 subscribers. This was working
until a week ago, but now nothing replicates.
Symptoms:
The merge agents in EM all say they are merging successfully with a
status of "No data needed to be merged". The problem is that there
is plenty of data that has changed since the last replication and none
of it is merging. I tried forcing replication to occur by starting the
snapshot agents. The merge agents are all scheduled to run every 5
minutes.
What Might Have Happened:
In the Replication\Subscriptions folder for my server, there is a
subscription that shouldn't be there. It is a Transactional
subscription. The subscriber and publisher are the same server, which
shouldn't happen. It has an error message of "Cannot drop the
table 'LocateType' because it is being used for replication".
I have done everything I can think of to remove this subscription. It
does not show up in any of the agents folders, and I have even removed
the server from the enabled subscribers list and rebooted the server.
However I still have this ghost subscription and replication still
fails to merge any changes.
Any help is greatly appreciated.
try issuing sp_MSdummyupdate to see if this generates data flow.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MillsPerry" <mperry@.wpsr.com> wrote in message
news:1117634332.031233.320780@.g14g2000cwa.googlegr oups.com...
> I have scanned this newsgroup for similar postings, but came up empty.
> My problem is this: I had set up merge replication between SQL Server
> 2000 (publisher) and several MSDE SP3 subscribers. This was working
> until a week ago, but now nothing replicates.
> Symptoms:
> The merge agents in EM all say they are merging successfully with a
> status of "No data needed to be merged". The problem is that there
> is plenty of data that has changed since the last replication and none
> of it is merging. I tried forcing replication to occur by starting the
> snapshot agents. The merge agents are all scheduled to run every 5
> minutes.
> What Might Have Happened:
> In the Replication\Subscriptions folder for my server, there is a
> subscription that shouldn't be there. It is a Transactional
> subscription. The subscriber and publisher are the same server, which
> shouldn't happen. It has an error message of "Cannot drop the
> table 'LocateType' because it is being used for replication".
> I have done everything I can think of to remove this subscription. It
> does not show up in any of the agents folders, and I have even removed
> the server from the enabled subscribers list and rebooted the server.
> However I still have this ghost subscription and replication still
> fails to merge any changes.
> Any help is greatly appreciated.
>
|||Hi Hilary,
A search of the SQL Server BOL did not find any references to this
procedure. Could you give me a brief rundown on what parameters it
expects?
I tried guessing on the settings for @.rowguid and @.tablenick without
success. Is rowguid a guid associated with a record on the table I am
trying to replicate? If so then does it matter which record? And is
tablenick the name of that table or is it something else?
use OCTAVE
go
exec sp_MSdummyupdate @.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B',
@.tablenick='TicketInfo'
Thanks!
|||sorry wrong proc
try
http://msdn.microsoft.com/library/de...repl3_7r6t.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MillsPerry" <mperry@.wpsr.com> wrote in message
news:1117653529.794501.20690@.o13g2000cwo.googlegro ups.com...
> Hi Hilary,
> A search of the SQL Server BOL did not find any references to this
> procedure. Could you give me a brief rundown on what parameters it
> expects?
> I tried guessing on the settings for @.rowguid and @.tablenick without
> success. Is rowguid a guid associated with a record on the table I am
> trying to replicate? If so then does it matter which record? And is
> tablenick the name of that table or is it something else?
> use OCTAVE
> go
> exec sp_MSdummyupdate @.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B',
> @.tablenick='TicketInfo'
> Thanks!
>
|||Hilary,
>From the documentation, I assume that parameter @.source_object is the
name of the table I am trying to replicate, and @.rowguid is the rowguid
of the record I am trying to replicate. I ran this script:
use OCTAVE
go
exec sp_mergedummyupdate @.source_object='dbo.TicketInfo',
@.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B'
And got this result back:
Server: Msg 20003, Level 11, State 1, Procedure sp_mergedummyupdate,
Line 24
Could not generate nickname for 'TicketInfo'.
Needless to say, nothing replicated.
|||Hilary,
After sp_mergedummyupdate failed for not finding table 'TicketInfo's
nickname, I did a little more digging.
The nickname is retrieved through sp_MStablenickname, which reads
tables sysmergearticles and sysobjects.
I looked at sysmergearticles and found it empty when there should have
been two articles in it. I then checked the publication properties and
found that my articles were all dropped. After recreating them and
regenerating the snapshots, replication resumed.
Thanks for your help!
My problem is this: I had set up merge replication between SQL Server
2000 (publisher) and several MSDE SP3 subscribers. This was working
until a week ago, but now nothing replicates.
Symptoms:
The merge agents in EM all say they are merging successfully with a
status of "No data needed to be merged". The problem is that there
is plenty of data that has changed since the last replication and none
of it is merging. I tried forcing replication to occur by starting the
snapshot agents. The merge agents are all scheduled to run every 5
minutes.
What Might Have Happened:
In the Replication\Subscriptions folder for my server, there is a
subscription that shouldn't be there. It is a Transactional
subscription. The subscriber and publisher are the same server, which
shouldn't happen. It has an error message of "Cannot drop the
table 'LocateType' because it is being used for replication".
I have done everything I can think of to remove this subscription. It
does not show up in any of the agents folders, and I have even removed
the server from the enabled subscribers list and rebooted the server.
However I still have this ghost subscription and replication still
fails to merge any changes.
Any help is greatly appreciated.
try issuing sp_MSdummyupdate to see if this generates data flow.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MillsPerry" <mperry@.wpsr.com> wrote in message
news:1117634332.031233.320780@.g14g2000cwa.googlegr oups.com...
> I have scanned this newsgroup for similar postings, but came up empty.
> My problem is this: I had set up merge replication between SQL Server
> 2000 (publisher) and several MSDE SP3 subscribers. This was working
> until a week ago, but now nothing replicates.
> Symptoms:
> The merge agents in EM all say they are merging successfully with a
> status of "No data needed to be merged". The problem is that there
> is plenty of data that has changed since the last replication and none
> of it is merging. I tried forcing replication to occur by starting the
> snapshot agents. The merge agents are all scheduled to run every 5
> minutes.
> What Might Have Happened:
> In the Replication\Subscriptions folder for my server, there is a
> subscription that shouldn't be there. It is a Transactional
> subscription. The subscriber and publisher are the same server, which
> shouldn't happen. It has an error message of "Cannot drop the
> table 'LocateType' because it is being used for replication".
> I have done everything I can think of to remove this subscription. It
> does not show up in any of the agents folders, and I have even removed
> the server from the enabled subscribers list and rebooted the server.
> However I still have this ghost subscription and replication still
> fails to merge any changes.
> Any help is greatly appreciated.
>
|||Hi Hilary,
A search of the SQL Server BOL did not find any references to this
procedure. Could you give me a brief rundown on what parameters it
expects?
I tried guessing on the settings for @.rowguid and @.tablenick without
success. Is rowguid a guid associated with a record on the table I am
trying to replicate? If so then does it matter which record? And is
tablenick the name of that table or is it something else?
use OCTAVE
go
exec sp_MSdummyupdate @.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B',
@.tablenick='TicketInfo'
Thanks!
|||sorry wrong proc
try
http://msdn.microsoft.com/library/de...repl3_7r6t.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MillsPerry" <mperry@.wpsr.com> wrote in message
news:1117653529.794501.20690@.o13g2000cwo.googlegro ups.com...
> Hi Hilary,
> A search of the SQL Server BOL did not find any references to this
> procedure. Could you give me a brief rundown on what parameters it
> expects?
> I tried guessing on the settings for @.rowguid and @.tablenick without
> success. Is rowguid a guid associated with a record on the table I am
> trying to replicate? If so then does it matter which record? And is
> tablenick the name of that table or is it something else?
> use OCTAVE
> go
> exec sp_MSdummyupdate @.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B',
> @.tablenick='TicketInfo'
> Thanks!
>
|||Hilary,
>From the documentation, I assume that parameter @.source_object is the
name of the table I am trying to replicate, and @.rowguid is the rowguid
of the record I am trying to replicate. I ran this script:
use OCTAVE
go
exec sp_mergedummyupdate @.source_object='dbo.TicketInfo',
@.rowguid='DDDCAB2C-5C0B-4AFD-9811-064967C4036B'
And got this result back:
Server: Msg 20003, Level 11, State 1, Procedure sp_mergedummyupdate,
Line 24
Could not generate nickname for 'TicketInfo'.
Needless to say, nothing replicated.
|||Hilary,
After sp_mergedummyupdate failed for not finding table 'TicketInfo's
nickname, I did a little more digging.
The nickname is retrieved through sp_MStablenickname, which reads
tables sysmergearticles and sysobjects.
I looked at sysmergearticles and found it empty when there should have
been two articles in it. I then checked the publication properties and
found that my articles were all dropped. After recreating them and
regenerating the snapshots, replication resumed.
Thanks for your help!
Subscribe to:
Posts (Atom)