Clarity PPM: Timesheet Open/Populate is Extremely Slow After Upgrade

book

Article ID: 142211

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

After SaaS upgraded Clarity, the Classic UI is slow opening and populating timesheets.

 

Cause

The upgrade removed the execution plans previously used before the upgrade.

The performance is due to the poor SQL execution plan being selected by the Oracle Engine.

Environment

Clarity 15.6

Resolution

Please contact Support to have a request for our SaaS DBA team to perform SQL query analysis on the PRTIMESHEET and/or PRTIMEENTRY tables.