PRTEAM table needs a unique not null key on PG

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

PRTEAM table needs a unique not null key on PostgreSQL in order to reclaim space online

STEPS TO REPRODUCE:

1. Check table PRTEAM describe DDL definition
2. Note there is no Primary Key or UNIQUE NOT NULL KEY. PRID is nullable

Expected Results: PRTEAM to have primary key or not-null unique key

Actual Results: No primary key/not-null unique key on this table, which requires Full Vacuum to be run on the table to reclaim space (requiring downtime)

Environment

Release : 15.9.3

Resolution

• This is DE62846, fixed in 16.0.1
• Request downtime for full vacuum on this table to remove bloat