/
Duplicate Key Error Generating TN TCRS
Duplicate Key Error Generating TN TCRS
Description of Issue
Generating TN retirement and received an error.
Violation of PRIMARY KEY constraint 'pl_prtneretc.' Cannot insert duplicate key in object 'dbo.prtnretc.'
Context
Payroll
Tennessee
TN TCRS Maintenance
TN TCRS Reporting
Cause
More than one TN TCRS Maintenances record.
Resolution
Delete all but one TN TCRS Maintenance record for each employee.
Additional Information
The Employer Code used to report the employee will come from the Employer Code defined on the TN TCRS Reporting Generate screen and not from Maintenance. Don't create one Maintenance record for each Employer Code that an employee should be reported under.
, multiple selections available,
Related content
TX TSDS staff records generate error inserting Teacher Incentive Allotment designation period records
TX TSDS staff records generate error inserting Teacher Incentive Allotment designation period records
More like this
What needs to be populated in TN TCRS Maintenance
What needs to be populated in TN TCRS Maintenance
More like this
TX TRS ED40 Generate triggers duplicate key error and halts
TX TRS ED40 Generate triggers duplicate key error and halts
More like this
Personal Property Generate AR fails due to duplicate key error
Personal Property Generate AR fails due to duplicate key error
More like this
TSDS Employee Assignments - Duplicate Key error trying to Import
TSDS Employee Assignments - Duplicate Key error trying to Import
More like this
txprecom Execute insert tmpchg failed Cannot insert duplicate key row in object error when running Preliminary Commitment Book
txprecom Execute insert tmpchg failed Cannot insert duplicate key row in object error when running Preliminary Commitment Book
More like this