- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: Any changes on Inventory setting page is throwing error while trying to save
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think we can go one better than @jjensen's suggestion and actually post the script to resolve this problem here. 🙂
Execute the following SQL script against your FlexNet Manager Suite compliance database, and hopefully it will stop the error from occurring:
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
For reference, here is the error message that appears in the webui.log file that this script is intended to resolve on systems that have been upgraded from FlexNet Manager Suite release 2019 R2 or earlier to 2020 R1:
[ERROR 2020-07-24 12:09:40,302 16706129ms UnhandledErrors ] An unexpected error occurred (...) 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) [...]
See the following article for more information about this issue: 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).
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
An "Unexpected error" shown in the UI like that will normally be accompanied by some additional details in the C:\ProgramData\Flexera Software\Compliance\Logging\WebUI\webui.log file on the web application server. These details are likely to give more insight into exactly where and why the error is occurring.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @winvarma,
Seems likely that you are hitting a known issue that was resolved in 2020 R2:
IOJ-2134925 - "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" "
There is a SQL fix available. Please raise a ticket with Support, quoting the above issue number, and request a copy of the SQL fix.
HTH,
Joseph
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think we can go one better than @jjensen's suggestion and actually post the script to resolve this problem here. 🙂
Execute the following SQL script against your FlexNet Manager Suite compliance database, and hopefully it will stop the error from occurring:
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
For reference, here is the error message that appears in the webui.log file that this script is intended to resolve on systems that have been upgraded from FlexNet Manager Suite release 2019 R2 or earlier to 2020 R1:
[ERROR 2020-07-24 12:09:40,302 16706129ms UnhandledErrors ] An unexpected error occurred (...) 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) [...]
See the following article for more information about this issue: 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).
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Chris & Jensen,
thanks for the quick inputs and let me try executing the script and check.
Regards,
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ChrisG ,
As suggested have executed the script and that resolved the issue. Appreciate the way you see the issues and try to give instant solutions/workarounds instead of raising a support case unless there is no other option.
I wish i could be an Expert like you someday, Many thanks for All your guidance to the Forum Members. 🤝
Regards,
Winvarma
