Hi All,
I am currently running into an issue with a client's GP environment wherein they are running the 'Reeconcile to GL' routine for receivables management and they are receiving the following error message:
"Violation of Primary Key Constraint 'PK##2152147' Cannot Insert Duplicate Key in Object dbo.##2152147"
The object value changes, as it represents a TEMP table. I was able to minimize the daterange such that it only occurs within a two week window. I have run checklinks, as well as the RM and GL duplications scripts, and nothing was found/resolved. I checked if there were corrupt or missing data in the RM and GL OPEN and HISTORY tables, and there was none.
I have done some research and determined that this was supposedley a known issue in GP10, although it was to be resolved with a service pack. The client is currently on the lastest release of GP2010. After reviewing other threads in this forum, it appears as though there was a script from Microsoft to resolve this issue, however all record of it has been wiped completely. The error renders the proceeding excel report useless.
I am completely lost as to what my next step may be. Does anyone have a suggestion I may be able to follow to resolve this issue, or at least a working location of the infamous script?
I would greately appreciate any help. Thank you very much.
