Symptom:
You are attempting to synchronize your database and receive the following error:
“Synchronization has failed. PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO CREATE/ALTER BASE FUNCTION FNR_CONTACT”
Product:
Product Family: Sage ACT!
Product: Sage ACT! Pro, Sage ACT! Premium
Cause:
This error can occur if the database has become damaged.
Solution:
Alternate Solution:
You are attempting to synchronize your database and receive the following error:
“Synchronization has failed. PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO CREATE/ALTER BASE FUNCTION FNR_CONTACT”
Product:
Product Family: Sage ACT!
Product: Sage ACT! Pro, Sage ACT! Premium
Cause:
This error can occur if the database has become damaged.
Solution:
- Use the steps in the following knowledge base article to repair database:
- Test the synchronization
-
Title: ACT! Database Rebuild and Repair Procedures
Answer ID: Act! database rebuild and repair procedures
Alternate Solution:
- Use the steps in the following knowldge base article to create a new remote database:
- Test synchronizing with the new remote database
-
Title: How to Create a Remote Database
Answer ID: How do I set up remote database synchronization in Act!?