Just finished upgrading to Flexnet 2020 R2 from 2017 R2.
When I click any option under Hardware Asset, I get the following error:
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.
Send this text to your system administrator:
Error ID: 5bdf536e-1dc0-4fcc-86da-22ced663c184
‎Aug 10, 2021 12:23 AM
The following query can be used to check for custom asset property details with mismatching cases between the AssetTypeProperty and UIItem tables:
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
)
If this query returns any records then it suggests the issue that @mfranz has noted may affect you. Specifically, it may be the issue IOJ-2172965 noted on the FlexNet Manager Suite Unresolved Issues list.
Here is another thread discussing the same issue: Error while access any module from Hardware Assets
‎Aug 10, 2021 05:21 AM
You will likely find details associated with the error ID to guide further diagnosis and troubleshooting in the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on you web application server.
Take a look at the following article for some information about this file: How to troubleshoot unexpected errors and red error bar messages in the FlexNet Manager Suite Web UI using webui.log
‎Aug 10, 2021 02:45 AM
I got this from webui.log
How do I fix the same key issue?
[ERROR 2021-08-10 15:51:45,670 954922ms UnhandledErrors ] An unexpected error occurred (7897c118-c3a9-4e13-a7ff-75a458cb0152)
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)
‎Aug 10, 2021 02:58 AM
Hi,
This sounds like an issue we saw recently. Please check your AssetTypeProperty_MT (Property) and UIItem_MT (ItemResourceName ) tables to see if the attributes match exactly, including upper/lower case.
Best regards,
Markward
‎Aug 10, 2021 03:53 AM
The following query can be used to check for custom asset property details with mismatching cases between the AssetTypeProperty and UIItem tables:
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
)
If this query returns any records then it suggests the issue that @mfranz has noted may affect you. Specifically, it may be the issue IOJ-2172965 noted on the FlexNet Manager Suite Unresolved Issues list.
Here is another thread discussing the same issue: Error while access any module from Hardware Assets
‎Aug 10, 2021 05:21 AM
‎Aug 11, 2021 02:58 AM
Hi @ChrisG,
Can you give us an idea where this error takes effect. The database is case insensitive (CI), so I guess it must be some other component being case sensitive. Maybe a Javascript component?
Best regards,
Markward
‎Aug 11, 2021 04:07 AM
@mfranz - based on the stack trace that appears in the webui.log logging, it appears the problem arises in C# code processing data to be displayed. I'm guessing that there is some case sensitive comparison being done when it may be more appropriate to do a case insensitive comparison.
‎Aug 11, 2021 04:59 AM
For reference, the following article covers the issue discussed in this thread: Known Issue: Asset views may be inaccessible if custom property names have mismatched case between AssetTypeProperty_MT and UIItem_MT tables (IOJ-2172965)
‎Dec 09, 2021 07:27 PM