A product defect has been identified which will cause the FNMS Compliance Reconcile failed in the Writer 'InstalledSoftwareAlerts' steps. Or an Red error while the user is viewing "VMware Inventory" page in UI.
The failure message can be found in either import.log or WEBUI.log with the following wordings:
2020-09-22 03:20:57,289 [INFO ] InstalledSoftwareAlerts
2020-09-22 03:20:57,461 [INFO ] Failed to execute Writer 'InstalledSoftwareAlerts' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\InstalledSoftware.xml, at step line 40
Error: Conversion failed when converting the nvarchar value '12.1.0.2.0' to data type int.
2020-09-22 03:20:57,461 [INFO ] All retries have been attempted for Writer 'InstalledSoftwareAlerts'
2020-09-22 03:20:57,477 [ERROR] System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value '12.1.0.2.0' to data type int.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier)
ClientConnectionId:8171c472-5a5b-4aee-97f4-3576e0945d0c
Error Number:245,State:1,Class:16
The defect JIRA number is IOJ-2118477 - "InstalledSoftwareAlerts import writer step or viewing "VMware Inventory" page in UI may fail with "Conversion failed when converting the nvarchar value '...' to data type ..."
The affected FNMS version can be 2019 R1, R2 and 2020 R1.
This problem under consideration to be addressed in a future release.
** Please be advised If you believe that this problem may be affecting you, contact Flexera Support to discuss whether a hotfix or workaround may be available that is applicable to your situation.
Sep 24, 2020 01:58 AM - edited Sep 24, 2020 08:18 PM
I have an ongoing case with support since a couple of days to get ideas how to resolve this error. Anyone in the forum that stumbled into this issue running 2020R1 and can share your thoughts of how to resolve it?