?
Solved

ACT! 6 & Server 2003 incompatibilty?

Posted on 2006-05-11
7
Medium Priority
?
474 Views
Last Modified: 2013-11-24
I have been running ACT! 6 and have just upgraded my network to Server 2003 and now ACT! 6 runs incredibly slowly and also freezes into "not responding" mode. Is there an incompatibilty issue and is there a fix?
0
Comment
Question by:PaddyGoo
  • 5
  • 2
7 Comments
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16661369
I am running several ACT 6 database here rangin from 2000 records to 75000. All are very responsive.

Couple of things you can try:

1. Compress and Reindex the database - Open the database, click File - Administration - Database Maintanence
2. Make sure opportunistic locking is disabled on the server. (Install ACT on the server, click Start - Run - actdiag. On the options menu, Click the oppotunistic locking item
3. Make sure to exclude the ACT database folder from Real TIme antivirus scanning (Norton Autoprotect, etc)
4. Access the database from workstations using a mapped drive not UNC (\\servername\share).

5. (Try the other options first) Abosolute Last Solution is a Database Scan and Repair. click Start - Run - actdiag. Click the Maintainence Option on the Menu and Select Scan and Repair. Let it run through its routines. Open the database in act again. You will get an error, click yes to rebuild the files.



0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16661380
Also, what build of ACT are you running? Click Help - About ACT. Is it 6.03?
0
 

Author Comment

by:PaddyGoo
ID: 16665402
Hi, we are running ACT! 6.0.3.979
We have since checked and proved that when we revert to WIN98SE and reconnect to Server 2003 then ACT! operates sucessfully, with no delays and no locking.

Also the delays and locking occur when we have Notes and History displayed in each record (of which there are 5000), if we leave it in Activities it doesn't slow or say 'not responding' so there seems to be an issue with retrieving Notes & History, and software in XP - so it's an XP + ACT! + Server 2003 matter, oh heck!

Will try your suggestions today and revert, many thanks.

John
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 7

Expert Comment

by:TheACTDude
ID: 16667127
Do you have all the filter options checked?

There is a hotfix available to resolve the notes issue if the fileters are set to display everything. Check out act.com

The hotifx is addresssed problem with the way the notes are sorted. Just for grins, change the sort order by date so the oldest is on top. That should speed things up.
0
 
LVL 7

Accepted Solution

by:
TheACTDude earned 2000 total points
ID: 16670119
Here is the full link for the hotfix:

http://www.act.com/support/updates/index.cfm?DOWNLOAD=159

Description: THIS HOTFIX REQURES ACT! 6.0 BUILD 6.0.3.979, US or International English versions only.
Hotfix Details: When attempting to open your ACT! Database or access your Notes/History tab after updating your ACT! software to the 6.0.3 build and notice that it is taking much longer than before you installed the update. This issue seems to happen only in databases that have large numbers of Notes/History entries and rarely occurs on Computers with 256 MB (or more) of RAM.

Please see the following online document for more information on this hotfix.

Title : My Database or Notes/History Tab is Slow to Open After Updating to ACT! 6.0.3 Document ID : 2003611134733 Web URL : http://itdomino.act.com/act.nsf/docid/2003611134733 

We do not warrant that the functions contained in the ACT! “hotfix” will meet your needs or requirements or that installation of the “hotfix” will be error free. If you install a “hotfix” you do so at your own risk. A 'hotfix" is not supported by our technical support. THE “HOTFIX” IS PROVIDED “AS IS” WITHOUT WARRANTIES OR IMPLIED TERMS OF ANY KIND, EXPRESS, IMPLIED OR STATUTORY, INCLUDING WITHOUT LIMITATION ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK ARISING OUT OF THE USEOF THE “HOTFIX” REMAINS WITH YOU. By downloading or installing this "hotfix" you agree to these terms.
 
0
 

Author Comment

by:PaddyGoo
ID: 16691792
Many thanks ACTDUDE and your efforts were much appreciated - your solutions did help speed things up, though one of problems was self created - we installed a new server but left the routes to attached documents to the old server name and therefore ACT had troubles finding the documents as had to search laboriously.

Anyway, many many thanks for your invaluable help.

John Davis aka PaddyGoo
c/o Pyropress Engineering
Plymouth
UK
0
 
LVL 7

Expert Comment

by:TheACTDude
ID: 16692682
Anytime...

For the document attachment thing, there is an addon available direclty from ACT call "Attachment Migration Wizard". It will chnage the file paths in mass for the attachments in the database.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Screencast - Getting to Know the Pipeline
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month16 days, 10 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question