PRTASK Updates slow on PostgreSQL

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Updates on Tasks tables such as Autoschedule Publish, Insert of new task / sibling may be slow in Clarity, deletion of tasks is slow. Any of these updates may be causing project locks that remain for several minutes. Processes on Task object may run slower than expected

Environment

Clarity 16.4.1 with PostgreSQL only

Cause

• This is DE182414
• Issue with PRTASK trigger PRTASK_UPD_TRG1 inserting too much data in table EVM_TASK_COMPLETION
• EVM_TASK_COMPLETION will grow too large and each update in PRTASK will have overhead

Resolution

Fixed in 16.4.2

Contact Broadcom Support for workaround and cleanup script