merge replication metedata cleanup error

Hi,

We have a merge subscription which is reporting the following error at the subscriber:

The Merge Agent failed after detecting the retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet set to the Subscriber. You must reinitalize the subscription (without upload)

I'm a bit confused about this - there have been no changes made at the publisher - why would we be getting this message?

thanks
Bruce

The data changes that the merge agent is referring to are the metadata contained in the merge tables MSmerge_contents, MSmerge_tombstone, MSmerge_genhistory. Periodically this data needs to be purged otherwise it starts to impact performance.

If the retention period is passed the subscription will expire as the meta data will be removed. You will need to reinitialize the subscription. Here is some more information about setting the retention period.

http://msdn2.microsoft.com/en-us/library(d=robot)/ms151188.aspx

Thanks

Nabila Lacey

Merge Replication Failed - Urgent Please

I have two databases A & B which have a merge replication between them. Both are live data. I wanted to alter table in db A, so i deleted subscription and altered the table from db A. After that i rebuilt the replication between A & B with initialization but now my replication fails. Every time i get different error messages..recently i get message of 'Subscriber failed to initialize'. Could anyone suggest how to resolve this? Urgent please.

Hello,

Which one is the subscriber, A or B?

What kind of alter table did you perform, such as add/drop column or change the definition of the table?

After the ALTER TABLE, the table schema is different from each other, right?

When the replication was rebuilt, was it a pull subscription or push subscription?

Thanks.

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

|||A is the publisher and B is the subscriber. I alter the table with increasing the datatype width from 9-50 varchar. After update the schema of A is different from each other. Replication is push from publisher.|||

Try this -

Alter the table on A back to what it was.

Set up the replication with NoSync scenario, as @.sync_type = 'NONE' in the sp_addmergesubscription (see http://msdn2.microsoft.com/en-us/library/ms187717.aspx).

Make a dummy sync.

Alter table again on A to increasing the width of the desired datatype

Sync again.

Thanks,

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

Merge Replication Error - Failed to enumerate changes in the filtered article

Hi,
I am using Merge Replication and have filtered some of the tables for teh
subscriptions, however, everything was working fine, then all of a sudden, I
get this error. (See below)
Does anyone know what would cause this and how I can overcome it?
Thanks in Advance
Warren
************************************************** *
******************ERROR DETAILS******************
************************************************** *
Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
Error Message: Failed to enumerate changes in the filtered articles.
Error Details:
Failed to enumerate changes in the filtered articles.
(Source: Merge Replication Provider (Agent); Error number: -2147200925)
Incorrect syntax near the keyword 'where'.
(Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
Incorrect syntax near the keyword 'and'.
(Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
************************************************** *
*******************END OF ERROR******************
************************************************** *
Could you provide more information on your database and replication filters
?
Are replicated objects owned by dbo ?
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:O%23o3zZrKFHA.2640@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using Merge Replication and have filtered some of the tables for teh
> subscriptions, however, everything was working fine, then all of a sudden,
I
> get this error. (See below)
> Does anyone know what would cause this and how I can overcome it?
> Thanks in Advance
> Warren
> ************************************************** *
> ******************ERROR DETAILS******************
> ************************************************** *
> Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
> Error Message: Failed to enumerate changes in the filtered articles.
> Error Details:
> Failed to enumerate changes in the filtered articles.
> (Source: Merge Replication Provider (Agent); Error number: -2147200925)
> ----
--
> --
> Incorrect syntax near the keyword 'where'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> ----
--
> --
> Incorrect syntax near the keyword 'and'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> ----
--
> --
> ************************************************** *
> *******************END OF ERROR******************
> ************************************************** *
>
|||Hi,
Thanks for your reply.
The objects are owned by DBO.
We are using Merge replication will pull subscriber.
Some tables are filtered, in the publication properties, if I go to FILTER
ROWS, then FILTER CLAUSE column, some tables are filtered like so
depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx'
where x makes up the guid.
is that enough information? what else do you need?
Many thanks
"Kestas" <kicker.lt@.noospamm-tut.by> wrote in message
news:%232ddCNsKFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Could you provide more information on your database and replication
filters[vbcol=seagreen]
> ?
> Are replicated objects owned by dbo ?
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:O%23o3zZrKFHA.2640@.TK2MSFTNGP09.phx.gbl...
teh[vbcol=seagreen]
sudden,
> I
> ----
> --
> ----
> --
> ----
> --
>
|||Also would be good to know which exact SQL Server version you are runing
SELECT @.@.VERSION
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:%23nEFf6uKFHA.1280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Thanks for your reply.
> The objects are owned by DBO.
> We are using Merge replication will pull subscriber.
> Some tables are filtered, in the publication properties, if I go to FILTER
> ROWS, then FILTER CLAUSE column, some tables are filtered like so
> depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx'
> where x makes up the guid.
> is that enough information? what else do you need?
> Many thanks
|||Hi,
Publisher:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
Subscriber:
MSDE
Kind Regards
Warren
"Kestutis Adomavicius" <kicker.lt@.noospamm-tut.by> wrote in message
news:um0A7yvKFHA.3960@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Also would be good to know which exact SQL Server version you are runing
> SELECT @.@.VERSION
> --
> Regards,
> Kestutis Adomavicius
> Consultant
> UAB "Baltic Software Solutions"
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:%23nEFf6uKFHA.1280@.TK2MSFTNGP09.phx.gbl...
FILTER
>
|||Anyone have any ideas?
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:uZZOIA4KFHA.2860@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Publisher:
> --
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
> Subscriber:
> --
> MSDE
>
> Kind Regards
> Warren
>
> "Kestutis Adomavicius" <kicker.lt@.noospamm-tut.by> wrote in message
> news:um0A7yvKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> FILTER
>
|||can you post your schema and publication script here?
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
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:uj$i292LFHA.4080@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Anyone have any ideas?
>
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:uZZOIA4KFHA.2860@.TK2MSFTNGP10.phx.gbl...
runing
>
|||Hi Hilary,
By publication script, I assume you mean the script to create the
publication (right-click publication --> Generate SQL Script)?
And the schema? Do you want the published databases schema?
can you advise,
thanks
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%2317MDe6LFHA.3988@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> can you post your schema and publication script here?
> --
> 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
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:uj$i292LFHA.4080@.TK2MSFTNGP10.phx.gbl...
> runing
to
>
|||Anyone able to help on this?
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:OGkKj9FMFHA.3420@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi Hilary,
> By publication script, I assume you mean the script to create the
> publication (right-click publication --> Generate SQL Script)?
> And the schema? Do you want the published databases schema?
> can you advise,
> thanks
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%2317MDe6LFHA.3988@.tk2msftngp13.phx.gbl...
> to
so
>

Merge Replication Error

Replication-Replication Merge Subsystem: agent TRPSQL3-ThomsonResearch-TR Pub-TRPSQL2-4 failed. The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history log

I am getting the above error in Merge Replication. any one having any idea pls let me know.

Thanks & Regards,

Kasi.

Can you edit the merge agent job step by adding a couple of parameters?

-OutputVerboseLevel 2 -Output your-file-name

Then run the merge agent job again and look the error details in the output file.

Merge Replication Error

Dear Friends
I am getting the following error for the Merge
replication.
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
(Source: SERVER (Data source); Error number: 18452)
The process could not connect to Subscriber 'SERVER'.
(Source: SERVER (Agent); Error number: 20084)
----
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
(Source: SERVER (Data source); Error number: 18452)
----
I can connect to the Server with Enterprise manager and
also with OSQL. Please suggest what can be the problem.
Best regards
Sharad
Your sql server agent is runing using the defaulot system account you have
to make a user in sql server and assign this user to load sqlserver agents.
do this to both the server so that the agent of publisher can connect to
agent of subscriber.
regards
Kashif
"Sharad" <Niitmalad@.yahoo.co.in> wrote in message
news:1f8901c5103b$460dc6b0$a601280a@.phx.gbl...
> Dear Friends
> I am getting the following error for the Merge
> replication.
> Login failed for user '(null)'. Reason: Not associated
> with a trusted SQL Server connection.
> (Source: SERVER (Data source); Error number: 18452)
> The process could not connect to Subscriber 'SERVER'.
> (Source: SERVER (Agent); Error number: 20084)
> ----
> ----
> Login failed for user '(null)'. Reason: Not associated
> with a trusted SQL Server connection.
> (Source: SERVER (Data source); Error number: 18452)
> ----
> ----
> I can connect to the Server with Enterprise manager and
> also with OSQL. Please suggest what can be the problem.
> Best regards
> Sharad
|||Dear Kashif
Thanks for your quick reply. Kindly suggest if i have
diffrent domains then how the same problem can be solved.
Best regards
Sharad

>--Original Message--
>Your sql server agent is runing using the defaulot
system account you have
>to make a user in sql server and assign this user to
load sqlserver agents.
>do this to both the server so that the agent of
publisher can connect to[vbcol=seagreen]
>agent of subscriber.
>regards
>Kashif
>
>"Sharad" <Niitmalad@.yahoo.co.in> wrote in message
>news:1f8901c5103b$460dc6b0$a601280a@.phx.gbl...
--[vbcol=seagreen]
--
>
>.
>

Merge Replication Error

Replication-Replication Merge Subsystem: agent TRPSQL3-ThomsonResearch-TR Pub-TRPSQL2-4 failed. The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history log

I am getting the above error in Merge Replication. any one having any idea pls let me know.

Thanks & Regards,

Kasi.

Can you edit the merge agent job step by adding a couple of parameters?

-OutputVerboseLevel 2 -Output your-file-name

Then run the merge agent job again and look the error details in the output file.