search cancel

Post to WIP job fails with error "duplicate key row in PPA_WIP_VALUES"

book

Article ID: 242145

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Post to WIP job fails with error "duplicate key row in PPA_WIP_VALUES"

Log files show the following error:
ERROR 2022-05-10 04:02:26,844 [Dispatch Post to WIP : [email protected] (tenant=clarity)] niku.njs (clarity:dbos:38497929__45671E80-45F5-49FC-BE8B-DB2AF3793B44:Post to WIP) Error executing job: 7363716
com.niku.union.persistence.PersistenceException: 
SQL error code: 2601
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'niku.PPA_WIP_VALUES' with unique index 'PPA_WIP_VALUES_U1'. The duplicate key value is (12600384, BILLING).
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
SQL error code: 50000
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]20890_Error during SELECT in SQL Server
SQL error code: 3902
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

Environment

Clarity 15.9.1

Resolution

Restart the Clarity services