Unable to delete old projects
search cancel

Unable to delete old projects


Article ID: 245505


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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.


   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.