Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.


Violation of PRIMARY KEY constraint PKAAGx0000′, cannot insert duplicate key in object ‘AAGx0000’

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When importing transactions with SmartConnect receiving an error that says “Violation of PRIMARY KEY constraint ‘PKAAGx0000’, cannot insert duplicate key in object ‘AAGx0000′” where x is a number 1, 2 or 3

This problem occurs because the next value in the AAG00102 table has already been used in the applicable table that is causing the duplicate record. These tables include the following: AAG10000 AAG20000 AAG30000 To work around this problem download and then run this script in SQL Query Analyzer. Run the script against the company database where the error is occurring.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.