Showing posts with label discovered. Show all posts
Showing posts with label discovered. Show all posts

Friday, March 23, 2012

Merge 2005 - A row from this table will go to only one subscription

Hello everyone.

We've been using replication since a while now and I just discovered that some user are not getting all the data they should. Let me explain the way the whole thing is configured for us.

We have a few tables that are replicated using the Merge process with filtering on the data using SUSER_SNAME() function. My users are salesrep using Laptop and they are synchronizing on demand. The merge process is configured so that a row will go to only one subscription --> Each rep has their owns customers and related tables informations.

I noticed that some users do not have locally all data (from their customers) from some tables while they should. I didn't checked in details but it is possible that these users are new reps replacing other staff that left the company. Is it possible that the data they do not receive is marked as to be previous reps owner because the replication is set as "A row from this table will go to only one subscription" ? The new rep uses the same laptop, therefore the exactly same computer name, only the username changes.

Because of this, now I'm having a bunch of conflicts when replicating because we're generating some ID based on existing data when the user enter new records in some tables; since the data is not sitting locally for them, the ID generated is not the proper one and we now have two identical ID (one on the server and one locally) which cause the conflicts to occurs.

Any helps would be appreciated. Thanks.

BUMP!

Merge 2005 - A row from this table will go to only one subscription

Hello everyone.

We've been using replication since a while now and I just discovered that some user are not getting all the data they should. Let me explain the way the whole thing is configured for us.

We have a few tables that are replicated using the Merge process with filtering on the data using SUSER_SNAME() function. My users are salesrep using Laptop and they are synchronizing on demand. The merge process is configured so that a row will go to only one subscription --> Each rep has their owns customers and related tables informations.

I noticed that some users do not have locally all data (from their customers) from some tables while they should. I didn't checked in details but it is possible that these users are new reps replacing other staff that left the company. Is it possible that the data they do not receive is marked as to be previous reps owner because the replication is set as "A row from this table will go to only one subscription" ? The new rep uses the same laptop, therefore the exactly same computer name, only the username changes.

Because of this, now I'm having a bunch of conflicts when replicating because we're generating some ID based on existing data when the user enter new records in some tables; since the data is not sitting locally for them, the ID generated is not the proper one and we now have two identical ID (one on the server and one locally) which cause the conflicts to occurs.

Any helps would be appreciated. Thanks.

BUMP!

sql

Mentored Learning

I discovered that many of my very busy colleagues are having an
extremely difficult time pulling themselves away to take vital
training when it requires being away for consecutive days. I just
completed training for .NET in Chicago through a mentored learning
program that personally helped me to tackle that same issue. Though
the mentored learning training allows complete interaction with
classroom version labs and interaction with an on staff expert on the
topic, it does require some discipline in that I was responsible for
the pace I was moving. The benefit for me is that I did not have to
commit myself to a set schedule of consecutive days being
inaccessible. I had the flexibility to engage in the mentored
learning program once a week until I completed the course. Plus the
mentored learning lab was very comfortable and for some of my
colleagues who would are able to travel, it is near O'Hare Airport and
there is a hotel next door.

Once I get more help in our data center, I do plan on spending some
time, and some of our firm's money on some instructor-led classes that
will require me to be away for consecutive days and I can get done a
lot quicker. This particular training centers line-up of classes and
its personnel impressed me. I thought I would alert the rest of you
to this attractive alternative and would be happy to provide you the
details on a need to know basis either through this discussion group
or you can send me an email to Robert@.vcmnetwork.com.Please post the additional information to the NG...the company's
website and things like that would help everyone.

Thank you, Tom

On Mar 21, 9:10 am, "whosesocks" <Robert-Mar...@.comcast.netwrote:

Quote:

Originally Posted by

I discovered that many of my very busy colleagues are having an
extremely difficult time pulling themselves away to take vital
training when it requires being away for consecutive days. I just
completed training for .NET in Chicago through a mentored learning
program that personally helped me to tackle that same issue. Though
the mentored learning training allows complete interaction with
classroom version labs and interaction with an on staff expert on the
topic, it does require some discipline in that I was responsible for
the pace I was moving. The benefit for me is that I did not have to
commit myself to a set schedule of consecutive days being
inaccessible. I had the flexibility to engage in the mentored
learning program once a week until I completed the course. Plus the
mentored learning lab was very comfortable and for some of my
colleagues who would are able to travel, it is near O'Hare Airport and
there is a hotel next door.
>
Once I get more help in our data center, I do plan on spending some
time, and some of our firm's money on some instructor-led classes that
will require me to be away for consecutive days and I can get done a
lot quicker. This particular training centers line-up of classes and
its personnel impressed me. I thought I would alert the rest of you
to this attractive alternative and would be happy to provide you the
details on a need to know basis either through this discussion group
or you can send me an email to Rob...@.vcmnetwork.com.