Known Issue: Red error bar saving inventory settings when enabling IBM PVU settings after upgrading from 2019 R2 or earlier release to 2020 R1 with error in webui.log: "Object reference not set to an instance of an object at [...].CheckInternalDBObjects" (IOJ-2134925)

[#1]

Summary

A red error bar may be displayed in the web UI when saving changes to enable IBM PVU options on the inventory settings page on a FlexNet Manager Suite installation that has been upgraded from release 2019 R2 or earlier to 2020 R1 or later.

Details

This issue occurs because some internal targets used by the IBM PVU inventory scanning functionality may not be configured as expected during the upgrade process.

Logging that appears in webui.log when this occurs looks similar to the following:

[ERROR 2020-07-24 12:09:40,302 16706129ms UnhandledErrors ] An unexpected error occurred (8359216b-df2d-4ca5-8e1c-29cce3cc4ce0)
System.NullReferenceException: Object reference not set to an instance of an object.
 at ManageSoft.Compliance.Logic.Core.Impl.IBMPVUScan.IBMPVUScanSaver.CheckInternalDBObjects(Boolean enableClusterServerScans, PolicySummary policySummary)
 at ManageSoft.Compliance.Logic.Core.Impl.IBMPVUScan.IBMPVUScanSaver.CheckInternalTargetsAndRules(PropertyValueCollection globalProperties)
 at ManageSoft.Compliance.Logic.Core.Impl.BeaconPolicyLogic.CheckInternalTargetsAndRules()
 at ManageSoft.Compliance.Logic.Core.Impl.BeaconPolicyLogic.SaveTargetSetting(IEnumerable`1 ibmPvuTargetIDs, IEnumerable`1 VirtualClusterServersTargetsIDs)
 at Flexera.Web.Logic.Services.IMSettings.IMSettingsService.SaveIBMPVUScanSettings(IMSettingsModel model)
 at Flexera.Web.Logic.Services.IMSettings.IMSettingsService.SaveIMSettings(IMSettingsModel model)
[...]

Resolution

This problem can be resolved by running the following SQL script against the compliance database to ensure steps that should be done during the database migration are performed:

DECLARE @ErrorNo INT, @TenantID SMALLINT
SELECT  @ErrorNo = 0

SELECT @TenantID = MIN(TenantID) FROM dbo.Tenant WHERE TenantID > 0
SELECT @ErrorNo = @@ERROR

WHILE @TenantID IS NOT NULL AND @ErrorNo = 0
BEGIN
	IF NOT EXISTS(SELECT * FROM dbo.BeaconTarget_MT WHERE Name = 'Known vCenter or OVM Manager servers' AND TenantID = @TenantID)
		INSERT INTO dbo.BeaconTarget_MT (Description, Internal, Name, Visible, TenantID)
		VALUES ('This target includes all known VMWare vCenter and Oracle VM Manager servers. This information is needed if IBM PVU inventory is being gathered.', '1', 'Known vCenter or OVM Manager servers', '0', @TenantID)

	IF NOT EXISTS(SELECT * FROM dbo.BeaconTarget_MT WHERE Name = 'All devices consuming IBM PVU points' AND TenantID = @TenantID)
		INSERT INTO dbo.BeaconTarget_MT (Description, Internal, Name, Visible, TenantID)
		VALUES ('This target includes all computers that are currently consuming points from an IBM PVU license.', '1', 'All devices consuming IBM PVU points', '1', @TenantID)

	-- Get next tenant
	SELECT @TenantID = MIN(TenantID) FROM dbo.Tenant WHERE TenantID > @TenantID
	SELECT @ErrorNo = @@ERROR
END

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2 (On Premises), 2020 R2 / Nov 2020 (Cloud)

Other information

Affected components: SAM for IBM, VMware discovery & inventory, Web UI

Master issue ID: IOJ-2134925

Also known as: FNML-71550