Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you set up a new Dimension in Analytical Accounting in Microsoft Dynamics GP: "Cannot insert duplicate key row in object 'dbo.AAG00600'"

Error message when you set up a new Dimension in Analytical Accounting in Microsoft Dynamics GP: "Cannot insert duplicate key row in object 'dbo.AAG00600'"

View products that this article applies to.

Symptoms

When you set up a new dimension in Analytical Accounting (AA) in Microsoft Dynamics GP, you receive the following error message when you click Save in the Transaction Dimension Maintenance window:

Cannot insert duplicate key row in object 'dbo.AAG00600' with unique index 'AK2AAG00600'.

The stored procedure aagCreateTree returned the following results: DBMS: 2601, Microsoft Dynamics GP: 0.


↑ Back to the top

Cause

By default, there are 6 main trees that are already established in AA. Additionally, a main tree for any new Dimension will also be created. Therefore, you are not allowed to name any new Dimension to be the same name as one of the existing default main trees. 

↑ Back to the top

Resolution

You will not be able to enter a Transaction Dimension name to be the same name as one of the main default trees:  
  • Account
  • Customer
  • Employee
  • Item
  • Site
  • Vendor
Note: For example, you could use a variation of the above name to make it unique such as Acct or Account1 instead of using Account.

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2687215
Revision : 1
Created on : 1/7/2017
Published on : 3/13/2012
Exists online : False
Views : 211