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.
Release : 15.9.2
Component : CLARITY PROJECT MANAGEMENT
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.