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.
