Known Issue: An update to an asset may fail if the update causes changes to a linked inventory device (IOK-1002838)

[#1]

Summary

Processes that attempt to update an asset record may fail if the update causes changes to property values on a linked inventory device record.

Details

This issue is caused by a logic error affecting operations in the FlexNet Manager Suite compliance database.

Processes that may be affected by this issue include the following:

Process	Symptoms
Updates to asset records performed through the web UI	Red bar error is shown in the web UI. Logging in webui.log includes an error message with details similar to: Invalid column name 'ComplianceComputerID'. Invalid column name 'ComplianceComputerID'. Invalid column name 'ComplianceComputerID'. Invalid column name 'ComplianceComputerID'. Invalid column name 'ComplianceComputerStatusID'. Invalid column name 'newStatus'. Invalid column name 'oldStatus'.
Inventory imports Business adapter imports	Import fails, and import log includes an error message similar to what is shown above.

Resolution

A hotfix to resolve this issue is available from the following article: Hotfix for Known Issue: An update to an asset may fail if the update causes changes to a linked inventory device (IOK-1002838)

Affected versions

This issue affects FlexNet Manager Suite 2022 R2.

Fix status

This issue has been fixed in the following FlexNet Manager Suite release: 2022 R2.1 / Jan 2023 (Cloud)

Other information

Affected components: Database, Hardware asset management, Inventory

Master issue ID: IOK-1002838

Also known as: FNML-77254