Got an error while testing Microsoft Dynamics GP

Asked By johnnym 0 points N/A Posted on - 11/19/2011

Hi,

We were using Microsoft Dynamics GP system in our test environment. We were trying to add a dimension in Analytical Accounting. We were then trying to add the dimension “14000” when we got this error message (please see below).

We then searched the web but couldn’t follow the solution of Mr. Daoud. So we turned to this forum hoping that someone might provide a clearer way to solve the problem.

Please help. Thanks in advance.

Microsoft Dynamics GP

[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY

KEY constraint PK_AAG00600’. Cannot insert duplicate key in

object’ dboAAG00600’.

• Status: Open
• Question Views: 1131
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by JENNIFER ROTH

Go To Solution

Best Answer

Best Answer

Answered By JENNIFER ROTH 0 points N/A #112194

Got an error while testing Microsoft Dynamics GP

Johnnym,

This is an issue with the table “Dynamics.AAG00102”.

The best option to resolve is to download a fix, which is present in shape of a fix from the SITE.

However in order to log in to this site, you must have a windows live ID, along with the access to the Microsoft Dynamics partner source portal. Your admin may help you in this respect.

The script, simply reset all counters for Analytical Accounting, and you issue will be resolved.

If you still want to try manually, lets try this:

Try adding the dimension as explained on the url.

Regards,

JR

About JENNIFER ROTH

Questions
2

Answers
13

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 11/19/2011
• Question Category: Misc Software

Answered By Edmund Joseph 5 points N/A #112195

Got an error while testing Microsoft Dynamics GP

 

Hi there user:

The problem occurred because the public group doesn’t have the execute permission on the smDex_Max_Char in the master database. Click Start, All Programs and SQl program. Log-in. Expands the Databases, system Databases, Master, Programmability, and Stored Procedure. Then right-click the smDex_Max_Char, then hit Properties. Click the Add button on the Permissions tab. Click the Browse button. Click twice the Public check-box. Verify the Public on the Permissions tab. Select Execute check box and then Ok.

Thanks for posting your question here at techyv.com

Best regards,

About Edmund Joseph

Questions
3

Answers
376

Best Answers
166

• Vote Up 0 Vote Down

• Posted on - 12/09/2012
• Question Category: Misc Software