The DWH table 'DWH_SEC_GROUP_HIER' has duplicate rows for the GROUP_HIER_KEY field

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The database description for the field 'GROUP_HIER_KEY' indicates 'This column refers to the unique identifier of a row in this table'. However we found duplicate records when we query the 'DWH_SEC_GROUP_HIER' table through OData where the GROUP_HIER_KEY = 53738. 

Steps to Reproduce:

1. Run the following query and observe the results

select group_hier_key, count(*) 

from DWH_SEC_GROUP_HIER dsgh 

group by GROUP_HIER_KEY 

having count(*) > 1 

Expected Results: There should only be one row with this value. 

Actual Results: There are two rows with this value. 

Environment

Release: 16.0.1, 16.0.2 

Cause

DE64956 

Resolution

Targeted Fix in Release 16.0.3