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

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.