In Classic, Custom portlet on Action Items Provider is taking 19+ min with Filter on AssigneeID and causing performance issues

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When using a custom portlet with OOTB data provider on Action Items in Classic and multi-select filtering on Assignee ID, the query generated is very slow and causes performance issues in Clarity

STEPS TO REPRODUCE:

• Use a large dataset data with similar amounts to the below:
  • Resources in the system: 85K
  • Action Items in the system 25K

1. With Admin user, connect to Administration – Portlets
2. Create a new custom Grid portlet with Data Provider Action Item
3. Finish and open
4. In List Column Section, add the columns Assignee ID, Created Date, Due Date, Object Type, Send Reminder
5. In List Filter Section, Add Object Type, Due Date and Assignee ID
6. Enable Allow Power Filter
7. Now go to Fields – click on the icon for Assignee ID
8. Lookup Style – Switch it to Multiple Select, Save
9. Now add this portlet to a new tab in General – Overview
10. Go to the tab, note the portlet is opening fairly fast
11. Now use the filter on Assignee ID:
    • Option 1 - in regular filter – add 2+ resources to Assignee ID
    • Option 2 – create a power filter to include 2+ resources in Assignee ID with OR condition 

Expected Results: The portlet to open within reasonable time

Actual Results: The portlet takes over 19 min to return results, page is spinning, the slow query is getting stuck in Oracle. If the user gets impatient and opens a few of the requests, this may cause performance issues to all users

Environment

Clarity 16.2.3

Cause

DE160771 

Resolution

This is DE160771, in review by Engineering

Workaround: Do not use multi-select filter on Assignee ID, only use single select Filter / Power Filter