Asset views in the web UI may be inaccessible if custom properties and custom asset types are configured, and where the case differs in custom property names specified in the following table columns in the compliance database:
The following error message is displayed when this problem occurs:
Logging in the webui.log file may show details like the following:
Alternatively, the following details may appear in logging:
To resolve this issue, ensure the case in the values in the AssetTypeProperty.PropertyName and UIItem.ItemResourceName columns exactly match so that there are no mismatches between uppercase and lowercase characters between these columns.
Tip: Flexera One ITAM customers should contact Flexera Support to perform the following steps.
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:
Perform the following steps to correct problematic data:
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.
This behavior will not be changed as allowing different cases for property names causes other problems, and problematic data can be easily corrected.
This issue is still open but not currently scheduled to be addressed.
Affected components: Web UI
Master issue ID: IOJ-2172965
Also known as: ITAM-3002
Aug 23, 2021 02:28 AM - edited Nov 20, 2023 01:28 PM