data_engine maintenance is not populating data into the daily tables (DN_ ) for all QOS

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Our data engine data retention settings are as followed:

Delete raw data older than = 30
Delete historic data older than = 180
Delete daily average data than = 180

We noticed that UIM is not populating data into the daily tables (DN_ ) for all QOS and need to confirm if this is expected with above settings?

Environment

Release : 9.2.0, 20.1, 20.3

Component : UIM - DATA_ENGINE

Cause

This behavior is expected when "Delete historic data older than" and "Delete daily average data than"  settings are set to the same value

Resolution

The "Delete daily average data older than" setting needs to be set a higher value than the "Delete daily average data older than" in order for DN_* tables to store data