Duplicates when running with persisted aggregation.

[janithcmw]

Describe the issue:
When there are similar recodes as follows in the Hours granularity, the pirmary key violation issue will occur with persisted aggregation.
agg_timestamp,agg_event_timestamp,username,serviceprovider,identityprovider,region,token,userstoredomain,isfirstlogin,identityprovidertype,meta_tenantid,remoteip,timestamp,agg_last_event_timestamp,agg_sum_successvalue,agg_sum_failurevalue,agg_sum_stepsuccessvalue,agg_sum_firstloginvalue,shard_id 1626314400000 ,1626314400000 ,user1,36,LOCAL,N/A,NOT_AVAILABLE,PRIMARY,0,SSO,-1234,<IP>,1626314856051 ,1626314856051 ,1,0,0,0,<SHARD_ID> 1626318000000 ,1626314400000 ,user1,36,LOCAL,N/A,NOT_AVAILABLE,PRIMARY,0,SSO,-1234,<IP>,1626314856051 ,1626314856051 ,1,0,0,0,<SHARD_ID>

How to reproduce:
Add the above sample recodes to the "Roleaggregation_Hours" table and trigger the aggregation flow with persisted aggreation.

Expected behavior:
There should not be primary key violation issues.

Environment information (Please complete the following information; remove any unnecessary fields) :

• Product Version: IS-Analytics-5.8.0
• OS: Not relevant
• Database: any

[isharak]

This issue is being closed due to extended inactivity. Please feel free to reopen it if further attention is needed. Thank you for helping us keep the issue list relevant and focused!