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

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 : mybgserver (tenant=clarity)] niku.njs (clarity:myuser:mysession: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

Any Clarity release

Resolution

Restart the Clarity services and run the Job once again. This is generally a caching issue

If a simple service restart does not help, please proceed as follows:

1. Run the following query against the DB:

    SELECT * FROM PPA_TRANSCONTROL ORDER BY TRANSDATE ASC

2. Check the date oldest transaction to be posted

3. Home > Financial management > Post to WIP, filter by the date noted on Step 2

4. Click Apply > click Post

5. If the transactions got posted with no error, continue posting the transactions on time batches until all have been processed