Top-N alarms duplicated in jaspersoft on Spectrum 10.1.1

Document ID : KB000045629
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

when using JasperSoft (CABI 6.1) for reporting with Spectrum 10.1.1 to run a “Top-N” style report, records are duplicated.  

 

Environment:  

Spectrum 10.1.1 with JasperSoft for reporting.

 

Cause: 

The initial root cause analysis, is that the number of duplicates is based on the number of Oneclick users.

e.g. with 4 users in Oneclick, we saw that alarms were duplicated 4 times and with 11 users on another system, alarms were duplicated 28 times for the same report type.

 

Workaround: 

Enabling SRM security resolves this problem and duplicates are removed.

 

duplicate.JPG

 

Resolution:

This currently being investigated by Sustaining Engineering as Defect DE201759 and a resolution will be published once verified.

 

Additional Information: 

This has been posted to the communities as follows:

https://communities.ca.com/message/241905646