Payroll - violation of PRIMARY KEY constraint in temp table

(0) Share

Report

Posted on by Community Member

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)

All responses (2)

Answers (0)

Community Member 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?

Was this reply helpful? Yes No
Community Member 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

Was this reply helpful? Yes No