Showing results for 
Show  only  | Search instead for 
Did you mean: 


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 '' 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 '' 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)
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.

Was this article helpful? Yes No
No ratings
By Level 8 Champion
Level 8 Champion

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?

Version history
Last update:
‎Sep 24, 2020 08:18 PM
Updated by: