Known Issue: Error in webui.log when viewing Installer Evidence tab of Discovered Device record: "System.InvalidOperationException: The result collection contains duplicate objects." (IOJ-2158825)
Known Issue: Error in webui.log when viewing Installer Evidence tab of Discovered Device record: "System.InvalidOperationException: The result collection contains duplicate objects." (IOJ-2158825)
Summary
A red error bar error may appear in the web UI when viewing the Installer Evidence tab of a Discovered Device record.
Symptoms
The C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on a FlexNet Manager Suite On Premises web application server shows errors similar to the following when this issue occurs:
[ERROR 2020-10-13 12:49:25,753 1036087953ms UiHelper_Grid ] Error retrieving data (66d3a19c-a1f8-4c2a-be7f-b6bb30ae8167)
System.InvalidOperationException: The result collection contains duplicate objects.
at DevExpress.Xpo.Helpers.ObjectCollectionLoader.EndLoadObjects(LoadObjectsContext loadObjectsContext, ICollection[] objs, Boolean proceesStubs)
at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
[...]
at DevExpress.Data.Helpers.ServerModeKeyedCache.FetchInIndexerCore(Int32 index)
[ERROR 2020-10-13 12:49:25,769 1036087969ms UnhandledErrors ] An unexpected error occurred (66d3a19c-a1f8-4c2a-be7f-b6bb30ae8167)
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.Data.Helpers.ServerModeCache.PerformDeathProofAction(Action action)
[...]
at Flexera.Web.Core.Display.UiHelper_Grid.BindGridCore(UiHelper ui, MVCxGridView grid, GridCustomSettings settings, Boolean loadAll)
at Flexera.Web.Core.Display.UiHelper_Grid.<>c__DisplayClassb3.<ConfigureServerEvents>b__a9(Object sender, EventArgs eventArgs)
at DevExpress.Web.ASPxWebControl.RaiseBeforeGetCallbackResult()
at Flexera.Web.Core.Display.MVCxGridViewCustom.RaiseBeforeGetCallbackResult()
at DevExpress.Web.ASPxWebControl.System.Web.UI.ICallbackEventHandler.GetCallbackResult()
[ERROR 2020-10-13 12:49:26,003 1036088203ms ClientErrors ] Client error. [
RequestUID: 66d3a19c-a1f8-4c2a-be7f-b6bb30ae8167
URL: http://server/Suite/Devices/Edit/7247?originUrl=%2FSuite%2FDevices%2FList%2FDiscovered#Inventory_Evidence
Context URL: /Suite/Devices/Edit_Evidence_Software_Grid/7247?externalComputerId=19420&originUrl=%2FSuite%2FDevices%2FList%2FDiscovered
[...]
Resolution
For FlexNet Manager Suite On-Premises Edition deployments, contact Flexera Support who may be able to provide an update to a stored procedure suitable for your environment.
Fix status
This issue has been fixed in the following FlexNet Manager Suite releases: 2022 R2 (On Premises), 2022 R2 / Nov 2022 (Cloud)
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.
