Duplicates observed while retrieving data using ODATA

Products

• Clarity PPM SaaS

Issue/Introduction

SUMMARY: Odata Endpoint is returning Duplicated Records in their Response

STEPS TO REPRODUCE:

1. Take a Clarity System with about 1000 time entry Users and Time Reporting Periods starting from 2020.
2. Configure the system with Odata.
3. Run the datawarehouse jobs to populate DWH tables.
4. On DWH DB, validate if DWH_TME_MISSING_TIME_V has any duplicates by using

select resource_key,time_period_key,count(1)
from dwh_tme_missing_time_v
group by resource_key,time_period_key
having count(1) > 1

5. Configure the system with Odata.
6. Use Odata endpoint to retrieve all the records of the View mentioned in step 4.

Expected Results :- Retrieved records won't have any duplicated data.

Actual Results :- Retrieved records show some records which are duplicated and total count also doesn't match.

Note:

This issue can happen with any other table. The one mentioned above is an example.

Environment

v16.3.1

Cause

Due to DE168459

Resolution

Fixed in Clarity Data Warehouse OData-2.0.3.4_2.0.2.6. The fix is implemented in Broadcom SaaS.