11-05-2013 12:01 PM
Error: "The INSERT Statement Conflicted with the FOREIGN KEY Constraint "OLEDBVIEW_PROVIDERVIEW_PROVIDER_VIEWNAME_FK". The Conflict Occurred in Database "Databasename", table "dbo.CTL_PROVIDERVIEW", column 'PROVIDER_VIEWNAME'. The statement has been terminated. When I tried to Unpack and Restore Remote Database
I used this link to Diagnostics Utility Database Repair Procedures:
It didnt work, I still have the same issue.
I have ACT! Premium 2010.
Thanks in advance.
11-06-2013 01:41 AM
Have you tried creating a new remote database file from the publisher database as the may be a problem with the file. I would also make sure that you do not have a database already attached to SQL with the same name, you can use ACTDIAG to check this.
11-06-2013 06:07 AM
I tried to create e new remote database, the same issue. I uninstalled all remote database a create e fresh new one, no success.
In actdiag, I checked I have only one database.
I also tried to Unpack and restore remote database on the publisher, didnt work.
I dont know what to do. Here is my error