07-21-2009 07:43 AM
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.
07-22-2009 08:58 AM
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
Greig Hollister
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
07-22-2009 08:58 AM
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
Greig Hollister
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
07-22-2009 09:00 AM
I woke up after posting this, and that was the first thing I tried. Sure enough it worked.
Many thanks!