We're getting the infamous PRIMARY KEY violation error on a temp table when running the period-end payroll benefit summary report (Reports-->Payroll-->Period-End-->Benefit Summary).
So far I've ran check links on payroll (no errors found), rebuilt indexes for UPR00100, UPR00600, and UPR30300 (tables being referenced in uprLoadTempXCmpyBenefitSummary), and rebooted the server. I've also peeked in the UPR tables above looking for a possible duplicate but did not find anything obvious, corrupt, or blank.
I was able to run sp_help and sp_helpconstraint on the temp table so I know what the PK is. I just can't figure out the duplicate or corrupt record(s). How can I get the complete GP error that is being cut off in the msg box to get the duplicate key value violation?
Many thanks.
*This post is locked for comments
I have the same question (0)
