Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analytical Accounting ...
Microsoft Dynamics GP (Archived)

Analytical Accounting Error Massages When running a check links

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

when run check link for Analytical Accounting found this error, 

microsoft sql native client sql server violation of primary key constraint "PKAG30001". Can not insert duplicate key in object 'dbo .AAG30001'

microsoft sql native client sql server violation of primary key constraint "PKAG30001". Can not insert dup

When Click OK

The stored procedure aagGenericGLOpenTOD returned the following results: DBMS: 2627 , Microsoft Dynamics GP: .

is there a way to resolve this error?


Thanks

Mounir


and the out log file Below, 

System: 22/8/2013 02:44:54 PM Arian Co. Page: 1
User Date: 22/8/2013 User ID: Mounir
AA FILE MAINTENANCE ERROR LOG REPORT

File Name
Error Message
aaGLAssign
aaGLHdrID=15 aaGLDistID=8
Record Recreated
aaGLHdrID=5 aaGLDistID=4
Record Recreated
aaGLHdrID=5512 aaGLDistID=11
Record Recreated
aaGLHdrID=5757 aaGLDistID=6
Record Recreated
aaGLHdrID=6363 aaGLDistID=9
Record Recreated
aaGLHdrID=6528 aaGLDistID=4
Record Recreated
aaGLHdrID=6616 aaGLDistID=3
Record Recreated
aaGLHdrID=6619 aaGLDistID=32768
Record Recreated
aaGLHdrID=6619 aaGLDistID=32769
Record Recreated
aaGLHdrID=6780 aaGLDistID=32768
Record Recreated
aaGLHdrID=7101 aaGLDistID=5
Record Recreated
aaGLHdrID=7356 aaGLDistID=3
Record Recreated
aaGLHdrID=7359 aaGLDistID=3
Record Recreated
aaGLHdrID=7449 aaGLDistID=24
Record Recreated
aaGLHdrID=7451 aaGLDistID=25
Record Recreated
aaGLHdrID=7682 aaGLDistID=4
Record Recreated
aaGLHdrID=7683 aaGLDistID=4
Record Recreated
aaGLHdrID=7684 aaGLDistID=4
Record Recreated
aaGLHdrID=7820 aaGLDistID=4
Record Recreated
aaGLHdrID=9 aaGLDistID=6
Record Recreated
aaGLCode
aaGLHdrID=7684 Journal Entry=8669
Unmatched Record-Record Deleted
aaGLHdrID=5 Journal Entry=2056
Unmatched Record-Record Deleted
aaGLHdrID=7820 Journal Entry=8691
Unmatched Record-Record Deleted
aaGLHdrID=6528 Journal Entry=7457
Unmatched Record-Record Deleted
aaGLHdrID=6616 Journal Entry=7643
Unmatched Record-Record Deleted
aaGLHdrID=5757 Journal Entry=6793
Unmatched Record-Record Deleted
aaGLHdrID=5512 Journal Entry=6541
Unmatched Record-Record Deleted
aaGLHdrID=7451 Journal Entry=8345
Unmatched Record-Record Deleted
aaGLHdrID=6780 Journal Entry=7759
Unmatched Record-Record Deleted
aaGLHdrID=9 Journal Entry=2472
Unmatched Record-Record Deleted
aaGLHdrID=6363 Journal Entry=7325
Unmatched Record-Record Deleted
System: 22/8/2013 02:44:54 PM Arian Co. Page: 2

AA FILE MAINTENANCE ERROR LOG REPORT

File Name
Error Message
aaGLHdrID=7449 Journal Entry=8339
Unmatched Record-Record Deleted
aaGLHdrID=7101 Journal Entry=8095
Unmatched Record-Record Deleted
aaGLHdrID=7356 Journal Entry=8287
Unmatched Record-Record Deleted
aaGLHdrID=15 Journal Entry=2938
Unmatched Record-Record Deleted
aaGLHdrID=6619 Journal Entry=7614
Unmatched Record-Record Deleted
aaGLHdrID=7682 Journal Entry=8667
Unmatched Record-Record Deleted
aaGLHdrID=7683 Journal Entry=8668
Unmatched Record-Record Deleted
aaGLHdrID=7359 Journal Entry=8291
Unmatched Record-Record Deleted
aaGLHdrID=15 aaGLDistID=8
Unmatched Record-Record Deleted
aaGLHdrID=5 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=5512 aaGLDistID=11
Unmatched Record-Record Deleted
aaGLHdrID=5757 aaGLDistID=6
Unmatched Record-Record Deleted
aaGLHdrID=6363 aaGLDistID=9
Unmatched Record-Record Deleted
aaGLHdrID=6528 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=6616 aaGLDistID=3
Unmatched Record-Record Deleted
aaGLHdrID=6619 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=6619 aaGLDistID=5
Unmatched Record-Record Deleted
aaGLHdrID=6780 aaGLDistID=3
Unmatched Record-Record Deleted
aaGLHdrID=7101 aaGLDistID=5
Unmatched Record-Record Deleted
aaGLHdrID=7356 aaGLDistID=3
Unmatched Record-Record Deleted
aaGLHdrID=7359 aaGLDistID=3
Unmatched Record-Record Deleted
aaGLHdrID=7449 aaGLDistID=24
Unmatched Record-Record Deleted
aaGLHdrID=7451 aaGLDistID=25
Unmatched Record-Record Deleted
aaGLHdrID=7682 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=7683 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=7684 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=7820 aaGLDistID=4
Unmatched Record-Record Deleted
aaGLHdrID=9 aaGLDistID=6
Unmatched Record-Record Deleted
aaGLDist
Journal Entry=2056
Record Recreated
Journal Entry=2472
Record Recreated
Journal Entry=2938
Record Recreated
Journal Entry=6541
Record Recreated
System: 22/8/2013 02:44:54 PM Arian Co. Page: 3

AA FILE MAINTENANCE ERROR LOG REPORT

File Name
Error Message
Journal Entry=6793
Record Recreated
Journal Entry=7325
Record Recreated
Journal Entry=7457
Record Recreated
Journal Entry=7614
Record Recreated
Journal Entry=7643
Record Recreated
Journal Entry=7759
Record Recreated
Journal Entry=8095
Record Recreated
Journal Entry=8287
Record Recreated
Journal Entry=8291
Record Recreated
Journal Entry=8339
Record Recreated
Journal Entry=8345
Record Recreated
Journal Entry=8667
Record Recreated
Journal Entry=8668
Record Recreated
Journal Entry=8669
Record Recreated
Journal Entry=8691
Record Recreated
aaGLWorkAssign
aaGLWorkHdrID=8122 aaGLWorkDistID=17000
Record Recreated
aaGLWorkHdrID=8122 aaGLWorkDistID=17001
Record Recreated
aaGLWorkHdrID=8192 aaGLWorkDistID=17141
Record Recreated
aaGLWorkHdrID=8192 aaGLWorkDistID=17142
Record Recreated
aaGLWorkHdrID=8193 aaGLWorkDistID=17143
Record Recreated
aaGLWorkHdrID=8193 aaGLWorkDistID=17144
Record Recreated
aaGLWorkHdrID=8194 aaGLWorkDistID=17145
Record Recreated
aaGLWorkHdrID=8194 aaGLWorkDistID=17146
Record Recreated
aaGLWorkHdrID=8197 aaGLWorkDistID=17151
Record Recreated
aaGLWorkHdrID=8197 aaGLWorkDistID=17152
Record Recreated
aaGLWorkHdrID=8198 aaGLWorkDistID=17153
Record Recreated
aaGLWorkHdrID=8198 aaGLWorkDistID=17154
Record Recreated
aaGLWorkHdrID=8199 aaGLWorkDistID=17155
Record Recreated
aaGLWorkHdrID=8199 aaGLWorkDistID=17156
Record Recreated
aaGLWorkHdrID=8200 aaGLWorkDistID=17157
Record Recreated
aaGLWorkHdrID=8200 aaGLWorkDistID=17158
Record Recreated
aaGLWorkHdrID=8201 aaGLWorkDistID=17159
Record Recreated
System: 22/8/2013 02:44:54 PM Arian Co. Page: 4

AA FILE MAINTENANCE ERROR LOG REPORT

File Name
Error Message
aaGLWorkHdrID=8201 aaGLWorkDistID=17160
Record Recreated
aaGLWorkHdrID=8204 aaGLWorkDistID=17165
Record Recreated
aaGLWorkHdrID=8204 aaGLWorkDistID=17166
Record Recreated
aaGLWorkHdrID=8205 aaGLWorkDistID=17167
Record Recreated
aaGLWorkHdrID=8205 aaGLWorkDistID=17168
Record Recreated
aaGLWorkDist
Journal Entry=8967
Record Recreated
Journal Entry=9035
Record Recreated
Journal Entry=9038
Record Recreated
Journal Entry=9039
Record Recreated
Journal Entry=9042
Record Recreated
Journal Entry=9043
Record Recreated
Journal Entry=9044
Record Recreated
Journal Entry=9045
Record Recreated
Journal Entry=9046
Record Recreated
Journal Entry=9049
Record Recreated
Journal Entry=9050
Record Recreated

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans