318075 - Merge Agent Error

Mario,
there is a fix available, but you'll need to contact PSS to get hold of it:
http://support.microsoft.com/default...EN-US;CNTACTMS
Regards,
Paul Ibison
Is it free ?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23m5nFqbPEHA.2256@.TK2MSFTNGP10.phx.gbl...
> Mario,
> there is a fix available, but you'll need to contact PSS to get hold of
it:
> http://support.microsoft.com/default...EN-US;CNTACTMS
> Regards,
> Paul Ibison
>
|||I haven't requested any fixes, but my colleague regularly receives Win 2003
fixes for free and she's never once had to pay. If you ring up MS there's no
obligation so you might as well just give them a call. If you call them,
please could you post back to let us know for sure.
Regards,
Paul Ibison
|||I am not sure what fix we are referring ot but if it is a post sp3a fix it
might be included in build 818. MS03-031 Security Bulletin. If it is a
build prior to build 818 you can downlad the MS03-031 and get the fix there.
http://www.microsoft.com/downloads/d...e9d-bd44-40c5-
add3-b8c99618e68d&DisplayLang=en
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||It's a post 818.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:tgkUwmnPEHA.3664@.cpmsftngxa10.phx.gbl...
> I am not sure what fix we are referring ot but if it is a post sp3a fix it
> might be included in build 818. MS03-031 Security Bulletin. If it is a
> build prior to build 818 you can downlad the MS03-031 and get the fix
there.
>
http://www.microsoft.com/downloads/d...e9d-bd44-40c5-
> add3-b8c99618e68d&DisplayLang=en
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

3 tier merge replication problem

I have a 3 tier merge replication architecture that I am having some problems making changes to. We have a 3 tier architecture with many laptop instances on the bottom tier. It is exceedingly hard to coordinate having all laptop instances online simultaneously during non business hours with users present for local administration. The requirement is to change the name of the top tier without effecting the replication from the middle to bottom tiers.
I have so far renamed the top tier's instance, reconfigured publication, created a new top tier publication, and a new middle tier subscription. The top tier article has been set to delete all data in the subscriber's table when applying the snapshot. Making data changes at the middle tier filters correctly to both the top and bottom tiers. However, any changes made at the top or bottom tiers filter to the middle tier but no further. At that point, there are no errors, but simply no data needing to be merged.
Does anyone know how dropping and recreating a top tier publication could cause a 3 tiered replication architecture to behave like this? Is there any solution short of having to recreate subscriptions on all the bottom tier laptops?

check if there is some data to be merged in MS_mergecontents , and evn MSmerge_tombstone , if u find data in there , it shud merge..do a manual syncronize at the subscriber, if it dosent work , try reinitializing the subscription if thats feasible..|||so, I recreate the top tier publication and subscription, create a snapshot, synchronize the middle tier, create a middle tier snapshot, synchronize the bottom tier. At that point, I add a row to a replicated table on the top tier, synchronize the middle tier, and synchronize the bottom tier. As I stated, the data never makes it past the middle tier. The row guid appears in msmerge_contents and msmerge_genhistory on both the top and middle tiers. The bottom tier, however, never receives the data. Any ideas where I can go from here?|||

Can you verify the the subscriber in the middle tier is a "global" subscriber?

select * from sysmergesubscriptions, and look at the value in column subscriber_type, check if it has value of 1.

|||the subscriber_type is 1 for the middle tier subscription to the top tier publication.|||Additionally, the middle tier subscriber passes data validation, whereas the bottom tier subscriber fails data validation.sql

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

29006 SQL SERVER ERROR

HI, I'm getting this error on a merge subscription between SQL SERVER
2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
1. A call to SQL Server reconciler failed. 29006
2. The process could not log conflict information.
3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
4. Datetime field overflow
Any Idea?
Thanks,
Yllen
Is this a custom resolver? If not can you enable logging and post the
complete log 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
"Yllen" <yguevara@.gmail.com> wrote in message
news:1126629526.156630.85200@.g47g2000cwa.googlegro ups.com...
> HI, I'm getting this error on a merge subscription between SQL SERVER
> 2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
> 1. A call to SQL Server reconciler failed. 29006
> 2. The process could not log conflict information.
> 3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
> 4. Datetime field overflow
> Any Idea?
> Thanks,
>
> Yllen
>

2006/06/26 15:49:32 Hr=80004005 ERR:OpenDB failed getting pub version 28627

Dear Sirs. I Have a Pc were i have made the development, where i have sql 2005, sql server mobile etc. I have made a program with a merge replication. It works fine on lan using wireless. I have maped a public ip address opened the tcp 80 port and doing nat to the pc. I able to do the http://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, it ask for authentication, and after display's the "sql server mobile server agent 3.0". but when i ran the aplication (it sync's ok on a wireless lan, only changing the ip address to the public address) it apears : Failure to connect to SQL Server with provided connection information. SQL Server4 does not exist, access is denied because the IIS user is not a valid user on the SQL server, or the password is incorrect"

Thanks .

Paulo Costa

Is this public IP a different machine? If so, it authenticaion mode needs to be set and your application needs to use that approprate authentication mode. Additionally the credentials you use in your application need to be trusted and/or validated by this IIS machine. Please verify that you are doing this and reply back if you still have issues.

2005 merge replication and database compatibility level setting

Does the database compatibility level setting affect merge replication
performance on 2005?
Thanks.
Yes, but how much is depends on the switches you use. Have a look at this
white paper to see what the improvements could be.
http://www.microsoft.com/technet/pro.../mergrepl.mspx
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Brett" <johbrett@.gmail.com> wrote in message
news:eT0uaMHSGHA.3192@.TK2MSFTNGP09.phx.gbl...
> Does the database compatibility level setting affect merge replication
> performance on 2005?
>
> Thanks.
>
|||Thanks for the reference.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uFCQOIPSGHA.4384@.tk2msftngp13.phx.gbl...
> Yes, but how much is depends on the switches you use. Have a look at this
> white paper to see what the improvements could be.
> http://www.microsoft.com/technet/pro.../mergrepl.mspx
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Brett" <johbrett@.gmail.com> wrote in message
> news:eT0uaMHSGHA.3192@.TK2MSFTNGP09.phx.gbl...
>

2005 Merge Agent Degradation

I have a merge agent running extremely slow - schedule fires every 1 minute,
however it takes 1 to 3 minutes to execute. Delivery Rate 5 rows/sec or less,
all 5 other merge agents execute in less than 20 seconds and Delivery Rate 80
rows/sec or greater.
Each time merge agent fires, subscr cpu spikes to 85% - normally 15 to 20%.
Ran profiler and discovered this stamement below hogging the cpu and having
the longest duration.
I am rebuilding the MSmerge_genhistory table nightly w/ the following: DBCC
DBREINDEX (MSmerge_genhistory, '', 80)
Any ideas? A re-init will resolve problem , have had to do this many times
in past - at least every 30 days... however, want to get to root cause. tia
Chris
select top (@.numgens) *
from
(
select generation, guidsrc, art_nick,
case when genstatus = 4 then 0 else genstatus end as
genstatus,
pubid, nicknames,
okaytoskip = case when
art_nick is not null and art_nick <> 0
and genstatus in (0,4)
-- Skip all rows that are for incomplete
generations for articles that have no joins.
and not exists (select 1 from
dbo.sysmergesubsetfilters where (join_nickname = art_nick or art_nickname =
art_nick) and (filter_type & 1) = 1)
then 1 else 0 end
, changecount
from
(select generation, guidsrc, art_nick, genstatus, pubid,
nicknames, changecount
from dbo.MSmerge_genhistory with (rowlock, repeatableread)
where generation >= @.genstart
and generation <= @.maxgen_to_enumerate
and generation > @.mingen_to_enumerate
and (art_nick = 0 or art_nick is NULL or
art_nick in (select nickname from dbo.sysmergearticles
where pubid = @.pubid))
) as generation_range
UNION ALL -- use UNION ALL instead of UNION for perf
reasons. Merge agent code will skip dupes. Will only have max 2 dupes.
select generation = @.next_possible_watermark, guidsrc =
@.next_possible_watermark_guidsrc,
art_nick = @.next_possible_watermark_art_nick, genstatus =
@.next_possible_watermark_genstatus,
pubid = @.next_possible_watermark_pubid, nicknames =
@.next_possible_watermark_nicknames,
okaytoskip = 0, changecount =
@.next_possible_watermark_changecount
where @.next_possible_watermark is not null
union all
select generation = @.min_open_gen, guidsrc= @.min_open_gen_guid,
art_nick=@.min_open_gen_art_nick, genstatus=0,
pubid=@.pubid, nicknames=NULL, okaytoskip = 0,
changecount=0
where @.min_open_gen is not null
) as genertions
order by generation ASC
Two things I can suggest here is:
1. Avoid metadata contention. Make sure merge agents do not run at the
same time so stagger their schedules.
2. Retention period can cause lots of data to be stored in the contets
and tombstone tables. Default i think is 14 days. So 14 days worth of
changes are stored. Consider reducing this if subscribers are not
offline for a long time.
Regards Jim
http://jims-spanakopita.blogspot.com/
|||What do your join filters look like? By placing indexes on all the filters
you will get better performance. Another option to try is to modify your
filters to make them as shallow as possible.
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
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4ED9E8B8-9CA1-4B10-A609-E67921202C68@.microsoft.com...
> I have a merge agent running extremely slow - schedule fires every 1
> minute,
> however it takes 1 to 3 minutes to execute. Delivery Rate 5 rows/sec or
> less,
> all 5 other merge agents execute in less than 20 seconds and Delivery Rate
> 80
> rows/sec or greater.
> Each time merge agent fires, subscr cpu spikes to 85% - normally 15 to
> 20%.
> Ran profiler and discovered this stamement below hogging the cpu and
> having
> the longest duration.
> I am rebuilding the MSmerge_genhistory table nightly w/ the following:
> DBCC
> DBREINDEX (MSmerge_genhistory, '', 80)
>
> Any ideas? A re-init will resolve problem , have had to do this many times
> in past - at least every 30 days... however, want to get to root cause.
> tia
> Chris
>
> select top (@.numgens) *
> from
> (
> select generation, guidsrc, art_nick,
> case when genstatus = 4 then 0 else genstatus end as
> genstatus,
> pubid, nicknames,
> okaytoskip = case when
> art_nick is not null and art_nick <> 0
> and genstatus in (0,4)
> -- Skip all rows that are for incomplete
> generations for articles that have no joins.
> and not exists (select 1 from
> dbo.sysmergesubsetfilters where (join_nickname = art_nick or art_nickname
> =
> art_nick) and (filter_type & 1) = 1)
> then 1 else 0 end
> , changecount
> from
> (select generation, guidsrc, art_nick, genstatus, pubid,
> nicknames, changecount
> from dbo.MSmerge_genhistory with (rowlock, repeatableread)
> where generation >= @.genstart
> and generation <= @.maxgen_to_enumerate
> and generation > @.mingen_to_enumerate
> and (art_nick = 0 or art_nick is NULL or
> art_nick in (select nickname from dbo.sysmergearticles
> where pubid = @.pubid))
> ) as generation_range
> UNION ALL -- use UNION ALL instead of UNION for perf
> reasons. Merge agent code will skip dupes. Will only have max 2 dupes.
> select generation = @.next_possible_watermark, guidsrc =
> @.next_possible_watermark_guidsrc,
> art_nick = @.next_possible_watermark_art_nick, genstatus =
> @.next_possible_watermark_genstatus,
> pubid = @.next_possible_watermark_pubid, nicknames =
> @.next_possible_watermark_nicknames,
> okaytoskip = 0, changecount =
> @.next_possible_watermark_changecount
> where @.next_possible_watermark is not null
> union all
> select generation = @.min_open_gen, guidsrc= @.min_open_gen_guid,
> art_nick=@.min_open_gen_art_nick, genstatus=0,
> pubid=@.pubid, nicknames=NULL, okaytoskip = 0,
> changecount=0
> where @.min_open_gen is not null
> ) as genertions
> order by generation ASC
>