Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

[Vini]

dbo.TBL_CONTACT_RELATION PRC_REPORT_MAKE_TABLEFUNCTIONS: ERROR OCCURED TRYING TO CREATE/ALTER BASE FUNCTION.

This has occured AFTER upgrading from 11.0 (the version that was knackered and wouldn't upgrade automatically) to 11.1 + HotFix 1.

[ghollister · Accepted solution]

This error sounds like it is looking for a table that no longer exists. The TBL_CONTACT_RELATION existed in 11.0, but not in 11.1, so this may be a schema update issue. Try the following steps from the machine hosting the Publisher database:

- Close ACT!

- Choose Run from your Start menu and type in actdiag

- When ACT! Diagnostics opens, choose Databases, then Database List. Locate and highlight your Publisher database

- Right-click on the database and run the following from the menu (one at a time, in this order):

1 - Database Fixes/Schema Update/Fix Known Schema Update Issues

2 - Database Rebuilds/Rebuild Schema

3 - Database Rebuilds/Rebuild Sync Objects

4 - Reindex Database

- Reopen ACT! and try creating the remote database

[ghollister · Accepted solution]

This error sounds like it is looking for a table that no longer exists. The TBL_CONTACT_RELATION existed in 11.0, but not in 11.1, so this may be a schema update issue. Try the following steps from the machine hosting the Publisher database:

- Close ACT!

- Choose Run from your Start menu and type in actdiag

- When ACT! Diagnostics opens, choose Databases, then Database List. Locate and highlight your Publisher database

- Right-click on the database and run the following from the menu (one at a time, in this order):

1 - Database Fixes/Schema Update/Fix Known Schema Update Issues

2 - Database Rebuilds/Rebuild Schema

3 - Database Rebuilds/Rebuild Sync Objects

4 - Reindex Database

- Reopen ACT! and try creating the remote database

[Vini]

I woke up after posting this, and that was the first thing I tried. Sure enough it worked.

Many thanks!