If there are old projects that had contracts associated with Earned Value Manager add-in or Advanced Billing option the records are in a specific table. When the delete investments job runs a trigger associated with this table is activated and because the trigger has an error, the delete investment job completes but the investment is not deleted.
This appears to be Postgres database only.
STEPS TO REPRODUCE:
1. There have to be records in table PROJCNTRTS
- These were populated when Clarity had the Advanced Billing feature (pre v 13)
2. Select a project to delete that is in this table.
3. Run the Delete Investment Job
Expected Results: Investment Deletes
Actual Results: Job completes but the investment does not get deleted.
The logs may show something similar to :
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying <> integer
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Where: PL/pgSQL function trigger_fct_tr_projcntrts_delete() line 61 at IF
Workaround: none
Release : 16.0.2
Component : Clarity Project Management
Trigger trigger_fct_tr_projcntrts_delete has an error in the code for Postgres.
Reported as DE65804
Resolved in 16.1.0. This was originally tracked as DE65804.