Task Delete or Delete Investment Job Performance Issue

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When deleting a task from the Modern UX, the deletion is slow and projects get locked for editing for too long.

While using the timeline view in a project, and deleting a task, there is a performance issue.
If trying to delete from the grid view, it will take ~1 minute to finish.

The Delete Investments and Time Reporting Periods job is also noticed to be slow.

Resolution

This is reported as DE62541 and is determined to be a data issue, not a defect.

1. Run the following query:

SELECT defs.context_id, ctx.name, ctx.code, defs.id, count(*)
FROM odf_picklist_contexts ctx, odf_picklist_defs defs, odf_item_positions pos
WHERE 1=1
and defs.lookup_type = 'prTaskStatus'
AND pos.picklist_def_id = defs.id
AND ctx.id = defs.context_id
and pos.object_code = 'task'
GROUP BY defs.context_id, ctx.name, ctx.code, defs.id
order by count(1) desc

 

2. Based on the results, a delete statement can be constructed to provide immediate resolution

Please contact Support for assistance.