Performance on opening a Roadmap on odf_scenarios (DE60687)

book

Article ID: 212971

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

DE60687 Slow Performance on opening a Roadmap in Modern UX, requests time out or very slow to open any Roadmap. Slow query can be seen on odf_scenarios table

  1. On a large dataset, connect to Modern UX
  2. Open the Roadmaps
  3. Click on any Roadmap to open the Timeline

 

Expected Results: The query to return in a reasonable time

Actual Results: The query is extremely slow and takes over 3 min.

The slowness is happening on persistence ID odf-pmd.odf_scenario.select-list-rest-api-conditional.map

Environment

Release : 15.9, 15.9.1, 15.9.2

Component : CA PPM PROJECT MANAGEMENT

Resolution

This is DE60687, fixed in 15.9.3 and 15.9.2.1