Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Payroll - violation of...

Payroll - violation of PRIMARY KEY constraint in temp table

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Payroll - violation of PRIMARY KEY constraint in temp table

Hi Sanjay, thanks for your help but clearing the temp tables did not resolve the issue. Any other suggestions?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Payroll - violation of PRIMARY KEY constraint in temp table

Get all users off the GP clear your temp files and check if that helps...

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Cheers!

Sanjay