Re: Business Contact Does Not Delete

[Gary P]

On Jun 29, 11:42 am, Luther Blissett <enown...@gmail.com> wrote:
> On Jun 25, 12:33 pm, Gary P <g.poll...@gmail.com> wrote:
>
> > Hello,
>
> > We are having some problems with BCM 07.  The issue is that when we do
> > a large amount of data entry/deletion on the database some information
> > doesn't sync up.  For instance, we delete 100 records and the next day
> > 5 are still there.
>
> > We are running BCM in a local environment, off a "server PC" running
> > XP.  Accessing the database w/4 or 5 workstations at a time, database
> > is at 12K records.  No mobile sync w/database.
>
> > Thanks for your help,
> > Gary
>
> When you say does not delete, you mean the deleted item does not move
> to the Deleted Items folder?

Yes, items appear to move to the deleted items folder, but a few days
later they reappear in the database.

> If several user update a record. Let's say one user deletes the a
> contact and a second user updates the contact (e.g. because they
> received an email from that contact), then if the second event
> happened later (has a later ModifiedOn value), that may explain the
> behavior you are seeing.

We're pretty careful in this regard - we've coordinated data efforts
so that there is minimal overlap. It just happened again, some
duplicate records we deleted are not staying in the deleted items
folder. When we choose "Delete" they are removed from the business
contacts database, so it must be a sync problem. I'm hoping a memory
boost to the server pc will help.

 

[Luther Blissett]

On Jul 8, 10:00 am, Gary P <g.poll...@gmail.com> wrote:
> On Jun 29, 11:42 am, Luther Blissett <enown...@gmail.com> wrote:
>
>
>
>
>
> > On Jun 25, 12:33 pm, Gary P <g.poll...@gmail.com> wrote:
>
> > > Hello,
>
> > > We are having some problems with BCM 07.  The issue is that when wedo
> > > a large amount of data entry/deletion on the database some information
> > > doesn't sync up.  For instance, we delete 100 records and the next day
> > > 5 are still there.
>
> > > We are running BCM in a local environment, off a "server PC" running
> > > XP.  Accessing the database w/4 or 5 workstations at a time, database
> > > is at 12K records.  No mobile sync w/database.
>
> > > Thanks for your help,
> > > Gary
>
> > When you say does not delete, you mean the deleted item does not move
> > to the Deleted Items folder?
>
> Yes, items appear to move to the deleted items folder, but a few days
> later they reappear in the database.
>
> > If several user update a record. Let's say one user deletes the a
> > contact and a second user updates the contact (e.g. because they
> > received an email from that contact), then if the second event
> > happened later (has a later ModifiedOn value), that may explain the
> > behavior you are seeing.
>
> We're pretty careful in this regard - we've coordinated data efforts
> so that there is minimal overlap.  It just happened again, some
> duplicate records we deleted are not staying in the deleted items
> folder.  When we choose "Delete" they are removed from the business
> contacts database, so it must be a sync problem.  I'm hoping a memory
> boost to the server pc will help.- Hide quoted text -
>
> - Show quoted text -

When an item is "soft" deleted (moved to deleted items folder), in the
database its record is marked as deleted. I believe there's a column
for just that.

When an item is deleted from the deleted items folder then it's "hard"
deleted, and the record actually deleted from the database.

There may be some rules in BCM -- along the lines of: if an activity
is updated, and one its parents is soft deleted, then undelete it that may explain the behavior you're seeing.

Note that synchronizing data between several actors is an NP-complete
problem, so some simple but imperfect rules have to be used. For
example, if two users both change an entity, the most recent change
wins.