Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act Pro 2011 conversion error

mpc
New Member
Posts: 2
Country: Canada

Act Pro 2011 conversion error

I'm evaulating Act 2011 for 30 days but I can't get it to convert our old Act 6 db.

 

Below is the error that I'm getting.

 

Converting Notes and Histories...
The INSERT statement conflicted with the FOREIGN KEY constraint "NOTE_MANAGEUSERID_FK". The conflict occurred in database "MPC", table "dbo.TBL_ACCESSOR", column 'ACCESSORID'.
The statement has been terminated.

 

How do I fix this error if possible?

 

I used the scan and repair database tool in actdiag and it passed with all green check marks.

 

Thanks for any help.

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Act Pro 2011 conversion error

The ACTdiag scan and repair only checks for problems with linking between tables, it doesn't fix any data errors which it appears that is what you have. You can try creating an empty copy of your database and importing everything from you existing database into the empty copy. That will sometimes resolve data erors. The other option is to send the database to a repair service for a full repair. Our database repair serivce is listed on our web site www.techbenders.com

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
mpc
New Member
Posts: 2
Country: Canada

Re: Act Pro 2011 conversion error

All right. Thanks for your reply.

I will try the importing to an empty copy as suggested.