Description
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 ..."
Resolution
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.
Related Articles
Red error bar accessing license Consumption tab with error in webui.log: "Conversion failed when converting the nvarchar v… 4Number of Views Known Issue: “WriteFileEvidence - Insert unmatched evidence” import writer step may fail with error due to NewFileEvidence… 65Number of Views Known Issue: “WriteFileEvidence - Insert unmatched evidence” import writer step may fail with error due to FileEvidenceFil… 42Number of Views The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value 49Number of Views "WriteFileEvidence - Insert unmatched evidence" import writer step may fail with error due to NewFileEvidence_MT.FileEvide… 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago