Community
Showing results for 
Search instead for 
Do you mean 
Reply

Error when restoring remote database - ACT 2010

Accepted Solution Solved
Copper Super Contributor
Posts: 82
Country:
Accepted Solution

Error when restoring remote database - ACT 2010

Have set up a remote database without issue. Copied it to the laptop that is going to synch with the main one.

 

Went to the lap top and double clicked on the RDB to open it and got the following error message

 

The INSERT statement conflicted with the FOREIGN KEY constraint “OLEDBVIEW_PROVIDERVIEW_PROVIDER_VIEWNAME_FK”. The conflict occurred in database “The name of my databse was here”, table “dbo.CTL_PROVIDERVIEW”, column ‘PROVIDER_VIEWNAME’. The statement has been terminated.

  Any ideas what I've got going on here?

 

 


Accepted Solutions
Solution
Accepted by topic author gtdc
‎09-25-2015 03:20 AM
Copper Super Contributor
Posts: 82
Country:

Re: Error when restoring remote database - ACT 2010

Sorted via very impressive ACT Technical Support over the phone.

 

Did some ACTDiag stuff and it proved to be an error in my DB

View solution in original post


All Replies
Copper Super Contributor
Posts: 82
Country:

Re: Error when restoring remote database - ACT 2010

I should add. The remote database was made on my main PC which runs XP and the laptop I copied it to and am restoring from runs (hiss) Vista.
Solution
Accepted by topic author gtdc
‎09-25-2015 03:20 AM
Copper Super Contributor
Posts: 82
Country:

Re: Error when restoring remote database - ACT 2010

Sorted via very impressive ACT Technical Support over the phone.

 

Did some ACTDiag stuff and it proved to be an error in my DB