Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

ACT! Tech Tip

Have ACT! 2008 (upgraded from ACT! 2005 or 2006) and trying to do a New Inquiry Search in Tele-Support HelpDesk, returns error cound not convert variant of type (interger) into type unknown.

During research, came across with the root of the problem, Sage has a problem with one of the 3rd party products they are shipping with ACT! 2008.   It is the Protexis .dlls that creates the PSI Service on any ACT workstation.  As of this date (Dec 5, 2007), Sage does not have a hot fix for this problem,yet.

Possible resolution:

Reinstall ACT! 2008 is the most common resolution.  However, the reinstall may not install the SQL instance (even though it had been uninstalled, the registry entry for the instance name is left behind from ACT! 2005)

If the reinstall does not fix the problem since the reinstall may complete without installing a local instance for ACT.  A manual removal of all registry entries for ACT! may necessary including a manual removal of all SQL server folders under Program files, and a manual removal of all folders for Help Desk under Program files and \Program files\Common Files\ ; after the manual clean up and a fresh install of ACT! 2008, and a fresh install of Help Desk 3.2.1, using the local administrator profile (to avoid the Protexis error), you should be resolved.

When using ACT! 2008 Premium and only opening a network database, ACT! 2008 does not fail if a local SQL Server named instance "ACT!2005" is NOT present, but Help Desk Does fail if running the search functions on the Network ACT database.

Applicable to ACT! 2005/2006 upgraded to ACT!2008