Newest KB Articles in ACT! Premium For Workgroups

How to update a Remote Database to sync after the master Act! database is updated.

Thu, 15 Jan 2015 22:54:47 GMT

If your hosted ACT! Master/Published Database has been upgraded from the previous version and you need to update the remote database so you can continue to sync. In order to follow this KB you will need to know what the new Master Database Server and the New Sync URL

You will need to make two changes in order to sync with the new ACT! servers. Please complete the following two tasks and you will be able to sync once again.

Task 1 : Updating Master Server Location

Detailed Instructions

Go to the Tools Menu, then Synchronization Panel.
Once the Synchronization Panel is open click "Manage Main Database" Location and change it to

[[ use the values for Master Database server provided to you ]]

click Finish then, Yes.

Task 2 : Updating Sync server

Detailed Instructions
While still in the Synchronization Panel

Locate and click "Manage Connection Information"
Change Connection Type to : Internet (outside a firewall)
Change Sync URL to : [[ use the values for New Sync URL provided to you ]]

Then Close and attempt to sync.

If you are still unable to sync please contact support.

Updating ACT! for Workgroups 11.0 to 11.01.1

Wed, 20 May 2009 16:08:05 GMT

Affected ACT! Versions: 11.0 - 11.01.0 - 11.01 Hotfix 1

Steps for Updating ACT! by Sage Premium 2009 11.0 to version 11.1.183.0 Hotfix 1

NOTE : Some users may have already applied the inline via the ACT updater. If so and they follow these steps they will be prompted to repair or remote ACT!. In order to prevent this prompt please check what version of ACT! is currently running before following the steps below. To check the version of ACT load ACT and go to he Help menu > About ACT! and you will see the version number. If the computer has version 11.1.183.0 Hotfix 1 already please skip down to step 4. If you have already upgraded the schema go to step 5.

Before you start let the support staff at RTG know that you are upgrading your ACT! remote database to 11.1.183.0 Hotfix 1 so that the RTG support staff can make the changes that need to be made on the RTG ACT! hosting servers. Please contact the RTG support staff by emailing them at support@RTGroup.com

1. Sync your Database two times. While you are syncing you can start the next step.

2. Download & Save the updates from our site

http://dl.rtgroup.com/act/2009_11/updates/ACT1110PremUSUpdate.exe
http://dl.rtgroup.com/act/2009_11/updates/ACT1110HotFix.exe

Do not try to update ACT! through the ACT! update as it can be problematic.
The official Sage Documentation can be viewed here :
11.01 update
11.01 HF1 update

3. Once the syncs have completed, go to the menu File > Back up > Database. Use the default path, and click OK to begin the backup of your remote.

4. Once the download has competed, reboot your computer, after you computer has rebooted do not load ACT!, Outlook or any Office application.

5. Run the ACT1110PremUSUpdate.exe file that you downloaded in step 2. Follow the prompts.

6. Run the ACT1110HotFix.exe file that you downloaded in step 2. Follow the prompts

7. After the Install is complete you will need to open ACT! and you will be prompted to upgrade your database, you want to click YES, it will also ask you prior to the upgrade to back up your database this is unnecessary as you backed up the database in step 3.

8. After you have upgraded your ACT and you can see your ACT contacts you need to update you sync server path. On the ACT! tool menu go to Tools> Synchronization Panel. Once the Synchronization Panel opens, Under the Users Task section locate the link that reads " Manage Connection Information", click it. The panel will change, You need to make sure the Connection Type is "Internet (outside firewall)", and the URL below is http://DAL11SYNC02.MYACTDB.com/AIS11 click the finish button. Click the close button to close the panel.

9. Now you need to start your synchronization, Go to Tools> Synchronize > Synchronize Now and you should be finished with the update.

Clean up: After you have completed these steps, you can delete the files you downloaded in step 2 as they are no longer needed.

If you have any issues please contact support
Support@RTGroup.com
http://support.rtgroup.com
646 419 4808

Written by Jeremy Wesley @ RTG

Updating ACT! for Workgroups 10.0-10.02HF1 to 10.03

Tue, 12 Aug 2008 14:58:07 GMT

Affected ACT! Versions: 10.0 - 10.01 - 10.2 - 10.2 Hotfix 1

Steps for Updating ACT! by Sage Premium for Workgroups 2008 to version 10.0.3.182

NOTE : Some users may have already applied the inline via the ACT updater. If so and they follow these steps they will be prompted to repair or remote ACT!. In order to prevent this prompt please check what version of ACT! is currently running before following the steps below. To check the version of ACT load ACT and go to he Help menu > About ACT! and you will see the version number. If the computer has version 10.0.3.182 already please skip down to step 4. If you have already upgraded the schema go to step 5.

Before you start let the support staff at RTG know that you are upgrading your ACT! remote database to 10.3 so that the RTG support staff can make the changes that need to be made on the RTG ACT! hosting servers. Please contact the RTG support staff by emailing them at support@RTGroup.com

1. Sync your Database 2 times. While you are syncing you can start the next step.

2. Download & Save the update from our site
http://dl.rtgroup.com/act/2008_10/ACT1003PremUSUpdate.exe

Do not try to update ACT! through the ACT! update as it can be problematic.

3. Once the syncs have completed, go to the menu File > Back up > Database. Use the default path, and click OK to begin the backup of your remote. It is important to backup your database before upgrading as the new version's backups are incompatible with your current version.

4. Once the download has competed, reboot your computer, after you computer has rebooted do not load ACT!, Outlook or any Office Application.

5. Run the ACT1003PremUSUpdate.exe file that you downloaded in step 2. Follow the prompts

6. After the Install is complete you will need to open ACT! and you will be prompted to upgrade your database, you want to click YES, it will also ask you prior to the upgrade to back up your database this is unnessicary as you backed up the database in step 3.

7. After you have upgraded your ACT and you can see your ACT contacts you need to update you sync server path. On the ACT! tool menu go to Tools> Synchronization Panel. Once the Synchronization Panel opens, Under the Users Task section locate the link that reads " Manage Connection Information", click it. The panel will change, You need to make sure the Connection Type is "Internet (outside firewall)", and the URL below is http://BTR10SYNC02.MYACTDB.com/AIS10 click the finish Button. Click the close button to close the Panel.

8. Download and run the DB Fixer for 10.3.

Download this file http://dl.rtgroup.com/act/2008_10/DBFixer_80090.exe, and run it against your Remote Database
If you need more information on this fix please see : KB 23406

9. Now you need to start your synchronization, Go to Tools> Synchronize > Synchronize Now and you should be finished with the update.

Clean up: After you have completed these steps, you can delete the files you downloaded in step 2 & 8 as they are no longer needed.

If you have any issues please contact support
Support@RTGroup.com
http://support.rtgroup.com
646 419 4808

Written by Jeremy Wesley @ RTG

You are attempting to synchronize your database when you receive the following error message: "Error converting datatype int to tinyint"

Wed, 22 Aug 2007 13:06:40 GMT

Affected ACT! Versions: 9.0X

The Error:
You are attempting to synchronize your database when you receive the following error message: "Error converting datatype int to tinyint"

RTG's Suggested Action:
This is a non recoverable error for all Remote Databases and the Master Database. The Master is corupt and the master database needs to be repaired, and all remotes need to be cut from the new master.

Resolution
There is no way to prevent this error. It randomly happens. It will continue to happen in ACT! version 9. In order to prevent future issues with this error upgrade to ACT! version 10.0 (Version 10.0.0.237) or Higher

Written by Jeremy Wesley @ RTG

TECH INFO Answer ID 20058

ACT! Menu Items Do Not Work In Microsoft® Word After Updating to 9.0.1

Fri, 27 Apr 2007 14:34:54 GMT

You are creating a new or modifying an existing ACT! template in Microsoft Word and find that the Act! menu items do not work.

Solution:
Running the following arguments from the command prompt will correct this issue. Please use the one of the two methods described below to resolve this issue.

Method One:

Close ACT!

Right-click the

901fix.cmd

file below, and then click Save Target As from the shortcut menu. A Save As dialog box appears.

Click the drop-down arrow at the Save in field, browse to your Windows Desktop, (do not rename this file), and then click Save.

Double click on the

901fix.cmd

file to run it.

Launch Act!

Method Two:

Close ACT!

Click the Windows®

Start

button, and then click

Run

. The

Run

dialog box appears.

Type

cmd

in the

Open

field, and then click

If not at the "

C:\ >

" prompt type

and then press the

Return

key. Otherwise type

cd\

and then press the

Return

key to change to the root of the

"C"

drive.

Change to the following directory

C:\Program Files\ACT\ACT for Windows

Note:

This will only work if ACT! is installed in the default installation directory described above.

Type in the following commands in the order they appear. Press the

Return

key after each command. (Ensure to include the

capitalizations

and the

quotation marks

Regasm "C:\Program Files\ACT\Act for Windows\Act.Office.Addin.dll" /codebase "C:\Program Files\ACT\Act for Windows\Act.Office.Addin.dll"

Regasm "C:\Program Files\ACT\Act for Windows\ActOutlookAddin.dll" /codebase "C:\Program Files\ACT\Act for Windows\ActOutlookAddin.dll"

Regasm "C:\Program Files\ACT\Act for Windows\Act.Framework.interop.dll" /codebase "C:\Program Files\ACT\Act for Windows\Act.Framework.interop.dll"

Regasm "C:\Program Files\ACT\Act for Windows\Act.Application.Interop.dll" /codebase "C:\Program Files\ACT\Act for Windows\Act.Application.Interop.dll"

When each is completed successfully you will see a similar DOS window stating

Types Registered Successfully

Type

Exit

to close the DOS window, and then launch ACT!.

ACT! Sync starts then sync fails during the sync process.

Wed, 28 Mar 2007 12:05:58 GMT

Affected ACT! Versions: 7.0 & greater

The Error:
ACT! Sync starts then sync fails during the sync process.

RTG's Suggested Action:
This can happen from time to time with internet sync. At this time we are unsure why it happens.

Resolution
You can switch to network sync for a few syncs and then back to internet sync.

1. Contact RTG and make sure your Database is configured for network sync.

2. Go to the Menus across the top select Tools > Synchronization Panel

3. Once the Synchronization Panel loads locate the link “Manage Connection Information” Click this link and change the dropdown to “Network (inside the firewall)” and make sure the sync server information is correct

4. Close the Synchronization Panel

5. Attempt to Sync.

6. After you have synchronized successfully go back into the Synchronization Panel and change it back to “Internet Sync(outside the firewall)”

7. Attempt to Sync again and you should be able to compete the sync.

Written by Jeremy Wesley @ RTG

Missing Files on Remote Databases in Sync enviroment

Wed, 28 Mar 2007 09:24:51 GMT

Affected ACT! Versions: 7.0 - 9.0a

The Error:
Users are missing files that were added by another user.

A bug was discovered in ACT! File sync that has been addressed in 9.01

RTG's Suggested Action:
You will need to manually collect from remote computers any missing files and send them to RTG. Follow these steps in order to make the process go smoothly.

Files missing from the Master ACT! Database (The ACT! server)

1. Contact RTG at support@rtgroup.com to obtain a missing files report from the server.

2. Download ACTwiz’s Missing Files Finder from www.ACTwiz.com

3. Follow the instructions on the www.ACTwiz.com site and inside the application.

4. Once you have all of the missing files from all remote computers together in 1 place, zip them and ask RTG for a ShuttleFile.com link so you can upload the newly created zip file.

5. RTG will place the missing files and they should sync to each remote over the next few sync. The more missing files the longer it will take for all remotes to get all the files.

You can check remotes for missing files by running ACTDIAG and requesting the missing files report. You can send this report to RTG support and they will send you the files that you are missing that can be located on the ACT! server. It is best if the files can sync down to the ACT! remotes but in some cases the amount of files may be too much for ACT! to complete in a normal timeframe.

Resolution
I t has been fixed in the inline 9.01. There is no fix for ACT! 7-8 products other to upgrade to 9.01.

Written by Jeremy Wesley @ RTG

Syncs fail in ACT! Scheduler

Wed, 28 Mar 2007 09:06:06 GMT

Affected ACT! Versions: 8.0 - 9.0a

The Error:
Users try to use the ACT! Scheduler that runs as a service to synchronize automatically and the sync fails. Users try to sync inside of ACT! And it works as designed. This issue is specific where Internet Sync is used as in RTG’s hosted environment.

The Problem is there is a bug in the ACT! Scheduler that causing scheduled sync to always use Network Sync, regardless of what you have specified in ACT!.

RTG's Suggested Action:
Contact RTG at support@rtgroup.com and verify that ACT! Network sync is setup for your database. Do Not Change your sync config to Network Sync; leave it as Internet Sync unless directed by RTG support staff.

Resolution
it has been fixed in the inline 9.01. There is no fix for ACT! 8 products other than RTG’s suggested workaround.

Written by Jeremy Wesley @ RTG

ACT Sync Error - ISATTACHSYNC

Mon, 26 Mar 2007 17:45:21 GMT

Affected ACT! Versions: 8.02 HF 3 -9.0a

The Error:
Server initialization failed. Sync initialization error occurred in database object PRC_SYNC_PROCESS_INITFILE: CANNOT DETERMINE ISATTACHSYNC VALUE!

RTG's Suggested Action:
This is a non recoverable error for a Remote Database. The Remote Database needs to be deleted and a new Remote Database should be cut. DO NOT RECUT the existing Remote Database, if you do the error will return with in about 2 weeks.

Once you restore the new remote to the users machine you can export the data that has changed since the last sync. See a future KB on how to do this.

Resolution
There is no way to prevent this error. It randomly happens. It will continue to happen in ACT! version 8. In order to prevent future issues with this error upgrade to ACT version 9.0a (Version 9.0.0.557).

Written by Jeremy Wesley @ RTG