Compliance import fails with "Nullable object must have a value."

[#1]

Summary

This article describes a known issue that compliance import may fail with "Nullable object must have a value."

Symptoms

Compliance import may with the following error:

2018-01-17 06:39:47,000 [INFO ] Processing bundle install license SharePoint Server(11244) for 4 out of 4 products installed.
2018-01-17 06:39:47,094 [INFO ] Processed a total of 57 installed software records.
2018-01-17 06:39:47,094 [INFO ] Processing bundle install license Core Infrastructure Server Suite(11296) for 9 out of 9 products installed.
2018-01-17 06:39:47,406 [ERROR] System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Nullable object must have a value.
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseAvailability.get_IsHostOverridden()
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.MSServerProcessorBasedLicenseAvailability.GetLinkCap(LicenseComputerLink link)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.PointsBasedLicenseAvailability.CapPointsConsumedForVMsOnHost(LicenseComputerLink link, Int32& licensePointsConsumed)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.PointsBasedLicenseAvailability.AddVMPointsToNewLink(LicenseComputerLink link, Int32& licensePointsConsumed)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.ComputerBasedLicenseAvailability.CreateLicenseLinkAndUpdateLicenseInstallCount(Boolean p_IsPrimaryProduct, Boolean p_IsOverflowBundle)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.BundleInstallHelper.ProcessLicenseInstall(ReconcileInstalledSoftwareCollection& p_InstalledSoftwareToSave, DateTime& p_LastBatchTime, SoftwareLicenseComplianceInfo p_License, Int32 p_NumProductsDelta)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.BundleInstallHelper.ProcessInstalls()
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.RunInstallBasedReconcile()
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.PerformLicenseReconcile(Int32 p_LicenseMeasurementID, Boolean p_isPartial)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.ReconcileLicenses(Nullable`1 p_OverrideLicenseMeasurementID, String PublisherFilter)
at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.ReconcileLicenses(String PublisherFilter)
? End of inner exception stack trace ?
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ManageSoft.Compliance.Importer.Logic.XML.ProcedureItem.ExecuteAssembly()
at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier)
2018-01-17 06:39:48,234 [INFO ] Completed with error in 2 minutes, 32 seconds
2018-01-17 06:39:48,250 [INFO ] Released application lock Writer_Source_LicenseReconciliation_ALL
2018-01-17 06:39:48,266 [INFO ] Released application lock ManageSoftComplianceImporter_Exclusive
2018-01-17 06:39:48,375 [INFO ] Time: 17 January 2018 06:39:48
2018-01-17 06:39:48,375 [INFO ] Total import time: 6 hours, 9 minutes, 42 seconds
2018-01-17 06:39:48,375 [INFO ] 37 source data warnings
2018-01-17 06:39:48,375 [INFO ] 1 errors, 0 warnings

Resolution

PLEASE NOTE THE PATCH IS ONLY FOR FNMS 2017 R1. Contact technical support if the issue is with any other version of FNMS.

1) Download FNMS-57210.zip attached to this article and unzip.
2) Replace the 3 dlls in the patch with the same name under
C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin
* Take back up of the original files just in case.
3) Run the SQL script in the patch on the FNMSCompliance database.
4) Run compliance import and see if it runs successfully.