Loading
search-img
Web UI grid pages may show error with error in webui.log if custom property names have mismatched case between *Property_MT and UIItem_MT database tables: "An item with the same key has already been added"
Description

Summary

Web UI grid pages such as All Assets, All Contracts and others may be show an error if custom properties are configured, and where the case differs in custom property names specified in the following table columns in the compliance database:

  • <Object type>Property.PropertyName
  • UIItem.ItemResourceName

Details

The following error message is displayed when this problem occurs: 

We have a problem. Unexpected error
Sorry, but something unpleasant has happened. Please let us know what you were trying to do so that we can fix the problem. We suggest starting again from the dashboard, or trying again later.

Logging in the webui.log file may show details like the following:

[ERROR 2021-01-11 06:07:24,413 1127412ms UnhandledErrors                        ] An unexpected error occurred (f6dbcf18-5eeb-45d1-90ce-22973ad9909f)
System.Web.HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at DevExpress.Xpo.Metadata.ReflectionClassInfo.QueryOwnMember(String memberName)
   at DevExpress.Xpo.Metadata.XPClassInfo.FindMember(String memberName)
   at DevExpress.Xpo.Metadata.Helpers.MemberInfoCollection.FindMember(XPClassInfo currentClassInfo, String match)
   at DevExpress.Xpo.Metadata.Helpers.MemberInfoCollection..ctor(XPClassInfo classInfo, String[] matches, Boolean addNonPersistent, Boolean throwOnError)
   at DevExpress.Xpo.Metadata.XPClassInfo.ParsePath(String path)
   at DevExpress.Xpo.Parser.MemberAccess(MemberExpression expression, CriteriaOperator parent, XPClassInfo currentClassInfo)
[...]
   at DevExpress.Xpo.XPQueryBase.Where(MethodCallExpression call)
   at DevExpress.Xpo.XPQueryBase.Call(MethodCallExpression call)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
[...]
   at ManageSoft.Database.Xpo.XpoQueryCustom`1.CreateQuery(Expression expression, XPQueryBase col)
[...]
   at Castle.Proxies.IDisposableProxy_12.GetChangedDevice()
   at Flexera.Web.Presentation.Controllers.AssetsController.GetAssets[T](AssetState assetState)
[...]
   at ASP._Page_Views_Assets_List_cshtml.Execute() in C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\WebUI\Views\Assets\List.cshtml:line 64

Alternatively, the following details may appear in logging: 

[ERROR 2022-02-15 18:31:45,695 1173697ms UnhandledErrors       ] An unexpected error occurred (245638ec-31e3-48c9-81bf-0879ed2117b8)
System.Web.HttpException (0x80004005): Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at DevExpress.Xpo.Metadata.ReflectionClassInfo.QueryOwnMember(String memberName)
   at DevExpress.Xpo.Metadata.XPClassInfo.FindMember(String memberName)
   at DevExpress.Xpo.Metadata.XPClassInfo.GetMember(String memberName)
   at ManageSoft.Database.Xpo.XpoSession.OverrideSortColumn(Type p_ObjectType, String p_Column, Func`2 p_SortSqlFunc)
   at Flexera.Web.Core.Display.UiHelper_Grid.OverrideSortValueRangeColumn(String columnName, Type propertyType, XpoSession session, Type elementType, IEnumerable`1 dataSource)
   at Flexera.Web.Core.Display.UiHelper_Grid.ConfigureRangeColumn(UiHelper ui, MVCxGridViewColumn column, ModelMetadata propertyMetadata, GridCustomSettings settings)
   at Flexera.Web.Core.Display.UiHelper_Grid.ConfigureColumns(UiHelper ui, GridCustomSettings settings, Boolean allowScrolling)
   at Flexera.Web.Core.Display.UiHelper_Grid.ConfigureGrid(UiHelper ui, GridCustomSettings settings, Func`2 noResultsRazor, Boolean allowScrolling, Boolean delayLoad, Boolean showAllRecords)
   at Flexera.Web.Core.Display.UiHelper_Grid.<>c__DisplayClass2.<Grid>b__1(GridCustomSettings settings)
   at Flexera.Web.Core.Display.DevExpressHelper.GridViewCustom(ExtensionsFactory factory, Action`1 method)
   at Flexera.Web.Core.Display.UiHelper_Grid.RenderGridInternal(UiHelper ui, IViewModel modelType, IEnumerable modelList, Action`1 customSettings, GridCustomSettings baseSettings)
   at Flexera.Web.Core.Display.UiHelper_Grid.RenderGrid(UiHelper ui, IViewModel modelType, IEnumerable modelList, Action`1 customSettings, GridCustomSettings baseSettings)
   at Flexera.Web.Core.Display.UiHelper_Grid.GridForModel(UiHelper ui, Func`2 toolbarRazor, Func`2 noResultsRazor, Boolean allowSelection, Boolean crossPageSelection, Boolean showFilter, Boolean showSearch, Boolean delayLoad, Boolean showToolbar, GridCustomSettings baseSettings)
   at ASP._Page_Views_Assets_List_Grid_cshtml.Execute() in c:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\WebUI\Views\Assets\List_Grid.cshtml:line 52
[...]
   at ASP._Page_Views_Assets_List_cshtml.Execute() in c:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\WebUI\Views\Assets\List.cshtml:line 64

Resolution

To resolve this issue, ensure the case in the values in the <Object type>Property.PropertyName and UIItem.ItemResourceName columns exactly match so that there are no mismatches between uppercase and lowercase characters between these columns.

For example, the following SQL query can be executed against the compliance database to identify rows in the AssetTypeProperty view that have no corresponding rows in the UIItem view - if any rows are returned then this issue is likely to be triggered:

SELECT *
FROM dbo.AssetTypeProperty
WHERE PropertyName COLLATE SQL_Latin1_General_CP1_CS_AS NOT IN (
    SELECT ItemResourceName COLLATE SQL_Latin1_General_CP1_CS_AS
    FROM dbo.UIItem
)

Perform the following steps to correct problematic data:

  1. Take a copy of data in the AssetTypeProperty view for future reference if needed. This can be simply done by copying the data from the output of running the following SQL query into a file (such as an Excel spreadsheet): 
    SELECT * FROM dbo.AssetTypeProperty
  2. Run the following SQL statements to update property names to match the case specified in the UIItem view: 
    SELECT ItemResourceName
INTO #TT
FROM dbo.UIItem WHERE ItemResourceName IN (
  SELECT DISTINCT PropertyName
  FROM dbo.AssetTypeProperty
  WHERE PropertyName COLLATE SQL_Latin1_General_CP1_CS_AS NOT IN (
    SELECT ItemResourceName COLLATE SQL_Latin1_General_CP1_CS_AS FROM dbo.UIItem
  )
)

UPDATE t
SET t.PropertyName = s.ItemResourceName
FROM dbo.AssetTypeProperty t
  INNER JOIN #TT s ON t.PropertyName COLLATE SQL_Latin1_General_CP1_CI_AS = s.ItemResourceName COLLATE SQL_Latin1_General_CP1_CI_AS
  3. Verify that re-running the initial query above now returns no rows to confirm that the problematic data has been corrected.

Similar steps to those described above can be followed for other object types (instead of the “Asset” object type). References to the AssetTypeProperty view should be replaced with the appropriate view name containing custom property definitions for the object type in question.

Cause

This issue is caused by case-insensitive comparisons that are done between property names in different tables since the FlexNet Manager Suite 2020 R2 release.

Fix status
This issue has been fixed in the following releases: 2023 R2.4 / Apr 2024 (Cloud), 2024 R1 (On Premises).
Was this helpful?
Support Hub
Product
Flexera One
Deployment type
Cloud
Fixed in
2023 R2.4 / Apr 2024 (Cloud),2024 R1 (On Premises)
Visibility
Guest
URL Name
web-ui-grid-pages-may-show-error-with-error-in-webui-log-if-custom-property-names-have-mismatched-case-between-property-mt-and-uiitem-mt-database-tables-an-item-with-the-same-key-has-already-been-added-IOJ-2172965

Related Articles

Create a case with Support
0/255
Upload Attachment
File Upload
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 cancel the case creation?

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.
Book an Appointment
File Upload
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)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
Web UI grid pages may show error with error in webui.log if custom property names have mismatched case between *Property_MT and UIItem_MT database tables: "An item with the same key has already been added"