Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

Accepted Solution Solved
Copper Contributor
Posts: 61
Country: United Kingdom
Accepted Solution

Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

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.

 

ERROR!


Accepted Solutions
Solution
Accepted by topic author Vini
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

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.

View solution in original post


All Replies
Solution
Accepted by topic author Vini
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

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.

Copper Contributor
Posts: 61
Country: United Kingdom

Re: Problems creating new remote database (dbo.TBL_CONTACT_RELATION)

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

 

Many thanks!