Business Contact Does Not Delete

[Gary P]

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

 

[Luther Blissett]

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?

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.

 

[Gary P]

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]

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


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.