6,775
When trying to upload an AA budget, the following error displays "Unhandled object exception: Violation of PRIMARY KEY constraint '___.' Cannot insert duplicate key in object "
I checked this kb article but the resolution / workaround #2 does not return values. The script may be out of date; SQL Version is SQL Server 2008
*This post is locked for comments
Table AAG00905
This table stores the Budget Tree Account Balance. It already sees a value in this table that you are trying to import, so it is returning a duplicate record error. The primary keys on this table are: aaBudgetID, aaCodeSequence, ACTINDX, aaFiscalPeriod, aaActualPriliminary.
Typically to resolve, make sure you don't have the same code and account combination listed more than once within each level.
Yes it is referencing a duplicate key for AAG00905. I updated the field in SQL based on this KB article support.microsoft.com/.../897280 but it did not resolve the error. Could you expand on the AAG00905 error, Cheryl? We checked multiple times in the budget, but it looks fine to us. Thanks!
Does the error reference a table at all? Usually it does and then you can see what table it is having issues with. I have seen this happen before, and if a duplicate key on the AAG00905 is from having an account in the budget that does not exist. An error on the AAG00904 may be due to having imported in AA dimension codes and the AAG00401 has duplicate codes....so it could be from a number of reasons. Seeing the whole error message will give a better indication of what the issue is.
Yes we checked for duplicates and did not see any. The same error message appears at the point where budget upload is 'waiting for SQL Server'
check your source file for lines with duplicates of the following fields:
Budget ID + Code Sequence + Account +Period Date + Fiscal Period
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (