Unable to delete old projects

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

 

   

Environment

Release : 16.0.2

Component : Clarity Project Management

Cause

Trigger trigger_fct_tr_projcntrts_delete has an error in the code for Postgres.

Reported as DE65804

Resolution

Resolved in 16.1.0. This was originally tracked as DE65804.