Newsgroup subject: Data loss in BCM 2007 with shared SQL 2005 database
Archived from: microsoft.public.outlook.bcm
Author: Myron Johnson
A client is trying to use BCM 2007. The database is on their SBS 2003 Server, running SQL 2005 WorkGroup Edition. Right now, there are really just two users on the LAN. The main user is doing testing and reports a problem with losing newly saved information. Her description is below. Does any of this ring a bell with anyone?
Thanks in advance
--
Myron Johnson
RTA Information Technology - Tempe, Arizona, USA
=========================
"So what it is doing is losing newly saved information. I noticed it first when I would change what account a business contact was linked to. I would save and it would think for a minute and complete the save. However, when I went to see if it linked it to the new account it had done nothing. It is progressively getting worse. I am now noticing it in almost every area. I have also seen it do the exact same thing to accounts and business contacts when I: linked an email, added information to comments, changed a spelling typo, changed or added a category, etc. Every time when I went to try it again it would eventually work correctly, but sometimes it is on the second try and other times it takes 3 of 4 times. So far I haven’t noticed it completely loosing accounts or contacts, but there is so many I’m not sure if I would notice one gone. It all seems to be when things are being edited.
Also very often when I have generated a list that I am editing items from the list will disappear and it will say nothing to display. An example is if I am in business contacts and have it arranged by categories and I open and change something in a contact, when I save it will bring me back to the original list but when I try to scroll to the next one the list disappears. To scroll I have tried to use my mouse, the scroll bar, and the arrows on the scroll bar. Nothing seems to make a difference. I have even tried to click on the list when I returned, thinking it’s trying to move me to a different area but it also didn’t help. I have to go to the accounts list and then back to the business contacts list to make it work. Sometimes my list will be the
same, sometimes it is not. It seems to me the problems could be related because I am always editing when it goes crazy. But on the other hand, no one but John has been using CRM other than me editing, and he isn’t using it that much. I did ask him and he has not encountered the same problems. Sorry to give you such a tedious problem but I’m just scared it may cause big problems when everyone starts to use it. Please let me know if you need any more clarification or if I can help because I understand that issues like this aren’t always easy to find the source of."