Duplicate records at weekly aggregate table

[joshuastanley]

Hi All,

We are having duplicates at weekly aggregates table when the timesheet submitted from the timesheet portal. Have anyone faced similiar situation. Is so how to track this down and find out the script creating the duplicates.

Regards, Joshua

[joshuastanley · Accepted solution]

Hi All,

Just got an update from support saying that this issue might be due to the multi node processing enabled. This might result in the creation of duplicate records at the same time. Please keep this in mind when getting duplicate records at any application, look for any event processing by multi node mode.

Thanks.

[joshuastanley]

Hi All, This looks like a product issue and ServiceNow has raised a PR to get this fixed at their future release Zurich

[Mark245]

Hi @joshuastanley 

Is there any work around regarding the duplicate records that are being generated in weekly aggregate table?

Thank you!

[joshuastanley]

ServiceNow provided a fix at one of the script include to process the records at one shot, rather than processing on the updated time. This reduced the duplicate records by 99%

[Mark245]

Did they share the code? Is it okay to share the component and its script for that?
Thank you!