Thursday, August 6, 2009

Analytical Accounting Error: Cannot insert duplicate key in object 'dbo.AAGXXXXXX'.


Few days ago I got a case with one of my clients complaining that he's getting the following error when trying to save new Analytical Accounting Transaction Dimension :

[Microsoft][SQL Native Client][SQL Server] Violation of PRIMARY KEY constraint 'PK_AAG00600'. Cannot insert duplicate key in object 'dbo.AAG00600'.


While investigating the issue I found that the table "Dynamics.AAG00102" that holds the next values for Tree's has incorrect index, so I just pulled the maximum ID in AAG00600 table, and then went to Dynamics.AAG00102 located "600" under aaTableID and changed the aaRowID to the maximum number + 1 of the values in AAG00600.

If you don't link to modify this manually, this was already solved in KB under the following link, there is a script file that will reset all counters for Analytical Accounting and fix this issue out:

Mohammad R. Daoud
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations

1 comment:

rlabey said...

Thanks for information as an accountant i know how informations are helpful thanks again
Accounting For Business

Related Posts:

Related Posts with Thumbnails