When performing a Compliance Import using FlexNet Manager Platform version 9.2 this fails with the error message below:
" Completed with error in 0 seconds.
FATAL: The import process has failed with the following error (use -verbose to see error details):
Error: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
String or binary data would be truncated.
Error Details:
System.InvalidOperationException
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
at ManageSoft.Compliance.Importer.Logic.DatabaseConnection.LoadData(IDataReader p_DataReader, String p_TableName, Int32 p_BatchSize)
at ManageSoft.Compliance.Importer.Logic.XML.SourceToTarget.ExecuteSQL(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.XML.Reader.Execute(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteReaders(ComplianceReader p_ComplianceReader, IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteComplianceReader(ComplianceReader p_ComplianceReader, Tenant tenant)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.RunImport()"
This error is caused by an issue in the "InstallerEvidence.xml" inventory reader which is located in the following location by default.
"C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ManageSoft"
The attached "InstallerEvidence.xml" can be used to resolve the issue, please follow the steps below to apply the updated "InstallerEvidence.xml" file to the system.
The above issue has been assigned the reference number PA 79554 and is scheduled to be resolved in a future release. For an update on the issue please contact Technical Support with the PA number referenced above.
Jun 05, 2013 05:13 AM