Community
Showing results for 
Search instead for 
Do you mean 
Reply

Cannot Accept Incoming Synch to Work + Violation of UNIQUE KEY Error

Highlighted
Astute Commentator
Posts: 27
Country: United States

Cannot Accept Incoming Synch to Work + Violation of UNIQUE KEY Error

I've had to reinstall ACT! Premium Web 2012 Version 14.1.108.0.  During the installation and configuration, all tests were passed successful.  Have restored a database, but cannot Accept Incoming Synch to stay enabled.  When I go to Help About ACT! and click Database Information, I get an error "Violation of UNIQUE KEY constraint 'TBL_SYNCDB_AK2'.  Cannot insert duplicate key in object 'dbo.TBL_SYNCDB'. The statement has been terminated".  Please send me suggestions regarding resolution.  Thank you!

Highlighted
Nickel Super Contributor
Posts: 397
Country: USA

Re: Cannot Accept Incoming Synch to Work + Violation of UNIQUE KEY Error

Maybe you have two contacts with the same user name

 

Before any procedure I recommend making a backup.

 

Check the following link and check if it can be the case and the solution.

 

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/29754/kw/Violation%20of%20UNIQUE%20KEY%20co...

 

sage knowledgebase - Answer ID 29754

 

Good luck - do not forget to backup before.

 

Highlighted
Astute Commentator
Posts: 27
Country: United States

Re: Cannot Accept Incoming Synch to Work + Violation of UNIQUE KEY Error

Thank you for your post. I did check for duplicate contacts and the two user names for the database are not similar at all.  Please let me know if you have other thoughts.

Highlighted
Astute Commentator
Posts: 27
Country: United States

Re: Cannot Accept Incoming Synch to Work + Violation of UNIQUE KEY Error

Also, I noticed that the article you forwarded the link to references 'ak1' and the error I'm seeing is referencing 'ak2.'  Any idea what the the ak2 references in the table?