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

book

Article ID: 242834

calendar_today

Updated On:

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. 

Cause

DE64956 

Environment

Release: 16.0.1, 16.0.2 

Resolution

Targeted Fix in Release 16.0.3