We have the RTM of BCM 2010 installed and are using a shared database located
on a SQL server. Up until yesterday the database functioned fine, all users
had no issues with seeing contacts, opportunities, accounts etc. Today, all
users are missing some contacts, and about half of the opportunities. I have
logged into the SQL server using Management Studio and have opened the tables
and all of the data is still in the database. None of it is listed in the
deleted tables. But the records wont all show in BCM on the client. I have
tried both with offline enabled and with it turned off. Still missing. I
can not see any rhyme or reason to the disappearances.
I originally set this shared database up manually since the BCM admin tool
wasn't available. Yesterday, it became available and i downloaded and
installed it on the server. Just to check functionality, i ran the tool, but
made no permission changes at all to the database. I thought that this may
be the problem, so i restored the database from the backup that we ran
tuesday night. No go, the contacts and opportunities still do not show up in
the clients. But the data is present in the tables. Any one have any ideas?