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


The ReadContainerImages ManageSoft reader executed during the inventory import process may fail with errors such as:


2020-07-09 01:23:21,130 [INFO ] ReadContainerInstances (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.3) 2020-07-09 01:23:21,276 [INFO ] Failed to execute Reader 'ReadContainerInstances' from file \\batchsvr\batchdata\Flexera Software\Compliance\ImportProcedures\Inventory\\Reader\managesoft\Container.xml, at step line 1 Error: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. [...]
2020-07-09 01:23:21,424 [ERROR] System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.


This issue is caused by long values retrieved from the HardwareVaues.Value column in the inventory database (which has type nvarchar(max)) being inserted into target fields in the ImportedContainerInstance table in the compliance database (which have type nvarchar(256)) without being truncated.

This issue can potentially affect data inserted into the following fields in the ImportedContainerInstance table:

  • ContainerId
  • Name
  • ImageTag
  • EntryPoint
  • Cmd
  • Status


This issue can be avoided by upgrading to a FlexNet Manager Suite version that contains a fix for this issue.

Alternatively, the issue can be fixed by updating the SQL query in the ReadContainerInstances reader in the C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ManageSoft\Container.xml file so that long values are truncated to a length that is suitable for storing in the the ImportedContainerInstance table.

For example, change the expressions for the following columns returned from the SQL SELECT statement in this query to the following:

LEFT(v_id.Value, 256) AS [ContainerID],
LEFT(v_name.Value, 256) AS [Name],
LEFT(v_imagetag.Value, 256) AS [ImageTag],
CAST(v_cpu.Value AS floatAS [PartialNumberOfProcessors],
CAST(v_mem.Value AS bigintAS [TotalMemoryLimit],
LEFT(v_entryp.Value, 256) AS [Entrypoint],
LEFT(v_cmd.Value, 256) AS [Cmd],
LEFT(v_status.Value, 256) AS [Status],

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R1.1 / Sep 2020 (Cloud), 2020 R2 (On Premises)

Other information

Affected components: Containers, Inventory import (read/write/export)

Master issue ID: IOJ-2127108

Also known as: FNML-71147

Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jun 12, 2022 03:52 AM
Updated by:
Knowledge base article header content