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.

 

Environment

Release : 15.9.2

Component : CLARITY PROJECT MANAGEMENT

Resolution

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

1. Run the following query:

SELECT defs.id, defs.lookup_type,count(*)
FROM odf_picklist_defs defs, odf_item_positions pos
WHERE pos.picklist_def_id = defs.id
GROUP BY defs.id,defs.lookup_type
HAVING count(*) > 10000
order by 3 desc

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

Please contact Support for assistance.