Help with Primary Key Violation on AAG50000?

(0) Share

Report

Posted on by chadbruels

1,582

I have a client who received a primary key violation error on this table in their Test company. This table is not included in Microsoft's script or eOne's script for addressing such errors for the AA tables when next numbers are out of sync. I also am not yet familiar with this table and am unsure of how to address manually. The error shows a SOP Void was being processed and displayed the violating key value:

www.screencast.com/.../yGQtQnTlrQ

A review of the table shows that AAG50000 has a record for the user and the violation key value. Yet, I notice she was working in the web client and the table also has an entry for "WebClientUser" and the Void document on the screen with the error is present on that row rather than the row with her actual username.

www.screencast.com/.../4cnCVEAYL3

Categories:

Other

All responses (2)

Answers (0)

chadbruels 1,582 on at

Like (0)

Report

RE: Help with Primary Key Violation on AAG50000?

Are you anticipating that the aaRowID might be getting fetched from the wrong row in the DYNAMICS.DBO.AAG00102 table? I didn't create the test company, so I don't know. If I check the GL10001 table, its record has the correct value in the INTERID column.
Mariano Gomez 26,225 on at

Like (0)

Report

RE: Help with Primary Key Violation on AAG50000?

Was this test company created from production data? If so, did you run the script to adjust the intercompany ID in test?