Known Issue: 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)
Known Issue: 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)
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
GROUPBY SoftwareTitleID, InstallerEvidenceID
HAVINGCOUNT(*) > 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
GROUPBY SoftwareTitleID, FileEvidenceID
HAVINGCOUNT(*) > 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 is still open but not currently scheduled to be addressed.
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.
