Red error bar message displayed with error in webui.log when viewing Application > Evidence tab or Evidence > Applications tab if an evidence rule is linked to an application multiple times: "The result collection contains duplicate objects"

Description

Summary

If an installer or file evidence recognition rule is linked multiple times to an application, a red error bad error is shown in the UI when attempting to view the Evidence tab on the application, or the Applications tab on the evidence.

Details

Logging in the webui.log file on the web application server of a FlexNet Manager Suite system shows messages similar to the following when this issue occurs:

[ERROR 2022-05-17 12:59:41,736 482846ms UiHelper_Grid                          ] Error retrieving data (f8c83f35-fe98-47a0-bf94-4ec2a7409b52)
System.InvalidOperationException: The result collection contains duplicate objects.
   at DevExpress.Xpo.Helpers.ObjectCollectionLoader.EndLoadObjects(LoadObjectsContext loadObjectsContext, ICollection[] objs, Boolean proceesStubs)
[...]
   at DevExpress.Data.Helpers.ServerModeKeyedCache.FetchInIndexerCore(Int32 index)
[ERROR 2022-05-17 12:59:41,783 482893ms UnhandledErrors                        ] An unexpected error occurred (f8c85f35-fe48-4780-be94-4ecca7409b52)
ManageSoft.Compliance.ComplianceException: An error occurred retrieving grid data, see log for details
   at Flexera.Web.Core.Display.UiHelper_Grid.GridDataRetrievalError(Object sender, Exception e)
   at DevExpress.Data.Linq.LinqServerModeDataSourceView.OnExceptionThrown(ServerModeExceptionThrownEventArgs e)
[...]
   at DevExpress.Web.ASPxWebControl.System.Web.UI.ICallbackEventHandler.GetCallbackResult()
[ERROR 2022-05-17 12:59:42,111 483221ms ClientErrors                           ] Client error. [
	RequestUID: f8c83f35-fe98-47a0-bf94-4ec2a7409b52
	URL: https://fnms.acme.com/Suite/Applications/Edit/-373375?originUrl=%2FSuite%2FApplications%2FList%2FAll#Evidence
	Context URL: /Suite/Applications/Edit_Evidence_Installer_Grid/-373375?originUrl=%2FSuite%2FApplications%2FList%2FAll
	Line: 
	Column: 
	Referrer: https://fnms.acme.com/Suite/Applications/List/All
	Screen dimensions: 1280x720
	User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36
	User language: 
	Platform: Win32
	Cookies enabled: true
	Do not track: 
	Message: Internal Server Error
	Stack: 
]

Queries like the following can be executed against the compliance database to identify evidence/application links which may trigger this issue to occur. These queries identify the IDs of installer and file evidence records and associated application (software title) records that are linked multiple times:

; WITH p AS (
	SELECT SoftwareTitleID, InstallerEvidenceID
	FROM dbo.SoftwareTitleInstallerEvidence
	GROUP BY SoftwareTitleID, InstallerEvidenceID
	HAVING COUNT(*) > 1
)
SELECT sti.SoftwareTitleID, sti.SoftwareTitleName, ie.InstallerEvidenceID, ie.DisplayName, ie.Version, ie.Publisher
FROM p
	JOIN dbo.SoftwareTitleInfoLimited sti ON sti.SoftwareTitleID = p.SoftwareTitleID
	JOIN dbo.InstallerEvidence ie ON ie.InstallerEvidenceID = p.InstallerEvidenceID

; WITH p AS (
	SELECT SoftwareTitleID, FileEvidenceID
	FROM dbo.SoftwareTitleFileEvidence
	GROUP BY SoftwareTitleID, FileEvidenceID
	HAVING COUNT(*) > 1
)
SELECT sti.SoftwareTitleID, sti.SoftwareTitleName, fe.FileEvidenceID, fe.FileName
FROM p
	JOIN dbo.SoftwareTitleInfoLimited sti ON sti.SoftwareTitleID = p.SoftwareTitleID
	JOIN dbo.FileEvidence fe ON fe.FileEvidenceID = p.FileEvidenceID

Fix status

This issue has been fixed in the following releases: 2023 R2 (On Premises), 2023 R2.1 / Jan 2024 (Cloud).

Was this helpful?

Support Hub

Product

Flexera One

Affected functionality

Web UI

Deployment type

Cloud

Fixed in

2023 R2 (On Premises),2023 R2.1 / Jan 2024 (Cloud)

Visibility

Guest

URL Name

red-error-bar-message-displayed-with-error-in-webui-log-when-viewing-application-evidence-tab-or-evidence-applications-tab-if-an-evidence-rule-is-linked-to-an-application-multiple-times-the-result-collection-contains-duplicate-objects-IOK-991093

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Revenera Assistant

Summary

Details

Related Articles

Please wait...

Case id: 00001065