ESS Timesheets - error when approving, using HR Attendance

(0) Share

Report

Posted on by Sherlene Sorenson

965

Hi, trying to get the Workflow working for a client upgrading to GP2015 R2 that is coming off Business Portal. When a timecard is submitted, it works fine, but when Approved, we get a message "Violation of PRIMARY KEY constraint 'PKTATX0130. Cannot insert duplicate key in object dbo.TATX0130. The duplicate key value is (ATTENDANCE ,9036). We looked in the TATX0130 table, and I do see records using Transaction number 9036, a also one with a Dex Row ID of 9036. But since we were in test company, I tried clearing this table and re-submitting and Approve the Time Card again, and still get same results. Also verified that the HR Attendance Next Transaction Number is set correctly. Any suggestions?

*This post is locked for comments

All responses (2)

Answers (1)

Sherlene Sorenson 965 on at

Like (0)

Report

RE: ESS Timesheets - error when approving, using HR Attendance

sorry, this was a duplicate response, and I can't delete it.
Verified answer

Sherlene Sorenson 965 on at

Like (0)

Report

RE: ESS Timesheets - error when approving, using HR Attendance

This was a very unusual situation. After much searching and involvement from Microsoft Support, we found that at some point in history, the customer had copied test to live company. There were two records in TAST0130. Once we deleted the incorrect record from that company, the approval and posting to PR Transaction Entry worked fine.