web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analytical Accounting ...
Microsoft Dynamics GP (Archived)

Analytical Accounting Primary Key Violation AAG00600

(0) ShareShare
ReportReport
Posted on by Jennifer Fastner 305

I receive the following error message when trying to create a new Transaction Dimension in GP 2010.  SQL Server Native Client 10.0 SQL Server/Violation of PRIMARY KEY contraint 'PKAAG00600'.  Cannot insert duplicate key in object 'dbo.AAG00600'.

I found KB article ID: 897280 which I thought would resolve the problem.  When I run the script there is no aaTableID: 600 in our live database.  I ran the script against our test database, and I can see aaTableID: 600.  I did restore live to test, and did run both the Restore AA query and the Restore Test to Live query on the test database.

The KB article says I need to update the aaRowID, but because I can't see table 600 in our live company I'm not sure what to do.

Any help would be appreciated.

Thanks,
Jennifer 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Jennifer,

    If the AAG00600 table is really there but you have no entry for it in AAG00102 then you can make the necessary entry with an aaRowID value of 1, aaTableID value of 600 and it should sort itself out. I have done this before with good luck.

    However, it may be that you have another problem which is why the entry is missing in the first place so I would definitely test this in the test system first and make sure your problem is solved without any unintended effects.

    Hope this helps,

    Adam

  • Jennifer Fastner Profile Picture
    Jennifer Fastner 305 on at

    Adam,

    I tried to do an update with the following script, but since there was no aaTableID = 600 in AAG00102 table nothing happened.  I'm assuming I need to insert the aaTableID, and not just update?  What is the script I should be trying?  This is the update script I used.

    update AAG00102 set aaRowID = '1' where aaTableID = 600 and CMPANYID = '1'

    I do question though if I should be setting my aaRowID = '1' as when I do a select * from AAG00600 there are 8 aaTreeID items in this table.  Shouldn't I be setting the aaRowID = '8'?

    Thanks,

    Jennifer

  • Community Member Profile Picture
    Community Member on at

    Hi Jennifer,

    Instead of running an update actually insert the missing value.

    I don't have the table in front of me but it should be something like:

     insert aag10200 (rowid,tableid,cmpanyid) values (1,600,1)

    This will add the missing record if it is indeed missing. Let me know if that works.

    Thanks,

    Adam

  • Jennifer Fastner Profile Picture
    Jennifer Fastner 305 on at

    Adam,

    I will try the insert, but wanted to ask what you thought of the RowID being equal to 8 instead of 1 since there are already 8 items that are in the 600 table.

    Thanks again for your help!

    Jennifer

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Jennifer,

    If there are already records in the table I would make the RowId you insert to be one more than the greatest value in the aag00600. So in your case 9.

    Let me know if that works.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans