Merge seems to hang at conflict and conflict is not logged

We have a SQL2005 merge replication database with 8 subscribers. Three of the
subscribers have not successfully replicated. We would appreciate any
additional ideas for correcting this. So far we have some inconsistencies.
For example, the "View Synchronization Status" displays:
"Downloaded 100 change(s) in 'OurTable' (100 updates, 1 conflict)"
and the publisher's "Microsoft Replication Conflict Viewer" displays:
"There are no conflicts to view."
If you have any ideas why conflicts are causing the replication to fail
while the conflict viewer shows no conflicts, we would appreciate your input.
Thanx.
Were there any conflicts on the subscriber side?
You can run the conflict viewer there as well, or if that's not
convenient/possible there are sp_xxx procedures to help you view the
conflict tables on the client...

Merge Replication Issues

Hello All,
I would greatly appreciate some help on this issue. I am very stuck and
struggling.
Basicall I have a SQL 2000 Server, that is the publisher for a merge
replication. This merge replication, is to replicate to handhelds, that via
a mobile application, insert into the tables. The handhelds seem to be
operating fine. The publisher is not however. When I try and insert records
into the tables via web interface, I keep getting:
The identity range managed by replication is full and must be updated by a
replication agent.
So I've read for hours online searching for this issue, tons of people have
hit it, but nobody has a solid answer. Most people just hack crap together
that works, or sometimes works.
Basically how I configured it in the beginning was, each subscriber, and
publisher got 200 identities, using automatic identity range management.
Then the website started to hit problems. So I read some articles, some
people said to set the identity ranges to something high that may never get
hit. So I changed them to 60,000. This doesn't seem to work either. Every
day now, sometimes twice a day, I'm getting range is full errors.
Sometimes I can temporarily fix this by calling stored procedures manually
via:
Sometimes works:
EXEC sp_adjustpublisheridentityrange "PublicationName"
Works more often:
DBCC CHECKIDENT ('TableName', RESEED)
But right now, I have one of our customer databases that neither of these
are working.
I would very much appreciate any help on this. It seems theres many myths
about merge replication not working well at all, and its a huge pain to
manage, if you are even able to make it work. I would greatly appreciate
some help as I'm very stuck. Perhaps contact with a MS rep would be great as
well but not very likely I'm sure.
Perhaps theres some tables I can look up that has values of settings that
could of gotten messed up, that I could show to someone who understands them,
and trouble shoot there if that exists.
Thanks all for listening.
Take care,
Simon
As a side note,
I just looked at the tables constraints, and it says this:
([VID] > 21100 and [VID] < 21200)
Is this correct? Is this an issue that I configured it originally for 200
ranges, then changed it to 60,000 ranges?
Also on one table that all the stored procedures don't work, there are 2
constraints on one table for inserts and both are from replication. This
sounds bad. Something is messed up I think?
Thanks,
Simon
"Si" wrote:

> Hello All,
> I would greatly appreciate some help on this issue. I am very stuck and
> struggling.
> Basicall I have a SQL 2000 Server, that is the publisher for a merge
> replication. This merge replication, is to replicate to handhelds, that via
> a mobile application, insert into the tables. The handhelds seem to be
> operating fine. The publisher is not however. When I try and insert records
> into the tables via web interface, I keep getting:
> The identity range managed by replication is full and must be updated by a
> replication agent.
> So I've read for hours online searching for this issue, tons of people have
> hit it, but nobody has a solid answer. Most people just hack crap together
> that works, or sometimes works.
> Basically how I configured it in the beginning was, each subscriber, and
> publisher got 200 identities, using automatic identity range management.
> Then the website started to hit problems. So I read some articles, some
> people said to set the identity ranges to something high that may never get
> hit. So I changed them to 60,000. This doesn't seem to work either. Every
> day now, sometimes twice a day, I'm getting range is full errors.
> Sometimes I can temporarily fix this by calling stored procedures manually
> via:
> Sometimes works:
> EXEC sp_adjustpublisheridentityrange "PublicationName"
> Works more often:
> DBCC CHECKIDENT ('TableName', RESEED)
> But right now, I have one of our customer databases that neither of these
> are working.
> I would very much appreciate any help on this. It seems theres many myths
> about merge replication not working well at all, and its a huge pain to
> manage, if you are even able to make it work. I would greatly appreciate
> some help as I'm very stuck. Perhaps contact with a MS rep would be great as
> well but not very likely I'm sure.
> Perhaps theres some tables I can look up that has values of settings that
> could of gotten messed up, that I could show to someone who understands them,
> and trouble shoot there if that exists.
> Thanks all for listening.
> Take care,
> Simon

Merge Replication and Dynamic and Static Filtering

Hi Guys - I have some basic questions about horizontal filtering and
would appreciate any help.
Dynimic Filtering
When I create a snapshot of a publication that has dynamic filtering,
what will it include? In other words, when the subscriber synchronizes for
the first time, will it apply the snapshot and then filter the data or is
the snapshot already filtered and, if so, by what (since filtering is
different for every subscriber)?
Static Filtering
If a subscriber gets data that is filtered by a particular region for
example, then you enter data in the subscriber for a different region. When
you synchonize, since the region information you entered is not part of the
filter, will it be deleted from the subscriber after it gets propagated to
the publisher or will it remain there?
My last question is if it is possible to do the following:
1) Create a static filter with several criteria (or is only one
allowed?)
2) Then before synchronizing, change the filter clause (through
SQLDMO)
If it seems like that if I change the filter clause then I have to
create another snapshot and reinitialize the subscriber.
Here is our situation, we would like for each subscriber to be able to
choose how they want to filter their data (some may want their data to be
filtered by more than one criteria). Is this flexibility possible?
Thanks,
Maer
Hello Maer,
Per your question, in Dynimic Filtering, when creating the subscription or
reinitilization the subscription, the snapshot will enable the dynamic
filtering. However, syncrhornization process itself will only syncronize
the data and does not have impact on snapshot. Anytime, you change filter,
you have to reinitilizae the replication.

>My last question is if it is possible to do the following:
>1) Create a static filter with several criteria (or is only one allowed?)
Yes, if you have server articles in the publication. There is only one row
filter for a specific article

> 2) Then before synchronizing, change the filter clause (through
SQLDMO)
Again, you have to reinitialize the repliction after a filter is changed.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Maer" <maer@.auditleverage.com>
>Subject: Merge Replication and Dynamic and Static Filtering
>Date: Tue, 25 Oct 2005 23:45:31 -0400
>Lines: 38
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uGguf9d2FHA.3228@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: pcp08364781pcs.lndsd201.pa.comcast.net 68.42.19.117
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17361
>X-Tomcat-NG: microsoft.public.sqlserver.replication
> Hi Guys - I have some basic questions about horizontal filtering and
>would appreciate any help.
> Dynimic Filtering
> When I create a snapshot of a publication that has dynamic filtering,
>what will it include? In other words, when the subscriber synchronizes for
>the first time, will it apply the snapshot and then filter the data or is
>the snapshot already filtered and, if so, by what (since filtering is
>different for every subscriber)?
> Static Filtering
> If a subscriber gets data that is filtered by a particular region for
>example, then you enter data in the subscriber for a different region.
When
>you synchonize, since the region information you entered is not part of
the
>filter, will it be deleted from the subscriber after it gets propagated to
>the publisher or will it remain there?
> My last question is if it is possible to do the following:
> 1) Create a static filter with several criteria (or is only one
>allowed?)
> 2) Then before synchronizing, change the filter clause (through
>SQLDMO)
> If it seems like that if I change the filter clause then I have to
>create another snapshot and reinitialize the subscriber.
> Here is our situation, we would like for each subscriber to be able to
>choose how they want to filter their data (some may want their data to be
>filtered by more than one criteria). Is this flexibility possible?
> Thanks,
> Maer
>
>
|||Thank you, Peter. This answers my questions It also shows that the
approach of dynamically changing the filter before synchronization will not
work.
Thank you,
Maer
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl...
> Hello Maer,
> Per your question, in Dynimic Filtering, when creating the subscription or
> reinitilization the subscription, the snapshot will enable the dynamic
> filtering. However, syncrhornization process itself will only syncronize
> the data and does not have impact on snapshot. Anytime, you change filter,
> you have to reinitilizae the replication.
>
> Yes, if you have server articles in the publication. There is only one row
> filter for a specific article
> SQLDMO)
> Again, you have to reinitialize the repliction after a filter is changed.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> When
> the
>
|||Hello Maer,
You are welcome! :-)
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Maer" <maer@.auditleverage.com>
>References: <uGguf9d2FHA.3228@.TK2MSFTNGP15.phx.gbl>
<ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Merge Replication and Dynamic and Static Filtering
>Date: Thu, 27 Oct 2005 11:58:29 -0400
>Lines: 106
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <#qciv7w2FHA.2292@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: pcp08364781pcs.lndsd201.pa.comcast.net 68.42.19.117
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17417
>X-Tomcat-NG: microsoft.public.sqlserver.replication
> Thank you, Peter. This answers my questions It also shows that the
>approach of dynamically changing the filter before synchronization will
not[vbcol=seagreen]
>work.
> Thank you,
> Maer
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl...
or[vbcol=seagreen]
filter,[vbcol=seagreen]
row[vbcol=seagreen]
for[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>