Performance on opening a Roadmap on odf_scenarios (DE60687)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

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