08-05-2010 04:11 PM
I need help! I'm trying to convert a data base from act 6 to 2010 premium. I've already converted serveral other data bases but I can't convert one. The problem I encounter is.
Violation of PRIMARY KEY constraint 'TBL_GROU_CONTACT_PK'.
Cannot insert duplicate key in object
The statement has been terminated.
I have no idea what this means. I haven't encountered any problems with 7 other data sources that I've converted. Please help.
08-09-2010 09:33 AM
Welcome to the Act! Online Community!
It appears this particular V6 database damaged. Here is an article with steps to take to repair your database: KB Article 11462
The 'Scan and Repair' step is the main one. Another option is to save a copy of the V6 database to a new name, run the Scan and Repair step, then attempt conversion.
08-10-2010 10:41 AM
Save a empty copy of your database. This will separate your data from your field definitions. If the empty copy converts then you have a problem in the data. If the empty copy will not convert then you have a problem in your fields.