Error 'Error while execute the OnEnd event due to [Microsoft OLE DB Provider for ODBC Drivers, -2147217900], xxx. Cannot insert duplicate key in object 'RecomAction'' when approving appraisal

Error 'Error while execute the OnEnd event due to [Microsoft OLE DB Provider for ODBC Drivers, -2147217900], xxx. Cannot insert duplicate key in object 'RecomAction'' when approving appraisal

Symptoms:

The user encountered the above error message when he/she is trying to approve staff performance appraisal

Possible cause(s):

There is a duplicate value within the RECOMACTION under path: Setup >> Company >> Codes >> RECOMACTION

Suggested workaround / Solution(s):

Remove the duplicate record as per below steps and try to approve the staff’s performance appraisal again.

Go to Setup >> Company >> Codes
Select company
Click on RECOMACTION within the appraisal category
Tick the check box on the duplicate value and click on “Delete selected”

Related Articles
Encounter 'Microsoft VBScript runtime error ‘800a000d’. Type Mismatch: ‘clng’. /eAppraisal/eHRNewStaffApp3.asp, line 74' when submitting an appraisal form
Symptoms: The above error message occurs when a manager tries to submit employee appraisal form after selecting the employee, appraisal template, performance period and click on Submit button under Appraisal -> My Staff Appraisal. Possible cause(s): ...
Unable to find Manager from another entity in the list, when going through 'Appraiser Replacement' under Appraisal > Employee Appraisal > Transaction
Scenario: Employee from Company A requires approval from Company B Manager for Appraisal Solution: 1) Ensure the Manager has been assigned with ‘Appraisal Manager Group’ under Personnel > Processes > Access Right 2) Go to Company A hierarchy > locate ...
Why can't the appraisal be closed after the staff acknowledged
Symptoms: The Default Appraisal Administrator will be the one who can close the appraisal. Possible cause(s): None Suggested workaround/ solution(s): To check who is the 'Default Appraisal Administrator' Under Appraisal > Appraisal Management > ...
How to change Plan on Self-Appraised Mid-Year Appraisal after manager completed the self appraisal
Symptoms: How to change Plan on Self-Appraised Mid-Year Appraisal after manager completed the self appraisal Possible cause(s): None Suggested workaround/ solution(s): The manager will need to commit the appraisal first. Next, go back to the ...
Can second appraiser re-appraise staff if Appraisal status is shown as "Appraisal Completed"?
Symptoms: Second appraiser want to re-appraise staff, however the appraisal status is already shown as "Appraisal Completed" and the "Staff Final Rating" button is no longer available as staff already acknowledged the final rating given by the second ...