DRMiller
Technical User
- Jun 19, 2008
- 2
Hi,
Sorry for the length of this, but I feel it’s necessary to help narrow down the problem early on.
1.0 Our Act Setup
Me and a colleague have been using Act 10 (standard version) without any problems since October 2007. Our database was created in Act 5, migrated to Act 6 and then Act 10 and that process worked well. Recently, I upgraded both PCs (and our database) from Act 10.00 to Act 10.02. My colleague uses a remote database in a different office and we synchronise over VPN using Hamachi LogMeIn.
2.0 Errors on Colleague’s PC
Recently, I noticed when my colleague tried to sync Act, the sync process did not complete. When she tried to sync the next day, the sync process did not complete again and she received an error message (on the previous day, it said sync completed on her screen, which is odd).
(See image attached)
My colleague also said that she tried to record history against several contacts and Act said it was unable to record history.
3.0 Errors on My PC
3.1 Error: This contact no longer exists in the database
On the same day as this error on my colleague’s PC, I received an error message: “This contact no longer exists in the database <OK button> ”
3.2 Error: Not saving data all the time
1. I added and deleted data in some fields on a test/made up contact, then closed Act and the same error message displayed again. I clicked “OK” and Act closed.
2. Upon re-opening Act and viewing the test/made up contact, none of the field data changes I just made have saved.
4.0 Check & Repair
I carried out a ‘check and repair’ and that did not reveal any problems.
5.0 Re-installation of Act and SQL Server
I was unable to resolve this issue so I decided to uninstall and re-install Act and SQL Server, and restore a back-up copy of the database from a few days before.
We were able to work and synch Act without issues for several days.
6.0 Error Messages Have Re-Appeared
Today, as we were both working, we received the “This contact no longer exists in the database” message again. We are also unable to save data properly to records (sometimes the data saves to fields but most of the time it does not).
7.0 ActDiag / SQL Server
I have had a look at the ActDiag and the database instance is listed.
8.0 Services.MSC
I have checked services.msc on both PCs and here are the lines which I believe are relevant to Act/SQL Server. Both PCs display the same lines, as follows:
• SQL Server (ACT7): Status: Started, Startup Type: Automatic
• SQL Server Active Directory Helper: Status: <blank>, Startup Type: Disabled
• SQL Server Browser: Status: Started, Startup Type: Automatic
• SQL Server VSS Writer: Status: Started, Startup Type: Automatic
9.0 Testing in the Act Demo Database
Having just received the error message I tested the Act demo database today to see if we had the same issue and we did not. I tested all manner of actions e.g. changing data in fields (including the user and home fields etc), adding history, notes, opportunities, creating new contacts, deleting contacts, closing and re-opening Act (and so on). All changes saved without any problems and the error message did not appear.
10.0 Potential Solution?
The only joy I’ve had in narrowing this is from this message...
...which points to this article on the Act knowledge base:
However, I have just been through every single Contact, Company and Opportunity field and I can confirm that no fields have default text longer than their allowed number of characters.
11.0 Any Ideas?
Does anyone have any ideas on what this problem relates to and how we can resolve it?
Thanks in advance to anyone who offers help.
Sorry for the length of this, but I feel it’s necessary to help narrow down the problem early on.
1.0 Our Act Setup
Me and a colleague have been using Act 10 (standard version) without any problems since October 2007. Our database was created in Act 5, migrated to Act 6 and then Act 10 and that process worked well. Recently, I upgraded both PCs (and our database) from Act 10.00 to Act 10.02. My colleague uses a remote database in a different office and we synchronise over VPN using Hamachi LogMeIn.
2.0 Errors on Colleague’s PC
Recently, I noticed when my colleague tried to sync Act, the sync process did not complete. When she tried to sync the next day, the sync process did not complete again and she received an error message (on the previous day, it said sync completed on her screen, which is odd).
(See image attached)
My colleague also said that she tried to record history against several contacts and Act said it was unable to record history.
3.0 Errors on My PC
3.1 Error: This contact no longer exists in the database
On the same day as this error on my colleague’s PC, I received an error message: “This contact no longer exists in the database <OK button> ”
3.2 Error: Not saving data all the time
1. I added and deleted data in some fields on a test/made up contact, then closed Act and the same error message displayed again. I clicked “OK” and Act closed.
2. Upon re-opening Act and viewing the test/made up contact, none of the field data changes I just made have saved.
4.0 Check & Repair
I carried out a ‘check and repair’ and that did not reveal any problems.
5.0 Re-installation of Act and SQL Server
I was unable to resolve this issue so I decided to uninstall and re-install Act and SQL Server, and restore a back-up copy of the database from a few days before.
We were able to work and synch Act without issues for several days.
6.0 Error Messages Have Re-Appeared
Today, as we were both working, we received the “This contact no longer exists in the database” message again. We are also unable to save data properly to records (sometimes the data saves to fields but most of the time it does not).
7.0 ActDiag / SQL Server
I have had a look at the ActDiag and the database instance is listed.
8.0 Services.MSC
I have checked services.msc on both PCs and here are the lines which I believe are relevant to Act/SQL Server. Both PCs display the same lines, as follows:
• SQL Server (ACT7): Status: Started, Startup Type: Automatic
• SQL Server Active Directory Helper: Status: <blank>, Startup Type: Disabled
• SQL Server Browser: Status: Started, Startup Type: Automatic
• SQL Server VSS Writer: Status: Started, Startup Type: Automatic
9.0 Testing in the Act Demo Database
Having just received the error message I tested the Act demo database today to see if we had the same issue and we did not. I tested all manner of actions e.g. changing data in fields (including the user and home fields etc), adding history, notes, opportunities, creating new contacts, deleting contacts, closing and re-opening Act (and so on). All changes saved without any problems and the error message did not appear.
10.0 Potential Solution?
The only joy I’ve had in narrowing this is from this message...
...which points to this article on the Act knowledge base:
However, I have just been through every single Contact, Company and Opportunity field and I can confirm that no fields have default text longer than their allowed number of characters.
11.0 Any Ideas?
Does anyone have any ideas on what this problem relates to and how we can resolve it?
Thanks in advance to anyone who offers help.